select * from pg_stat_sys_tables where relname = 'pg_class'; -[ RECORD 1 ]-------+----------- relid | 1259 schemaname | pg_catalog relname | pg_class seq_scan | 1838 seq_tup_read | 3177416 idx_scan | 1027456557 idx_tup_fetch | 959682909 n_tup_ins | 0 n_tup_upd | 0 n_tup_del | 0 n_tup_hot_upd | 0 n_live_tup | 0 n_dead_tup | 0 n_mod_since_analyze | 0 last_vacuum | last_autovacuum | last_analyze | last_autoanalyze | vacuum_count | 0 autovacuum_count | 0 analyze_count | 0 autoanalyze_count | 0
Yes, the size of pg_class table is of 5 GB. However, the existing row is only 2380 only. It's got fragmented. ________________________________ From: Adrian Klaver <adrian.kla...@aklaver.com> Sent: Thursday, November 17, 2016 8:29 PM To: dhaval jaiswal; David G. Johnston Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_class (system) table increasing size. On 11/16/2016 07:08 PM, dhaval jaiswal wrote: > >>> Because you are creating (specific) objects. > > I have gone through the link and how would i figure out which > specific object is causing this. Can you please elaborate more here. > > > We do not have the much temporary table usage. > > > Since the size is bigger (5 GB) to maintain. does it requires > maintenance as well for thepg_class. Should have added to my previous post. What does: select * from pg_stat_sys_tables where relname = 'pg_class'; show? > > > It seems its affecting performance. > > -- Adrian Klaver adrian.kla...@aklaver.com