public inbox for [email protected]
help / color / mirror / Atom feedmany deletes and inserts on pg_class, total rows is 14200 rows in "pg_class", any idea why so many inserts/deletes on "pg_class" it's self?
2+ messages / 2 participants
[nested] [flat]
* many deletes and inserts on pg_class, total rows is 14200 rows in "pg_class", any idea why so many inserts/deletes on "pg_class" it's self?
@ 2025-06-24 14:22 James Pang <[email protected]>
2025-06-24 14:31 ` Re: many deletes and inserts on pg_class, total rows is 14200 rows in "pg_class", any idea why so many inserts/deletes on "pg_class" it's self? David G. Johnston <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: James Pang @ 2025-06-24 14:22 UTC (permalink / raw)
To: [email protected]
-[ RECORD 1 ]-------+------------------------------
relid | 1259
schemaname | pg_catalog
relname | pg_class
seq_scan | 22173212
seq_tup_read | 153735849586
idx_scan | 12471735164
idx_tup_fetch | 12193538267
n_tup_ins | 3604618 <<<hehre
n_tup_upd | 617627
n_tup_del | 3605790 <<< here
n_tup_hot_upd | 566022
n_live_tup | 14252
n_dead_tup | 1257
n_mod_since_analyze | 52
n_ins_since_vacuum | 1119
last_vacuum | 2025-06-24 02:20:28.852129+00
last_autovacuum | 2025-06-24 11:39:14.281472+00
last_analyze | 2025-06-24 02:20:28.929375+00
last_autoanalyze | 2025-06-24 14:15:53.545063+00
vacuum_count | 367
autovacuum_count | 24628
analyze_count | 367
autoanalyze_count | 8904
Thanks,
James
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: many deletes and inserts on pg_class, total rows is 14200 rows in "pg_class", any idea why so many inserts/deletes on "pg_class" it's self?
2025-06-24 14:22 many deletes and inserts on pg_class, total rows is 14200 rows in "pg_class", any idea why so many inserts/deletes on "pg_class" it's self? James Pang <[email protected]>
@ 2025-06-24 14:31 ` David G. Johnston <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2025-06-24 14:31 UTC (permalink / raw)
To: James Pang <[email protected]>; +Cc: [email protected] <[email protected]>
You use temporary tables extensively.
>
>
David J.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-06-24 14:31 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-06-24 14:22 many deletes and inserts on pg_class, total rows is 14200 rows in "pg_class", any idea why so many inserts/deletes on "pg_class" it's self? James Pang <[email protected]>
2025-06-24 14:31 ` David G. Johnston <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox