Hi,
I've been checking progress on barnacle, one of the animals running with
CLOBBER_CACHE_RECURSIVELY. It's running for ~170 days (250k minutes).
This time I've however checked the log, and what caught my eye is that
the last log message is from November. There were regular messages until
then (a few messages per day), but since Nov 19 there's nothing.
The last few messages are these:
2014-11-28 22:19:24 CET 7953 [540097d4.1f11:532] LOG: statement: CREATE
FUNCTION city_insert() RETURNS trigger LANGUAGE plpgsql AS $$
2014-11-28 22:19:27 CET 7953 [540097d4.1f11:533] LOG: statement: CREATE
TRIGGER city_insert_trig INSTEAD OF INSERT ON city_view
2014-11-28 22:25:13 CET 7953 [540097d4.1f11:534] LOG: statement: CREATE
FUNCTION city_delete() RETURNS trigger LANGUAGE plpgsql AS $$
2014-11-28 22:25:15 CET 7953 [540097d4.1f11:535] LOG: statement: CREATE
TRIGGER city_delete_trig INSTEAD OF DELETE ON city_view
2014-11-29 03:10:01 CET 7953 [540097d4.1f11:536] LOG: statement: CREATE
FUNCTION city_update() RETURNS trigger LANGUAGE plpgsql AS $$
2014-11-29 03:10:03 CET 7953 [540097d4.1f11:537] LOG: statement: CREATE
TRIGGER city_update_trig INSTEAD OF UPDATE ON city_view
2014-11-29 07:44:50 CET 7953 [540097d4.1f11:538] LOG: statement: INSERT
INTO city_view(city_name) VALUES('Tokyo') RETURNING *;
which matches commands halfway-through 'triggers' tests.
There are currently two queries running - one from 'triggers', one from
'updatable_views':
-[ RECORD 1 ]----+----------------------------------------------
datid | 16384
datname | regression
pid | 7953
usesysid | 10
usename | pgbuild
application_name | pg_regress
client_addr |
client_hostname |
client_port | -1
backend_start | 2014-08-29 17:10:12.243979+02
xact_start | 2014-11-29 07:44:50.452678+01
query_start | 2014-11-29 07:44:50.452678+01
state_change | 2014-11-29 07:44:50.45268+01
waiting | f
state | active
backend_xid |
backend_xmin | 3989
query | INSERT INTO city_view(city_name) VALUES('Tokyo')
RETURNING *;
-[ RECORD 2 ]----+----------------------------------------------
datid | 16384
datname | regression
pid | 7956
usesysid | 10
usename | pgbuild
application_name | pg_regress
client_addr |
client_hostname |
client_port | -1
backend_start | 2014-08-29 17:10:12.272223+02
xact_start | 2014-10-06 15:35:25.822488+02
query_start | 2014-10-06 15:35:25.822488+02
state_change | 2014-10-06 15:35:25.822491+02
waiting | f
state | active
backend_xid |
backend_xmin | 3862
query | UPDATE rw_view2 SET b='Row three' WHERE a=3 RETURNING *;
Top currently looks like this:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
7956 pgbuild 20 0 242m 13m 10m R 98.8 0.2 251152:27 postgres:
pgbuild regression [local] UPDATE
7953 pgbuild 20 0 1023m 785m 11m R 98.4 10.0 248806:18 postgres:
pgbuild regression [local] INSERT
Both backends started on August 29, but the 'updatable_views' query is
running since October 6. 5 months seems like a rather long runtime, even
with CLOBBER_CACHE_RECURSIVELY).
Not sure if it's relevant, but this is the machine with Intel C compiler
(2013).
Attached is a memory context info for the 7953 backend (with more than
1GB VIRT) - not sure if it's relevant, so just in case.
--
Tomas Vondra http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
TopMemoryContext: 160096 total in 21 blocks; 11208 free (32 chunks); 148888 used
PL/pgSQL function context: 122880 total in 4 blocks; 100064 free (121 chunks); 22816 used
TopTransactionContext: 8192 total in 1 blocks; 5920 free (19 chunks); 2272 used
ExecutorState: 8192 total in 1 blocks; 7288 free (0 chunks); 904 used
ExprContext: 8192 total in 1 blocks; 8160 free (0 chunks); 32 used
SPI Exec: 65536 total in 4 blocks; 52904 free (271 chunks); 12632 used
ExecutorState: 57344 total in 3 blocks; 46704 free (343 chunks); 10640 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 65704 total in 4 blocks; 39744 free (113 chunks); 25960 used
SPI Proc: 57344 total in 3 blocks; 38752 free (206 chunks); 18592 used
SPI TupTable: 8192 total in 1 blocks; 6744 free (0 chunks); 1448 used
PL/pgSQL function context: 57344 total in 3 blocks; 34912 free (5 chunks); 22432 used
PL/pgSQL function context: 24576 total in 2 blocks; 14784 free (89 chunks); 9792 used
PL/pgSQL function context: 57344 total in 3 blocks; 34656 free (12 chunks); 22688 used
PL/pgSQL function context: 57344 total in 3 blocks; 31464 free (21 chunks); 25880 used
PL/pgSQL function context: 57344 total in 3 blocks; 45504 free (160 chunks); 11840 used
PL/pgSQL function context: 24576 total in 2 blocks; 12768 free (101 chunks); 11808 used
PL/pgSQL function context: 57344 total in 3 blocks; 46600 free (136 chunks); 10744 used
PL/pgSQL function context: 24576 total in 2 blocks; 13960 free (81 chunks); 10616 used
PL/pgSQL function context: 33546240 total in 13 blocks; 7670520 free (73 chunks); 25875720 used
PL/pgSQL function context: 57344 total in 3 blocks; 31616 free (80 chunks); 25728 used
RI compare cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used
RI query cache: 8192 total in 1 blocks; 2664 free (0 chunks); 5528 used
RI constraint cache: 40696 total in 2 blocks; 3712 free (0 chunks); 36984 used
PL/pgSQL function context: 57344 total in 3 blocks; 47672 free (279 chunks); 9672 used
PL/pgSQL function context: 24576 total in 2 blocks; 15064 free (88 chunks); 9512 used
Sequence values: 8192 total in 1 blocks; 2664 free (0 chunks); 5528 used
PL/pgSQL function context: 33546240 total in 13 blocks; 32176 free (72 chunks); 33514064 used
PL/pgSQL function context: 24576 total in 2 blocks; 14992 free (90 chunks); 9584 used
Type information cache: 24248 total in 2 blocks; 3712 free (0 chunks); 20536 used
PL/pgSQL function context: 67100672 total in 17 blocks; 4549512 free (146 chunks); 62551160 used
PL/pgSQL function context: 24576 total in 2 blocks; 14824 free (88 chunks); 9752 used
Rendezvous variable hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used
PLpgSQL function cache: 24528 total in 2 blocks; 3712 free (0 chunks); 20816 used
TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used
Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used
CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used
MessageContext: 65536 total in 4 blocks; 48288 free (174 chunks); 17248 used
Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used
smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used
TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used
Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used
PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used
PortalHoldContext: 24576 total in 2 blocks; 15736 free (5 chunks); 8840 used
PortalHeapMemory: 16384 total in 4 blocks; 14864 free (106 chunks); 1520 used
ExecutorState: 57344 total in 3 blocks; 49184 free (231 chunks); 8160 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
Relcache by OID: 24576 total in 2 blocks; 15896 free (2 chunks); 8680 used
CacheMemoryContext: 2088960 total in 8 blocks; 949960 free (207 chunks); 1139000 used
pg_attrdef_adrelid_adnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used
city_view: 15360 total in 4 blocks; 6072 free (1 chunks); 9288 used
city_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
city_table_pkey: 1024 total in 1 blocks; 144 free (0 chunks); 880 used
CachedPlan: 7168 total in 3 blocks; 2640 free (0 chunks); 4528 used
CachedPlanSource: 64512 total in 6 blocks; 60832 free (227 chunks); 3680 used
CachedPlanQuery: 64512 total in 6 blocks; 60904 free (237 chunks); 3608 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 168 free (0 chunks); 856 used
CachedPlanSource: 64512 total in 6 blocks; 62848 free (225 chunks); 1664 used
CachedPlanQuery: 64512 total in 6 blocks; 63416 free (237 chunks); 1096 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 192 free (0 chunks); 832 used
CachedPlanSource: 64512 total in 6 blocks; 63200 free (227 chunks); 1312 used
CachedPlanQuery: 64512 total in 6 blocks; 63440 free (237 chunks); 1072 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 168 free (0 chunks); 856 used
CachedPlanSource: 64512 total in 6 blocks; 62808 free (225 chunks); 1704 used
CachedPlanQuery: 64512 total in 6 blocks; 63416 free (237 chunks); 1096 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
city_view: 15360 total in 4 blocks; 6072 free (1 chunks); 9288 used
CachedPlanSource: 15360 total in 4 blocks; 11560 free (109 chunks); 3800 used
CachedPlanQuery: 15360 total in 4 blocks; 10296 free (116 chunks); 5064 used
SPI Plan: 1024 total in 1 blocks; 776 free (0 chunks); 248 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
main_view: 7168 total in 3 blocks; 3472 free (0 chunks); 3696 used
CachedPlan: 1024 total in 1 blocks; 136 free (0 chunks); 888 used
CachedPlanSource: 31744 total in 5 blocks; 30392 free (168 chunks); 1352 used
CachedPlanQuery: 31744 total in 5 blocks; 30648 free (177 chunks); 1096 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlan: 3072 total in 2 blocks; 720 free (0 chunks); 2352 used
CachedPlanSource: 31744 total in 5 blocks; 30184 free (167 chunks); 1560 used
CachedPlanQuery: 31744 total in 5 blocks; 30744 free (177 chunks); 1000 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlanSource: 31744 total in 5 blocks; 30184 free (167 chunks); 1560 used
CachedPlanQuery: 31744 total in 5 blocks; 30744 free (177 chunks); 1000 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 31744 total in 5 blocks; 29256 free (166 chunks); 2488 used
CachedPlanQuery: 31744 total in 5 blocks; 29064 free (174 chunks); 2680 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 1047552 total in 10 blocks; 349728 free (111 chunks); 697824 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 192 free (0 chunks); 832 used
CachedPlanSource: 1047552 total in 10 blocks; 350232 free (111 chunks); 697320 used
CachedPlanQuery: 8387584 total in 13 blocks; 2785328 free (111 chunks); 5602256 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 160 free (0 chunks); 864 used
CachedPlanSource: 1047552 total in 10 blocks; 350200 free (110 chunks); 697352 used
CachedPlanQuery: 8387584 total in 13 blocks; 2785296 free (111 chunks); 5602288 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 224 free (0 chunks); 800 used
CachedPlanSource: 1047552 total in 10 blocks; 350056 free (109 chunks); 697496 used
CachedPlanQuery: 8387584 total in 13 blocks; 2785360 free (112 chunks); 5602224 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 224 free (0 chunks); 800 used
CachedPlanSource: 1047552 total in 10 blocks; 350040 free (110 chunks); 697512 used
CachedPlanQuery: 8387584 total in 13 blocks; 2785360 free (112 chunks); 5602224 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 224 free (0 chunks); 800 used
CachedPlanSource: 1047552 total in 10 blocks; 350040 free (110 chunks); 697512 used
CachedPlanQuery: 8387584 total in 13 blocks; 2785360 free (112 chunks); 5602224 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 224 free (0 chunks); 800 used
CachedPlanSource: 1047552 total in 10 blocks; 350040 free (110 chunks); 697512 used
CachedPlanQuery: 8387584 total in 13 blocks; 2785360 free (112 chunks); 5602224 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlanSource: 1047552 total in 10 blocks; 350064 free (109 chunks); 697488 used
CachedPlanQuery: 8387584 total in 13 blocks; 2785368 free (111 chunks); 5602216 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlanSource: 1047552 total in 10 blocks; 350064 free (109 chunks); 697488 used
CachedPlanQuery: 8387584 total in 13 blocks; 2785368 free (111 chunks); 5602216 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 224 free (0 chunks); 800 used
CachedPlanSource: 1047552 total in 10 blocks; 350056 free (109 chunks); 697496 used
CachedPlanQuery: 8387584 total in 13 blocks; 2785360 free (112 chunks); 5602224 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlanSource: 1047552 total in 10 blocks; 350064 free (109 chunks); 697488 used
CachedPlanQuery: 8387584 total in 13 blocks; 2785368 free (111 chunks); 5602216 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlanSource: 1047552 total in 10 blocks; 350064 free (109 chunks); 697488 used
CachedPlanQuery: 8387584 total in 13 blocks; 2785368 free (111 chunks); 5602216 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 136 free (0 chunks); 888 used
CachedPlanSource: 1047552 total in 10 blocks; 349720 free (108 chunks); 697832 used
CachedPlanQuery: 8387584 total in 13 blocks; 2785272 free (110 chunks); 5602312 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 224 free (0 chunks); 800 used
CachedPlan: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlan: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlan: 1024 total in 1 blocks; 224 free (0 chunks); 800 used
CachedPlanSource: 3072 total in 2 blocks; 1656 free (0 chunks); 1416 used
CachedPlanQuery: 31744 total in 5 blocks; 29448 free (321 chunks); 2296 used
SPI Plan: 1024 total in 1 blocks; 776 free (0 chunks); 248 used
CachedPlanSource: 31744 total in 5 blocks; 28968 free (298 chunks); 2776 used
CachedPlanQuery: 31744 total in 5 blocks; 29224 free (309 chunks); 2520 used
SPI Plan: 1024 total in 1 blocks; 776 free (0 chunks); 248 used
CachedPlanSource: 31744 total in 5 blocks; 30288 free (295 chunks); 1456 used
CachedPlanQuery: 31744 total in 5 blocks; 30736 free (311 chunks); 1008 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 31744 total in 5 blocks; 30296 free (295 chunks); 1448 used
CachedPlanQuery: 31744 total in 5 blocks; 30744 free (310 chunks); 1000 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 31744 total in 5 blocks; 30296 free (295 chunks); 1448 used
CachedPlanQuery: 31744 total in 5 blocks; 30744 free (310 chunks); 1000 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 31744 total in 5 blocks; 30272 free (296 chunks); 1472 used
CachedPlanQuery: 31744 total in 5 blocks; 30736 free (311 chunks); 1008 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlan: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlan: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlan: 3072 total in 2 blocks; 1976 free (1 chunks); 1096 used
CachedPlanSource: 4193280 total in 12 blocks; 2103968 free (98 chunks); 2089312 used
CachedPlanQuery: 25164800 total in 15 blocks; 8360600 free (101 chunks); 16804200 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 4193280 total in 12 blocks; 2103968 free (98 chunks); 2089312 used
CachedPlanQuery: 25164800 total in 15 blocks; 8360600 free (101 chunks); 16804200 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 4193280 total in 12 blocks; 2103968 free (98 chunks); 2089312 used
CachedPlanQuery: 25164800 total in 15 blocks; 8360600 free (101 chunks); 16804200 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 4193280 total in 12 blocks; 2103688 free (98 chunks); 2089592 used
CachedPlanQuery: 25164800 total in 15 blocks; 8360328 free (102 chunks); 16804472 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlan: 1024 total in 1 blocks; 192 free (0 chunks); 832 used
CachedPlan: 1024 total in 1 blocks; 224 free (0 chunks); 800 used
CachedPlan: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlan: 1024 total in 1 blocks; 232 free (0 chunks); 792 used
CachedPlan: 3072 total in 2 blocks; 1976 free (1 chunks); 1096 used
CachedPlanSource: 4193280 total in 12 blocks; 294848 free (173 chunks); 3898432 used
CachedPlanQuery: 41942016 total in 17 blocks; 2733872 free (184 chunks); 39208144 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 4193280 total in 12 blocks; 294672 free (171 chunks); 3898608 used
CachedPlanQuery: 41942016 total in 17 blocks; 2733904 free (185 chunks); 39208112 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 4193280 total in 12 blocks; 294680 free (171 chunks); 3898600 used
CachedPlanQuery: 41942016 total in 17 blocks; 2733912 free (184 chunks); 39208104 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 4193280 total in 12 blocks; 294680 free (171 chunks); 3898600 used
CachedPlanQuery: 41942016 total in 17 blocks; 2733912 free (184 chunks); 39208104 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 4193280 total in 12 blocks; 294400 free (169 chunks); 3898880 used
CachedPlanQuery: 41942016 total in 17 blocks; 2733640 free (185 chunks); 39208376 used
SPI Plan: 1024 total in 1 blocks; 808 free (0 chunks); 216 used
CachedPlanSource: 8387584 total in 13 blocks; 230512 free (215 chunks); 8157072 used
CachedPlanQuery: 67107840 total in 20 blocks; 3406440 free (227 chunks); 63701400 used
SPI Plan: 1024 total in 1 blocks; 776 free (0 chunks); 248 used
EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used
Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used
pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used
pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used
pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used
pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used
pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used
pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used
pg_rewrite_rel_rulename_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used
pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used
pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used
pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used
pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used
pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used
MdSmgr: 8192 total in 1 blocks; 8080 free (3 chunks); 112 used
ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used
hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used
LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used
Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used
ErrorContext: 8192 total in 1 blocks; 8160 free (6 chunks); 32 used
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
