PG Dump

TopMemoryContext: 91728 total in 5 blocks; 18232 free (11 chunks); 73496 used PrivateRefCount: 8192 total in 1 blocks; 2840 free (0 chunks); 5352 used MdSmgr: 0 total in 0 blocks; 0 free (0 chunks); 0 used LOCALLOCK hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used Timezones: 104120 total in 2 blocks; 2840 free (0 chunks); 101280 used 2018-06-18 15:02:22 EDT,4554,,ERROR: could not load library "/usr/lib/postgresql/10/lib/auto_explain.so": /usr/lib/postgresql/10/lib/auto_explain.so: failed to map segment from shared object ErrorContext: 8192 total in 1 blocks; 8152 free (4 chunks); 40 used Grand total: 220424 bytes in 10 blocks; 32840 free (15 chunks); 187584 used 2018-06-18 15:02:22 EDT,16688,,LOG: could not fork worker process: Cannot allocate memory 2018-06-18 15:02:22 EDT,4555,,ERROR: out of memory 2018-06-18 15:02:22 EDT,4555,,DETAIL: Failed on request of size 78336. 2018-06-18 15:02:22 EDT,4552,,LOG: could not open directory "/usr/lib/postgresql/10/share/timezone": Cannot allocate memory 2018-06-18 15:02:22 EDT,19935,mydb,ERROR: could not load library "/usr/lib/postgresql/10/lib/auto_explain.so": /usr/lib/postgresql/10/lib/auto_explain.so: failed to map segment from shared object 2018-06-18 15:02:22 EDT,19935,mydb,CONTEXT: parallel worker 2018-06-18 15:02:22 EDT,19935,mydb,STATEMENT: select lmxp.legacy_mappable_id as id, lmxp.progserv_id as tms_id from showtimes.legacy_mappable lm, showtimes.legacy_mappable_x_progserv lmxp where lm.mapping_scheme_id = $1 AND lm.legacy_mappable_id = lmxp.legacy_mappable_id 2018-06-18 15:02:22 EDT,19934,mydb,ERROR: parallel worker failed to initialize 2018-06-18 15:02:22 EDT,19934,mydb,HINT: More details may be available in the server log. 2018-06-18 15:02:22 EDT,19934,mydb,STATEMENT: SELECT LMAI.legacy_mappable_id, LMAI.alternate_id_type_id, LMAI.alternate_id, AIT.alternate_id_type_name, AIT.alternate_id_type_tag FROM showtimes.legacy_mappable_alternate_id LMAI, showtimes.alternate_id_type AIT, showtimes.legacy_mappable LM WHERE LM.mapping_scheme_id = $1 AND LMAI.legacy_mappable_id = LM.legacy_mappable_id AND LMAI.alternate_id_type_id = AIT.alternate_id_type_id 2018-06-18 15:02:22 EDT,4552,,ERROR: invalid value for parameter "TimeZone": "America/New_York" 2018-06-18 15:02:22 EDT,26805,mydb,ERROR: invalid value for parameter "TimeZone": "America/New_York" 2018-06-18 15:02:22 EDT,26805,mydb,CONTEXT: parallel worker 2018-06-18 15:02:22 EDT,26805,mydb,STATEMENT: select lmxp.legacy_mappable_id as id, lmxp.progserv_id as tms_id from showtimes.legacy_mappable lm, showtimes.legacy_mappable_x_progserv lmxp where lm.mapping_scheme_id = $1 AND lm.legacy_mappable_id = lmxp.legacy_mappable_id 2018-06-18 15:02:22 EDT,20059,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.345364635" to 192120 bytes: No space left on device 2018-06-18 15:02:22 EDT,20059,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id 2018-06-18 15:02:22 EDT,16688,,LOG: worker process: parallel worker for PID 19935 (PID 4554) exited with exit code 1 2018-06-18 15:02:22 EDT,16688,,LOG: worker process: parallel worker for PID 19935 (PID 4555) exited with exit code 1 2018-06-18 15:02:22 EDT,16688,,LOG: worker process: parallel worker for PID 26805 (PID 4552) exited with exit code 1 TopMemoryContext: 91728 total in 5 blocks; 18232 free (11 chunks); 73496 used PrivateRefCount: 8192 total in 1 blocks; 2840 free (0 chunks); 5352 used MdSmgr: 0 total in 0 blocks; 0 free (0 chunks); 0 used LOCALLOCK hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used Timezones: 104120 total in 2 blocks; 2840 free (0 chunks); 101280 used ErrorContext: 8192 total in 1 blocks; 8152 free (4 chunks); 40 used Grand total: 220424 bytes in 10 blocks; 32840 free (15 chunks); 187584 used 2018-06-18 15:02:22 EDT,4553,,ERROR: out of memory 2018-06-18 15:02:22 EDT,4553,,DETAIL: Failed on request of size 78336. 2018-06-18 15:02:22 EDT,16688,,LOG: worker process: parallel worker for PID 26805 (PID 4553) exited with exit code 1 2018-06-18 15:02:22 EDT,19834,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.1597178331" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,19834,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id 2018-06-18 15:02:22 EDT,26815,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.1163637271" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,26815,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id 2018-06-18 15:02:22 EDT,26511,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.1811255838" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,26511,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id TopMemoryContext: 1213520 total in 15 blocks; 499024 free (164 chunks); 714496 used pgstat TabStatusArray lookup hash table: 24576 total in 2 blocks; 10736 free (3 chunks); 13840 used TopTransactionContext: 8192 total in 1 blocks; 2920 free (0 chunks); 5272 used SPI Exec: 8388608 total in 11 blocks; 1376944 free (7 chunks); 7011664 used ExecutorState: 4839000 total in 62 blocks; 2067592 free (9 chunks); 2771408 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 82152 total in 3 blocks; 0 free (0 chunks); 82152 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7840 free (0 chunks); 352 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used TupleSort main: 32824 total in 2 blocks; 7544 free (0 chunks); 25280 used Caller tuples: 8192 total in 1 blocks; 8072 free (0 chunks); 120 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Unique: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 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 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 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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 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 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 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (1 chunks); 40 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 ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 ExprContext: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 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 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 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: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used 59 more child contexts containing 114688 total in 14 blocks; 113368 free (6 chunks); 1320 used JoinRelHashTable: 24576 total in 2 blocks; 5680 free (3 chunks); 18896 used SPI Proc: 8192 total in 1 blocks; 7528 free (0 chunks); 664 used ExecutorState: 8192 total in 1 blocks; 7400 free (0 chunks); 792 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used AfterTriggerEvents: 8192 total in 1 blocks; 7112 free (1 chunks); 1080 used PL/pgSQL function context: 122880 total in 4 blocks; 51128 free (1 chunks); 71752 used PL/pgSQL function context: 24576 total in 2 blocks; 13320 free (2 chunks); 11256 used PL/pgSQL function context: 24576 total in 2 blocks; 13424 free (4 chunks); 11152 used PL/pgSQL function context: 24576 total in 2 blocks; 8632 free (2 chunks); 15944 used HandleParallelMessages: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used PL/pgSQL function context: 24576 total in 2 blocks; 10480 free (1 chunks); 14096 used PL/pgSQL function context: 8192 total in 1 blocks; 4984 free (1 chunks); 3208 used PL/pgSQL function context: 24576 total in 2 blocks; 7352 free (3 chunks); 17224 used PL/pgSQL function context: 122880 total in 4 blocks; 31144 free (2 chunks); 91736 used PL/pgSQL function context: 135008 total in 5 blocks; 28352 free (5 chunks); 106656 used PL/pgSQL function context: 24576 total in 2 blocks; 12328 free (1 chunks); 12248 used PL/pgSQL function context: 285640 total in 7 blocks; 62424 free (2 chunks); 223216 used Record information cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used Type information cache: 24472 total in 2 blocks; 2840 free (0 chunks); 21632 used PL/pgSQL function context: 57344 total in 3 blocks; 18544 free (4 chunks); 38800 used PLpgSQL cast info: 8192 total in 1 blocks; 6584 free (0 chunks); 1608 used PLpgSQL cast cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used PL/pgSQL function context: 57344 total in 3 blocks; 35352 free (6 chunks); 21992 used Function stat entries: 24576 total in 2 blocks; 15056 free (4 chunks); 9520 used CFuncHash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used Rendezvous variable hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PLpgSQL function cache: 137848 total in 2 blocks; 2840 free (0 chunks); 135008 used RI compare cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used RI query cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used RI constraint cache: 40888 total in 2 blocks; 2840 free (0 chunks); 38048 used Sequence values: 24576 total in 2 blocks; 16080 free (4 chunks); 8496 used Prepared Queries: 24576 total in 2 blocks; 6848 free (5 chunks); 17728 used TableSpace cache: 8192 total in 1 blocks; 2312 free (0 chunks); 5880 used Operator lookup cache: 24576 total in 2 blocks; 10976 free (5 chunks); 13600 used MessageContext: 8192 total in 1 blocks; 6968 free (0 chunks); 1224 used Operator class cache: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used smgr relation table: 122880 total in 4 blocks; 12528 free (13 chunks); 110352 used TransactionAbortContext: 32768 total in 1 blocks; 32728 free (0 chunks); 40 used Portal hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PortalMemory: 8192 total in 1 blocks; 7880 free (1 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 672 free (0 chunks); 352 used ExecutorState: 24576 total in 2 blocks; 12400 free (4 chunks); 12176 used printtup: 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: 57344 total in 3 blocks; 14520 free (8 chunks); 42824 used CacheMemoryContext: 9490568 total in 73 blocks; 3765488 free (1 chunks); 5725080 used CachedPlan: 1047552 total in 10 blocks; 348904 free (0 chunks); 698648 used CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used CachedPlanSource: 3072 total in 2 blocks; 1288 free (0 chunks); 1784 used unnamed prepared statement: 8192 total in 1 blocks; 2536 free (3 chunks); 5656 used CachedPlan: 64512 total in 6 blocks; 27712 free (0 chunks); 36800 used CachedPlanSource: 3072 total in 2 blocks; 96 free (0 chunks); 2976 used CachedPlanQuery: 3072 total in 2 blocks; 200 free (1 chunks); 2872 used CachedPlanSource: 15888 total in 3 blocks; 1160 free (0 chunks); 14728 used CachedPlanQuery: 64512 total in 6 blocks; 27544 free (1 chunks); 36968 used CachedPlanSource: 15360 total in 4 blocks; 5768 free (0 chunks); 9592 used CachedPlanQuery: 15360 total in 4 blocks; 1456 free (1 chunks); 13904 used update_flag: 1024 total in 1 blocks; 400 free (0 chunks); 624 used sked_lock_idx: 1024 total in 1 blocks; 264 free (0 chunks); 760 used entry_dt_idx: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlanSource: 7168 total in 3 blocks; 3240 free (1 chunks); 3928 used CachedPlanQuery: 7168 total in 3 blocks; 3680 free (1 chunks); 3488 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 130048 total in 7 blocks; 30216 free (0 chunks); 99832 used CachedPlanSource: 31744 total in 5 blocks; 15840 free (4 chunks); 15904 used CachedPlanQuery: 261120 total in 8 blocks; 73040 free (1 chunks); 188080 used CachedPlan: 1024 total in 1 blocks; 264 free (0 chunks); 760 used CachedPlanSource: 3072 total in 2 blocks; 1888 free (1 chunks); 1184 used CachedPlanQuery: 1024 total in 1 blocks; 200 free (1 chunks); 824 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 1776 free (0 chunks); 1296 used CachedPlanSource: 3072 total in 2 blocks; 1032 free (0 chunks); 2040 used CachedPlanQuery: 3072 total in 2 blocks; 1712 free (1 chunks); 1360 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlanSource: 7168 total in 3 blocks; 3384 free (2 chunks); 3784 used CachedPlanQuery: 7168 total in 3 blocks; 3384 free (1 chunks); 3784 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 1024 total in 1 blocks; 264 free (0 chunks); 760 used CachedPlanSource: 3072 total in 2 blocks; 1888 free (1 chunks); 1184 used CachedPlanQuery: 1024 total in 1 blocks; 200 free (1 chunks); 824 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlanSource: 15360 total in 4 blocks; 6048 free (0 chunks); 9312 used CachedPlanQuery: 15360 total in 4 blocks; 1912 free (1 chunks); 13448 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 1952 free (1 chunks); 1120 used CachedPlanSource: 3072 total in 2 blocks; 1224 free (0 chunks); 1848 used CachedPlanQuery: 3072 total in 2 blocks; 1680 free (1 chunks); 1392 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used IX_DBO_SKED_LOCK_T_10: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SKED_LOCK_T_9: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SKED_LOCK_T_8: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_SKED_LOCK_T_7: 1024 total in 1 blocks; 264 free (0 chunks); 760 used station_idx: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_SKED_LOCK_T_6: 1024 total in 1 blocks; 264 free (0 chunks); 760 used CachedPlanSource: 7168 total in 3 blocks; 3592 free (2 chunks); 3576 used CachedPlanQuery: 7168 total in 3 blocks; 3040 free (1 chunks); 4128 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 1472 free (0 chunks); 1600 used CachedPlanSource: 3072 total in 2 blocks; 592 free (0 chunks); 2480 used CachedPlanQuery: 3072 total in 2 blocks; 1200 free (1 chunks); 1872 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 1024 total in 1 blocks; 248 free (0 chunks); 776 used CachedPlanSource: 3072 total in 2 blocks; 1680 free (1 chunks); 1392 used CachedPlanQuery: 1024 total in 1 blocks; 184 free (1 chunks); 840 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 1024 total in 1 blocks; 248 free (0 chunks); 776 used CachedPlanSource: 3072 total in 2 blocks; 1680 free (1 chunks); 1392 used CachedPlanQuery: 1024 total in 1 blocks; 184 free (1 chunks); 840 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used CachedPlanSource: 3072 total in 2 blocks; 1720 free (0 chunks); 1352 used CachedPlanQuery: 1024 total in 1 blocks; 208 free (1 chunks); 816 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 1024 total in 1 blocks; 296 free (0 chunks); 728 used CachedPlanSource: 3072 total in 2 blocks; 1728 free (1 chunks); 1344 used CachedPlanQuery: 1024 total in 1 blocks; 232 free (1 chunks); 792 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 1024 total in 1 blocks; 296 free (0 chunks); 728 used CachedPlanSource: 3072 total in 2 blocks; 1728 free (1 chunks); 1344 used CachedPlanQuery: 1024 total in 1 blocks; 232 free (1 chunks); 792 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used IX_DBO_EDITOR_ASSIGNMENT_TYPE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_EDITOR_ASSIGNMENT_TYPE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_EDITOR_ASSIGNMENT_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used cur_editor_assignment: 138240 total in 19 blocks; 4120 free (2 chunks); 134120 used IX_DBO_MAPPABLE_PLACEHOLDER_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlanSource: 130048 total in 7 blocks; 51056 free (5 chunks); 78992 used CachedPlanQuery: 261120 total in 8 blocks; 94032 free (3 chunks); 167088 used CachedPlan: 7168 total in 3 blocks; 2800 free (0 chunks); 4368 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_1: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_TIMEZONE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_TIMEZONE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_4: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_7: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_3: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_2: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_6: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_5: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlan: 64512 total in 6 blocks; 5104 free (0 chunks); 59408 used CachedPlan: 130048 total in 7 blocks; 52128 free (0 chunks); 77920 used CachedPlan: 3072 total in 2 blocks; 1440 free (0 chunks); 1632 used CachedPlan: 7168 total in 3 blocks; 3656 free (0 chunks); 3512 used CachedPlan: 64512 total in 6 blocks; 4648 free (0 chunks); 59864 used CachedPlan: 7168 total in 3 blocks; 3744 free (0 chunks); 3424 used CachedPlan: 7168 total in 3 blocks; 2592 free (0 chunks); 4576 used CachedPlan: 7168 total in 3 blocks; 3104 free (0 chunks); 4064 used CachedPlan: 7168 total in 3 blocks; 3488 free (0 chunks); 3680 used CachedPlan: 7168 total in 3 blocks; 2880 free (0 chunks); 4288 used CachedPlan: 7168 total in 3 blocks; 3568 free (0 chunks); 3600 used CachedPlan: 7168 total in 3 blocks; 784 free (1 chunks); 6384 used CachedPlan: 7168 total in 3 blocks; 432 free (0 chunks); 6736 used CachedPlan: 31744 total in 5 blocks; 6176 free (0 chunks); 25568 used CachedPlan: 7168 total in 3 blocks; 3736 free (0 chunks); 3432 used CachedPlan: 31744 total in 5 blocks; 7800 free (0 chunks); 23944 used CachedPlan: 31744 total in 5 blocks; 6224 free (0 chunks); 25520 used CachedPlan: 31744 total in 5 blocks; 15344 free (0 chunks); 16400 used CachedPlan: 31744 total in 5 blocks; 14936 free (0 chunks); 16808 used 979 more child contexts containing 14872288 total in 2125 blocks; 4423776 free (314 chunks); 10448512 used WAL record construction: 49768 total in 2 blocks; 6584 free (0 chunks); 43184 used PrivateRefCount: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used MdSmgr: 24576 total in 2 blocks; 1240 free (3 chunks); 23336 used LOCALLOCK hash: 57344 total in 3 blocks; 10776 free (9 chunks); 46568 used Timezones: 104120 total in 2 blocks; 2840 free (0 chunks); 101280 used ErrorContext: 8192 total in 1 blocks; 8152 free (4 chunks); 40 used Grand total: 44434696 bytes in 2743 blocks; 14062120 free (665 chunks); 30372576 used TopMemoryContext: 1213520 total in 15 blocks; 499024 free (164 chunks); 714496 used pgstat TabStatusArray lookup hash table: 24576 total in 2 blocks; 10736 free (3 chunks); 13840 used TopTransactionContext: 8192 total in 1 blocks; 2920 free (0 chunks); 5272 used SPI Exec: 8388608 total in 11 blocks; 1376944 free (7 chunks); 7011664 used ExecutorState: 4839000 total in 62 blocks; 2067592 free (9 chunks); 2771408 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 82152 total in 3 blocks; 0 free (0 chunks); 82152 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7840 free (0 chunks); 352 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used TupleSort main: 32824 total in 2 blocks; 7544 free (0 chunks); 25280 used Caller tuples: 8192 total in 1 blocks; 8072 free (0 chunks); 120 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Unique: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 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 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 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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 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 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 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (1 chunks); 40 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 ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 ExprContext: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 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 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 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: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used 59 more child contexts containing 114688 total in 14 blocks; 113368 free (6 chunks); 1320 used JoinRelHashTable: 24576 total in 2 blocks; 5680 free (3 chunks); 18896 used SPI Proc: 8192 total in 1 blocks; 7528 free (0 chunks); 664 used ExecutorState: 8192 total in 1 blocks; 7400 free (0 chunks); 792 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used AfterTriggerEvents: 8192 total in 1 blocks; 7112 free (1 chunks); 1080 used PL/pgSQL function context: 122880 total in 4 blocks; 51128 free (1 chunks); 71752 used PL/pgSQL function context: 24576 total in 2 blocks; 13320 free (2 chunks); 11256 used PL/pgSQL function context: 24576 total in 2 blocks; 13424 free (4 chunks); 11152 used PL/pgSQL function context: 24576 total in 2 blocks; 8632 free (2 chunks); 15944 used HandleParallelMessages: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used PL/pgSQL function context: 24576 total in 2 blocks; 10480 free (1 chunks); 14096 used PL/pgSQL function context: 8192 total in 1 blocks; 4984 free (1 chunks); 3208 used PL/pgSQL function context: 24576 total in 2 blocks; 7352 free (3 chunks); 17224 used PL/pgSQL function context: 122880 total in 4 blocks; 31144 free (2 chunks); 91736 used PL/pgSQL function context: 135008 total in 5 blocks; 28352 free (5 chunks); 106656 used PL/pgSQL function context: 24576 total in 2 blocks; 12328 free (1 chunks); 12248 used PL/pgSQL function context: 285640 total in 7 blocks; 62424 free (2 chunks); 223216 used Record information cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used Type information cache: 24472 total in 2 blocks; 2840 free (0 chunks); 21632 used PL/pgSQL function context: 57344 total in 3 blocks; 18544 free (4 chunks); 38800 used PLpgSQL cast info: 8192 total in 1 blocks; 6584 free (0 chunks); 1608 used PLpgSQL cast cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used PL/pgSQL function context: 57344 total in 3 blocks; 35352 free (6 chunks); 21992 used Function stat entries: 24576 total in 2 blocks; 15056 free (4 chunks); 9520 used CFuncHash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used Rendezvous variable hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PLpgSQL function cache: 137848 total in 2 blocks; 2840 free (0 chunks); 135008 used RI compare cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used RI query cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used RI constraint cache: 40888 total in 2 blocks; 2840 free (0 chunks); 38048 used Sequence values: 24576 total in 2 blocks; 16080 free (4 chunks); 8496 used Prepared Queries: 24576 total in 2 blocks; 6848 free (5 chunks); 17728 used TableSpace cache: 8192 total in 1 blocks; 2312 free (0 chunks); 5880 used Operator lookup cache: 24576 total in 2 blocks; 10976 free (5 chunks); 13600 used MessageContext: 8192 total in 1 blocks; 6968 free (0 chunks); 1224 used Operator class cache: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used smgr relation table: 122880 total in 4 blocks; 12528 free (13 chunks); 110352 used TransactionAbortContext: 32768 total in 1 blocks; 32728 free (0 chunks); 40 used Portal hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PortalMemory: 8192 total in 1 blocks; 7880 free (1 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 672 free (0 chunks); 352 used ExecutorState: 24576 total in 2 blocks; 12400 free (4 chunks); 12176 used printtup: 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: 57344 total in 3 blocks; 14520 free (8 chunks); 42824 used CacheMemoryContext: 9490568 total in 73 blocks; 3765488 free (1 chunks); 5725080 used CachedPlan: 1047552 total in 10 blocks; 348904 free (0 chunks); 698648 used CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used CachedPlanSource: 3072 total in 2 blocks; 1288 free (0 chunks); 1784 used unnamed prepared statement: 8192 total in 1 blocks; 2536 free (3 chunks); 5656 used CachedPlan: 64512 total in 6 blocks; 27712 free (0 chunks); 36800 used CachedPlanSource: 3072 total in 2 blocks; 96 free (0 chunks); 2976 used CachedPlanQuery: 3072 total in 2 blocks; 200 free (1 chunks); 2872 used CachedPlanSource: 15888 total in 3 blocks; 1160 free (0 chunks); 14728 used CachedPlanQuery: 64512 total in 6 blocks; 27544 free (1 chunks); 36968 used CachedPlanSource: 15360 total in 4 blocks; 5768 free (0 chunks); 9592 used CachedPlanQuery: 15360 total in 4 blocks; 1456 free (1 chunks); 13904 used update_flag: 1024 total in 1 blocks; 400 free (0 chunks); 624 used sked_lock_idx: 1024 total in 1 blocks; 264 free (0 chunks); 760 used entry_dt_idx: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlanSource: 7168 total in 3 blocks; 3240 free (1 chunks); 3928 used CachedPlanQuery: 7168 total in 3 blocks; 3680 free (1 chunks); 3488 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 130048 total in 7 blocks; 30216 free (0 chunks); 99832 used CachedPlanSource: 31744 total in 5 blocks; 15840 free (4 chunks); 15904 used CachedPlanQuery: 261120 total in 8 blocks; 73040 free (1 chunks); 188080 used CachedPlan: 1024 total in 1 blocks; 264 free (0 chunks); 760 used CachedPlanSource: 3072 total in 2 blocks; 1888 free (1 chunks); 1184 used CachedPlanQuery: 1024 total in 1 blocks; 200 free (1 chunks); 824 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 1776 free (0 chunks); 1296 used CachedPlanSource: 3072 total in 2 blocks; 1032 free (0 chunks); 2040 used CachedPlanQuery: 3072 total in 2 blocks; 1712 free (1 chunks); 1360 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlanSource: 7168 total in 3 blocks; 3384 free (2 chunks); 3784 used CachedPlanQuery: 7168 total in 3 blocks; 3384 free (1 chunks); 3784 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 1024 total in 1 blocks; 264 free (0 chunks); 760 used CachedPlanSource: 3072 total in 2 blocks; 1888 free (1 chunks); 1184 used CachedPlanQuery: 1024 total in 1 blocks; 200 free (1 chunks); 824 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlanSource: 15360 total in 4 blocks; 6048 free (0 chunks); 9312 used CachedPlanQuery: 15360 total in 4 blocks; 1912 free (1 chunks); 13448 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 1952 free (1 chunks); 1120 used CachedPlanSource: 3072 total in 2 blocks; 1224 free (0 chunks); 1848 used CachedPlanQuery: 3072 total in 2 blocks; 1680 free (1 chunks); 1392 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used IX_DBO_SKED_LOCK_T_10: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SKED_LOCK_T_9: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SKED_LOCK_T_8: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_SKED_LOCK_T_7: 1024 total in 1 blocks; 264 free (0 chunks); 760 used station_idx: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_SKED_LOCK_T_6: 1024 total in 1 blocks; 264 free (0 chunks); 760 used CachedPlanSource: 7168 total in 3 blocks; 3592 free (2 chunks); 3576 used CachedPlanQuery: 7168 total in 3 blocks; 3040 free (1 chunks); 4128 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 1472 free (0 chunks); 1600 used CachedPlanSource: 3072 total in 2 blocks; 592 free (0 chunks); 2480 used CachedPlanQuery: 3072 total in 2 blocks; 1200 free (1 chunks); 1872 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 1024 total in 1 blocks; 248 free (0 chunks); 776 used CachedPlanSource: 3072 total in 2 blocks; 1680 free (1 chunks); 1392 used CachedPlanQuery: 1024 total in 1 blocks; 184 free (1 chunks); 840 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 1024 total in 1 blocks; 248 free (0 chunks); 776 used CachedPlanSource: 3072 total in 2 blocks; 1680 free (1 chunks); 1392 used CachedPlanQuery: 1024 total in 1 blocks; 184 free (1 chunks); 840 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used CachedPlanSource: 3072 total in 2 blocks; 1720 free (0 chunks); 1352 used CachedPlanQuery: 1024 total in 1 blocks; 208 free (1 chunks); 816 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 1024 total in 1 blocks; 296 free (0 chunks); 728 used CachedPlanSource: 3072 total in 2 blocks; 1728 free (1 chunks); 1344 used CachedPlanQuery: 1024 total in 1 blocks; 232 free (1 chunks); 792 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 1024 total in 1 blocks; 296 free (0 chunks); 728 used CachedPlanSource: 3072 total in 2 blocks; 1728 free (1 chunks); 1344 used CachedPlanQuery: 1024 total in 1 blocks; 232 free (1 chunks); 792 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used IX_DBO_EDITOR_ASSIGNMENT_TYPE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_EDITOR_ASSIGNMENT_TYPE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_EDITOR_ASSIGNMENT_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used cur_editor_assignment: 138240 total in 19 blocks; 4120 free (2 chunks); 134120 used IX_DBO_MAPPABLE_PLACEHOLDER_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlanSource: 130048 total in 7 blocks; 51056 free (5 chunks); 78992 used CachedPlanQuery: 261120 total in 8 blocks; 94032 free (3 chunks); 167088 used CachedPlan: 7168 total in 3 blocks; 2800 free (0 chunks); 4368 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_1: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_TIMEZONE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_TIMEZONE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_4: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_7: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_3: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_2: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_6: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_5: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlan: 64512 total in 6 blocks; 5104 free (0 chunks); 59408 used CachedPlan: 130048 total in 7 blocks; 52128 free (0 chunks); 77920 used CachedPlan: 3072 total in 2 blocks; 1440 free (0 chunks); 1632 used CachedPlan: 7168 total in 3 blocks; 3656 free (0 chunks); 3512 used CachedPlan: 64512 total in 6 blocks; 4648 free (0 chunks); 59864 used CachedPlan: 7168 total in 3 blocks; 3744 free (0 chunks); 3424 used CachedPlan: 7168 total in 3 blocks; 2592 free (0 chunks); 4576 used CachedPlan: 7168 total in 3 blocks; 3104 free (0 chunks); 4064 used CachedPlan: 7168 total in 3 blocks; 3488 free (0 chunks); 3680 used CachedPlan: 7168 total in 3 blocks; 2880 free (0 chunks); 4288 used CachedPlan: 7168 total in 3 blocks; 3568 free (0 chunks); 3600 used CachedPlan: 7168 total in 3 blocks; 784 free (1 chunks); 6384 used CachedPlan: 7168 total in 3 blocks; 432 free (0 chunks); 6736 used CachedPlan: 31744 total in 5 blocks; 6176 free (0 chunks); 25568 used CachedPlan: 7168 total in 3 blocks; 3736 free (0 chunks); 3432 used CachedPlan: 31744 total in 5 blocks; 7800 free (0 chunks); 23944 used CachedPlan: 31744 total in 5 blocks; 6224 free (0 chunks); 25520 used CachedPlan: 31744 total in 5 blocks; 15344 free (0 chunks); 16400 used CachedPlan: 31744 total in 5 blocks; 14936 free (0 chunks); 16808 used 979 more child contexts containing 14872288 total in 2125 blocks; 4423776 free (314 chunks); 10448512 used WAL record construction: 49768 total in 2 blocks; 6584 free (0 chunks); 43184 used PrivateRefCount: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used MdSmgr: 24576 total in 2 blocks; 1240 free (3 chunks); 23336 used LOCALLOCK hash: 57344 total in 3 blocks; 10776 free (9 chunks); 46568 used Timezones: 104120 total in 2 blocks; 2840 free (0 chunks); 101280 used ErrorContext: 8192 total in 1 blocks; 5992 free (2 chunks); 2200 used Grand total: 44434696 bytes in 2743 blocks; 14059960 free (663 chunks); 30374736 used 2018-06-18 15:02:22 EDT,28183,mydb,ERROR: out of memory 2018-06-18 15:02:22 EDT,28183,mydb,DETAIL: Failed on request of size 8192. TopMemoryContext: 689232 total in 14 blocks; 73688 free (289 chunks); 615544 used TopTransactionContext: 8192 total in 1 blocks; 7960 free (1 chunks); 232 used pgstat TabStatusArray lookup hash table: 24576 total in 2 blocks; 12816 free (3 chunks); 11760 used PL/pgSQL function context: 24576 total in 2 blocks; 13320 free (2 chunks); 11256 used PL/pgSQL function context: 24576 total in 2 blocks; 13424 free (4 chunks); 11152 used PL/pgSQL function context: 24576 total in 2 blocks; 10480 free (1 chunks); 14096 used PL/pgSQL function context: 8192 total in 1 blocks; 4984 free (1 chunks); 3208 used PL/pgSQL function context: 24576 total in 2 blocks; 7352 free (3 chunks); 17224 used PL/pgSQL function context: 122880 total in 4 blocks; 31144 free (2 chunks); 91736 used PL/pgSQL function context: 135008 total in 5 blocks; 28352 free (5 chunks); 106656 used PL/pgSQL function context: 24576 total in 2 blocks; 12328 free (1 chunks); 12248 used HandleParallelMessages: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used PL/pgSQL function context: 57344 total in 3 blocks; 18544 free (4 chunks); 38800 used PL/pgSQL function context: 57344 total in 3 blocks; 35352 free (6 chunks); 21992 used RI compare cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used RI query cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used RI constraint cache: 40888 total in 2 blocks; 2840 free (0 chunks); 38048 used Sequence values: 24576 total in 2 blocks; 16080 free (4 chunks); 8496 used Type information cache: 24472 total in 2 blocks; 2840 free (0 chunks); 21632 used PLpgSQL cast info: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PLpgSQL cast cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used PL/pgSQL function context: 285640 total in 7 blocks; 62424 free (2 chunks); 223216 used Function stat entries: 24576 total in 2 blocks; 15056 free (4 chunks); 9520 used CFuncHash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used Rendezvous variable hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PLpgSQL function cache: 137848 total in 2 blocks; 2840 free (0 chunks); 135008 used Record information cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used Prepared Queries: 24576 total in 2 blocks; 6848 free (5 chunks); 17728 used TableSpace cache: 8192 total in 1 blocks; 2312 free (0 chunks); 5880 used Operator lookup cache: 24576 total in 2 blocks; 10976 free (5 chunks); 13600 used MessageContext: 5242880 total in 11 blocks; 906128 free (7 chunks); 4336752 used JoinRelHashTable: 24576 total in 2 blocks; 15024 free (3 chunks); 9552 used Operator class cache: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used smgr relation table: 122880 total in 4 blocks; 22816 free (14 chunks); 100064 used TransactionAbortContext: 32768 total in 1 blocks; 32728 free (0 chunks); 40 used Portal hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PortalMemory: 8192 total in 1 blocks; 7880 free (1 chunks); 312 used PortalHeapMemory: 3456 total in 2 blocks; 760 free (0 chunks); 2696 used ExecutorState: 1040384 total in 7 blocks; 14408 free (9 chunks); 1025976 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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: 57344 total in 3 blocks; 17640 free (8 chunks); 39704 used CacheMemoryContext: 9480560 total in 72 blocks; 4170608 free (2 chunks); 5309952 used CachedPlan: 523264 total in 9 blocks; 167048 free (0 chunks); 356216 used IX_DBO_SNP_APOLLO_TYPE_MAP_1: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_SOURCE_TYPE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_TYPE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_EMPLOYEE_EMAIL_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_EDITOR_ASSIGNMENT_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_EDITOR_ASSIGNMENT_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_EDITOR_ASSIGNMENT_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_EDITOR_ASSIGNMENT_5: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_EDITOR_ASSIGNMENT_3: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_COUNTRY_NAME_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_COUNTRY_NAME_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_COUNTRY_NAME_1: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_REACH_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_REACH_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_REACH_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_REACH_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_REACH_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_X_CUSTOMIZATION_TYPE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_X_CUSTOMIZATION_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_X_CUSTOMIZATION_TYPE_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_X_CUSTOMIZATION_TYPE_2: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_CUSTOMIZATION_TYPE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_CUSTOMIZATION_TYPE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_CUSTOMIZATION_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_ATTRIBUTE_VALUE_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_ATTRIBUTE_TYPE_9: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_ATTRIBUTE_TYPE_8: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_ATTRIBUTE_TYPE_7: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_ATTRIBUTE_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_ATTRIBUTE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_ATTRIBUTE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_ATTRIBUTE_5: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_ATTRIBUTE_1: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_AFFILIATION_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_AFFILIATION_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_AFFILIATION_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_AFFILIATION_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_AFFILIATION_HISTORY_DETAIL_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_AFFILIATION_HISTORY_DETAIL_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_AFFILIATION_HISTORY_DETAIL_1: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_AFFILIATION_HISTORY_5: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_AFFILIATION_HISTORY_2: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_AFFILIATION_HISTORY_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlanSource: 64512 total in 6 blocks; 29952 free (4 chunks); 34560 used unnamed prepared statement: 516096 total in 6 blocks; 148376 free (13 chunks); 367720 used country_name: 7168 total in 3 blocks; 3336 free (0 chunks); 3832 used cur_affiliation_history: 15360 total in 4 blocks; 8120 free (0 chunks); 7240 used snp_country_reach: 56320 total in 9 blocks; 2880 free (0 chunks); 53440 used snp_attributes: 48128 total in 8 blocks; 8144 free (1 chunks); 39984 used snp_affiliation: 15360 total in 4 blocks; 3736 free (0 chunks); 11624 used snp_mydb_name: 15360 total in 4 blocks; 6760 free (0 chunks); 8600 used snp_profile_affil: 15360 total in 4 blocks; 3040 free (0 chunks); 12320 used apollo_affiliation: 15360 total in 4 blocks; 1032 free (0 chunks); 14328 used CachedPlanSource: 15360 total in 4 blocks; 5768 free (0 chunks); 9592 used CachedPlanQuery: 15360 total in 4 blocks; 1296 free (1 chunks); 14064 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_1: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_TIMEZONE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_TIMEZONE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_TYPE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_TYPE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_EDITING_LANGUAGE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_EDITING_LANGUAGE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_EDITING_LANGUAGE_3: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_SOURCE_FINDER_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_4: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_SOURCE_5: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_7: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_3: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_2: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_6: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_5: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_X_TYPE_6: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_PROGSERV_X_TYPE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_X_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_X_TYPE_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_X_TYPE_3: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used cur_progserv_x_type: 15360 total in 4 blocks; 5784 free (0 chunks); 9576 used CachedPlan: 31744 total in 5 blocks; 8328 free (0 chunks); 23416 used CachedPlanSource: 3072 total in 2 blocks; 1088 free (0 chunks); 1984 used CachedPlanQuery: 3072 total in 2 blocks; 1376 free (1 chunks); 1696 used CachedPlan: 7168 total in 3 blocks; 3904 free (0 chunks); 3264 used CachedPlanSource: 3072 total in 2 blocks; 1824 free (0 chunks); 1248 used CachedPlanQuery: 3072 total in 2 blocks; 1104 free (1 chunks); 1968 used CachedPlanSource: 31744 total in 5 blocks; 12120 free (0 chunks); 19624 used CachedPlanQuery: 64512 total in 6 blocks; 16048 free (1 chunks); 48464 used CachedPlanSource: 3072 total in 2 blocks; 912 free (0 chunks); 2160 used CachedPlanQuery: 3072 total in 2 blocks; 288 free (1 chunks); 2784 used CachedPlanSource: 3072 total in 2 blocks; 1000 free (0 chunks); 2072 used CachedPlanQuery: 7168 total in 3 blocks; 2960 free (1 chunks); 4208 used CachedPlanSource: 3072 total in 2 blocks; 1248 free (0 chunks); 1824 used CachedPlanQuery: 3072 total in 2 blocks; 616 free (1 chunks); 2456 used CachedPlanSource: 3072 total in 2 blocks; 1904 free (0 chunks); 1168 used CachedPlanQuery: 3072 total in 2 blocks; 936 free (1 chunks); 2136 used CachedPlan: 1024 total in 1 blocks; 248 free (0 chunks); 776 used CachedPlanSource: 3072 total in 2 blocks; 1624 free (0 chunks); 1448 used CachedPlanQuery: 1024 total in 1 blocks; 184 free (1 chunks); 840 used 816 more child contexts containing 11030240 total in 1792 blocks; 3328672 free (311 chunks); 7701568 used WAL record construction: 49768 total in 2 blocks; 6584 free (0 chunks); 43184 used PrivateRefCount: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used MdSmgr: 24576 total in 2 blocks; 3392 free (2 chunks); 21184 used LOCALLOCK hash: 57344 total in 3 blocks; 10776 free (9 chunks); 46568 used Timezones: 104120 total in 2 blocks; 2840 free (0 chunks); 101280 used ErrorContext: 8192 total in 1 blocks; 8152 free (4 chunks); 40 used Grand total: 30839856 bytes in 2186 blocks; 9485352 free (749 chunks); 21354504 used 2018-06-18 15:02:22 EDT,19708,mydb,ERROR: out of memory 2018-06-18 15:02:22 EDT,19708,mydb,DETAIL: Failed on request of size 7232. 2018-06-18 15:02:22 EDT,19708,mydb,STATEMENT: SELECT SOURCE.source_name, LEGACYCALLSIGN.call_sign_text as call_sign_text, LEGACYCALLSIGN.progserv_id as progserv_id, PS.source_id as source_id, PXT.timezone_id, PRIMARYEMPLOYEE.employee_id as primary_editor_id, PRIMARYEMPLOYEE.employee_first_name as primary_editor_first_name, PRIMARYEMPLOYEE.employee_last_name as primary_editor_last_name, PRIMARYEMPLOYEE.username as primary_editor_username, PRIMARYEMAIL.email_address as primary_email_address, TEMPORARYEMPLOYEE.employee_id as temporary_editor_id, TEMPORARYEMPLOYEE.employee_first_name as temporary_editor_first_name, TEMPORARYEMPLOYEE.employee_last_name as temporary_editor_last_name, TEMPORARYEMPLOYEE.username as temporary_editor_username, TEMPORARYEMAIL.email_address as temporary_email_address, AFFILIATION.pro_profile_affil as affiliation_name, PROGSERVTYPE.progserv_type_tag as progserv_type_tag, (select max(journal_lg_dt) from sources.journal_log where source_id = PS.source_id) as last_modified, (now()) as loaded_dt FROM sources.legacy_call_sign LEGACYCALLSIGN JOIN sources.progserv PS ON PS.progserv_id = LEGACYCALLSIGN.progserv_id JOIN sources.source SOURCE ON PS.source_id = SOURCE.source_id LEFT JOIN sources.progserv_x_timezone PXT ON PXT.progserv_id = PS.progserv_id LEFT JOIN sources.editor_assignment PRIMARYEDITOR ON PS.progserv_id = PRIMARYEDITOR.progserv_id AND PRIMARYEDITOR.editor_assignment_type_id = 6 LEFT JOIN sources.editor_assignment TEMPORARYEDITOR ON PS.progserv_id = TEMPORARYEDITOR.progserv_id AND TEMPORARYEDITOR.editor_assignment_type_id = 10 LEFT JOIN common.employee PRIMARYEMPLOYEE ON PRIMARYEDITOR.employee_id = PRIMARYEMPLOYEE.employee_id LEFT JOIN common.employee_email PRIMARYEMAIL ON PRIMARYEMPLOYEE.employee_id = PRIMARYEMAIL.employee_id LEFT JOIN common.employee TEMPORARYEMPLOYEE ON TEMPORARYEDITOR.employee_id = TEMPORARYEMPLOYEE.employee_id LEFT JOIN common.employee_email TEMPORARYEMAIL ON TEMPORARYEMPLOYEE.employee_id = TEMPORARYEMAIL.employee_id LEFT JOIN sources.apollo_affiliation AFFILIATION ON PS.progserv_id = AFFILIATION.progserv_id LEFT JOIN sources.cur_progserv_x_type PROGSERVXTYPE ON PS.progserv_id = PROGSERVXTYPE.progserv_id LEFT JOIN sources.progserv_type PROGSERVTYPE ON PROGSERVXTYPE.progserv_type_id = PROGSERVTYPE.progserv_type_id WHERE LEGACYCALLSIGN.progserv_id = $1 2018-06-18 15:02:22 EDT,28197,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.1552129380" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,28197,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id 2018-06-18 15:02:22 EDT,30643,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.515219748" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,30643,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id 2018-06-18 15:02:22 EDT,26927,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.330691766" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,26927,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id TopMemoryContext: 1213520 total in 15 blocks; 522480 free (164 chunks); 691040 used TopTransactionContext: 8192 total in 1 blocks; 2920 free (0 chunks); 5272 used SPI Exec: 8388608 total in 11 blocks; 1376944 free (7 chunks); 7011664 used ExecutorState: 4805760 total in 59 blocks; 2069184 free (8 chunks); 2736576 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 82152 total in 3 blocks; 0 free (0 chunks); 82152 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7840 free (0 chunks); 352 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used TupleSort main: 32824 total in 2 blocks; 7544 free (0 chunks); 25280 used Caller tuples: 8192 total in 1 blocks; 8072 free (0 chunks); 120 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Unique: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 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 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 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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 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 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 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (1 chunks); 40 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 ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 ExprContext: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 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 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 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: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used 59 more child contexts containing 90112 total in 11 blocks; 89008 free (6 chunks); 1104 used JoinRelHashTable: 24576 total in 2 blocks; 5680 free (3 chunks); 18896 used SPI Proc: 8192 total in 1 blocks; 7528 free (0 chunks); 664 used ExecutorState: 8192 total in 1 blocks; 7400 free (0 chunks); 792 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used AfterTriggerEvents: 8192 total in 1 blocks; 7112 free (1 chunks); 1080 used pgstat TabStatusArray lookup hash table: 24576 total in 2 blocks; 5552 free (3 chunks); 19024 used PL/pgSQL function context: 24576 total in 2 blocks; 14600 free (1 chunks); 9976 used PL/pgSQL function context: 57344 total in 3 blocks; 18544 free (4 chunks); 38800 used PL/pgSQL function context: 57344 total in 3 blocks; 35352 free (3 chunks); 21992 used HandleParallelMessages: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used PL/pgSQL function context: 24576 total in 2 blocks; 10480 free (1 chunks); 14096 used PL/pgSQL function context: 8192 total in 1 blocks; 4984 free (1 chunks); 3208 used PL/pgSQL function context: 24576 total in 2 blocks; 7352 free (3 chunks); 17224 used PL/pgSQL function context: 122880 total in 4 blocks; 31144 free (2 chunks); 91736 used PL/pgSQL function context: 135008 total in 5 blocks; 28352 free (5 chunks); 106656 used PL/pgSQL function context: 24576 total in 2 blocks; 12328 free (1 chunks); 12248 used RI compare cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used RI query cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used RI constraint cache: 40888 total in 2 blocks; 2840 free (0 chunks); 38048 used Sequence values: 24576 total in 2 blocks; 16080 free (4 chunks); 8496 used PL/pgSQL function context: 285640 total in 7 blocks; 62424 free (2 chunks); 223216 used Prepared Queries: 24576 total in 2 blocks; 6848 free (5 chunks); 17728 used PLpgSQL cast info: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PLpgSQL cast cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used PL/pgSQL function context: 24576 total in 2 blocks; 8632 free (2 chunks); 15944 used Function stat entries: 24576 total in 2 blocks; 15056 free (4 chunks); 9520 used CFuncHash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used Rendezvous variable hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PLpgSQL function cache: 137848 total in 2 blocks; 2840 free (0 chunks); 135008 used Record information cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used Type information cache: 24472 total in 2 blocks; 2840 free (0 chunks); 21632 used TableSpace cache: 8192 total in 1 blocks; 2312 free (0 chunks); 5880 used Operator lookup cache: 24576 total in 2 blocks; 10976 free (5 chunks); 13600 used MessageContext: 8192 total in 1 blocks; 6968 free (0 chunks); 1224 used Operator class cache: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used smgr relation table: 122880 total in 4 blocks; 16640 free (13 chunks); 106240 used TransactionAbortContext: 32768 total in 1 blocks; 32728 free (0 chunks); 40 used Portal hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PortalMemory: 8192 total in 1 blocks; 7880 free (1 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 672 free (0 chunks); 352 used ExecutorState: 24576 total in 2 blocks; 12400 free (4 chunks); 12176 used printtup: 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: 57344 total in 3 blocks; 15560 free (8 chunks); 41784 used CacheMemoryContext: 9581024 total in 78 blocks; 3850528 free (0 chunks); 5730496 used CachedPlan: 1047552 total in 10 blocks; 348904 free (0 chunks); 698648 used CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used CachedPlanSource: 3072 total in 2 blocks; 1288 free (0 chunks); 1784 used unnamed prepared statement: 8192 total in 1 blocks; 2536 free (3 chunks); 5656 used CachedPlan: 31744 total in 5 blocks; 15624 free (0 chunks); 16120 used CachedPlanSource: 31744 total in 5 blocks; 2744 free (0 chunks); 29000 used CachedPlanQuery: 31744 total in 5 blocks; 4824 free (1 chunks); 26920 used CachedPlanSource: 15360 total in 4 blocks; 6032 free (0 chunks); 9328 used CachedPlanQuery: 15360 total in 4 blocks; 2256 free (1 chunks); 13104 used CachedPlanSource: 3072 total in 2 blocks; 1176 free (0 chunks); 1896 used CachedPlanQuery: 7168 total in 3 blocks; 2168 free (1 chunks); 5000 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 2000 free (2 chunks); 1072 used CachedPlanSource: 3072 total in 2 blocks; 1448 free (0 chunks); 1624 used CachedPlanQuery: 3072 total in 2 blocks; 1936 free (1 chunks); 1136 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlanSource: 3072 total in 2 blocks; 592 free (0 chunks); 2480 used CachedPlanQuery: 7168 total in 3 blocks; 2504 free (5 chunks); 4664 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used CachedPlanSource: 15360 total in 4 blocks; 5768 free (0 chunks); 9592 used CachedPlanQuery: 15360 total in 4 blocks; 1456 free (1 chunks); 13904 used CachedPlanSource: 3072 total in 2 blocks; 344 free (0 chunks); 2728 used CachedPlanQuery: 7168 total in 3 blocks; 4048 free (1 chunks); 3120 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_1: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_TIMEZONE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_TIMEZONE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_4: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_7: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_3: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_2: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_6: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_5: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlan: 7168 total in 3 blocks; 3904 free (0 chunks); 3264 used CachedPlan: 7168 total in 3 blocks; 2936 free (0 chunks); 4232 used CachedPlan: 7168 total in 3 blocks; 3368 free (0 chunks); 3800 used CachedPlanSource: 3072 total in 2 blocks; 592 free (0 chunks); 2480 used CachedPlanQuery: 7168 total in 3 blocks; 2504 free (5 chunks); 4664 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used CachedPlanSource: 3072 total in 2 blocks; 1368 free (0 chunks); 1704 used CachedPlanQuery: 3072 total in 2 blocks; 376 free (1 chunks); 2696 used IX_DBO_CHANNEL_DAY_LOCK_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlan: 7168 total in 3 blocks; 2896 free (1 chunks); 4272 used CachedPlanSource: 3072 total in 2 blocks; 816 free (1 chunks); 2256 used CachedPlanQuery: 7168 total in 3 blocks; 3424 free (6 chunks); 3744 used CachedPlanSource: 3072 total in 2 blocks; 608 free (0 chunks); 2464 used CachedPlanQuery: 3072 total in 2 blocks; 312 free (5 chunks); 2760 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used CachedPlan: 15360 total in 4 blocks; 4904 free (0 chunks); 10456 used CachedPlan: 64512 total in 6 blocks; 5104 free (0 chunks); 59408 used CachedPlan: 130048 total in 7 blocks; 52128 free (0 chunks); 77920 used CachedPlan: 15360 total in 4 blocks; 6816 free (0 chunks); 8544 used CachedPlan: 31744 total in 5 blocks; 12880 free (0 chunks); 18864 used CachedPlan: 15360 total in 4 blocks; 1184 free (0 chunks); 14176 used CachedPlan: 15360 total in 4 blocks; 1160 free (0 chunks); 14200 used CachedPlan: 64512 total in 6 blocks; 1528 free (0 chunks); 62984 used CachedPlan: 31744 total in 5 blocks; 12496 free (1 chunks); 19248 used CachedPlan: 15360 total in 4 blocks; 1456 free (0 chunks); 13904 used CachedPlan: 15360 total in 4 blocks; 6584 free (0 chunks); 8776 used CachedPlan: 64512 total in 6 blocks; 11240 free (0 chunks); 53272 used CachedPlanSource: 7168 total in 3 blocks; 2496 free (0 chunks); 4672 used CachedPlanQuery: 15360 total in 4 blocks; 6280 free (2 chunks); 9080 used CachedPlan: 31744 total in 5 blocks; 8328 free (0 chunks); 23416 used CachedPlan: 7168 total in 3 blocks; 3624 free (0 chunks); 3544 used CachedPlan: 7168 total in 3 blocks; 3856 free (0 chunks); 3312 used CachedPlan: 7168 total in 3 blocks; 1104 free (0 chunks); 6064 used CachedPlan: 15360 total in 4 blocks; 3216 free (1 chunks); 12144 used CachedPlan: 7168 total in 3 blocks; 2928 free (0 chunks); 4240 used CachedPlan: 31744 total in 5 blocks; 9672 free (0 chunks); 22072 used CachedPlanSource: 15360 total in 4 blocks; 7208 free (1 chunks); 8152 used CachedPlanQuery: 15360 total in 4 blocks; 6384 free (1 chunks); 8976 used CachedPlanSource: 7168 total in 3 blocks; 1848 free (0 chunks); 5320 used CachedPlanQuery: 7168 total in 3 blocks; 424 free (1 chunks); 6744 used CachedPlanSource: 7168 total in 3 blocks; 1824 free (0 chunks); 5344 used CachedPlanQuery: 7168 total in 3 blocks; 400 free (1 chunks); 6768 used CachedPlanSource: 64512 total in 6 blocks; 25096 free (2 chunks); 39416 used CachedPlanQuery: 64512 total in 6 blocks; 14856 free (1 chunks); 49656 used CachedPlan: 31744 total in 5 blocks; 15952 free (0 chunks); 15792 used CachedPlan: 31744 total in 5 blocks; 15952 free (0 chunks); 15792 used CachedPlanSource: 15360 total in 4 blocks; 7768 free (3 chunks); 7592 used CachedPlanQuery: 15360 total in 4 blocks; 6896 free (2 chunks); 8464 used CachedPlanSource: 7168 total in 3 blocks; 2408 free (0 chunks); 4760 used CachedPlanQuery: 7168 total in 3 blocks; 936 free (1 chunks); 6232 used CachedPlanSource: 7168 total in 3 blocks; 2384 free (0 chunks); 4784 used CachedPlanQuery: 7168 total in 3 blocks; 912 free (1 chunks); 6256 used CachedPlanSource: 64512 total in 6 blocks; 25656 free (2 chunks); 38856 used CachedPlanQuery: 64512 total in 6 blocks; 15368 free (1 chunks); 49144 used CachedPlan: 31744 total in 5 blocks; 13944 free (0 chunks); 17800 used CachedPlanSource: 31744 total in 5 blocks; 6120 free (0 chunks); 25624 used CachedPlanQuery: 31744 total in 5 blocks; 8088 free (1 chunks); 23656 used CachedPlan: 3072 total in 2 blocks; 552 free (0 chunks); 2520 used CachedPlan: 7168 total in 3 blocks; 3088 free (0 chunks); 4080 used CachedPlan: 7168 total in 3 blocks; 2936 free (0 chunks); 4232 used CachedPlan: 7168 total in 3 blocks; 976 free (0 chunks); 6192 used CachedPlan: 64512 total in 6 blocks; 27352 free (0 chunks); 37160 used CachedPlan: 130048 total in 7 blocks; 22296 free (0 chunks); 107752 used CachedPlan: 64512 total in 6 blocks; 28768 free (0 chunks); 35744 used CachedPlan: 7168 total in 3 blocks; 2624 free (0 chunks); 4544 used CachedPlan: 7168 total in 3 blocks; 1280 free (0 chunks); 5888 used CachedPlan: 7168 total in 3 blocks; 2800 free (0 chunks); 4368 used CachedPlan: 7168 total in 3 blocks; 976 free (0 chunks); 6192 used CachedPlan: 7168 total in 3 blocks; 3856 free (0 chunks); 3312 used CachedPlan: 7168 total in 3 blocks; 3160 free (0 chunks); 4008 used CachedPlan: 7168 total in 3 blocks; 3728 free (0 chunks); 3440 used CachedPlan: 523264 total in 9 blocks; 75400 free (0 chunks); 447864 used CachedPlanSource: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used CachedPlanQuery: 3072 total in 2 blocks; 1072 free (1 chunks); 2000 used CachedPlanSource: 3072 total in 2 blocks; 1368 free (0 chunks); 1704 used CachedPlanQuery: 3072 total in 2 blocks; 328 free (1 chunks); 2744 used CachedPlanSource: 3072 total in 2 blocks; 632 free (0 chunks); 2440 used CachedPlanQuery: 7168 total in 3 blocks; 1632 free (1 chunks); 5536 used CachedPlanSource: 7168 total in 3 blocks; 3736 free (2 chunks); 3432 used CachedPlanQuery: 7168 total in 3 blocks; 1328 free (1 chunks); 5840 used CachedPlanSource: 3072 total in 2 blocks; 1232 free (0 chunks); 1840 used CachedPlanQuery: 7168 total in 3 blocks; 3672 free (1 chunks); 3496 used CachedPlan: 1024 total in 1 blocks; 264 free (0 chunks); 760 used CachedPlanSource: 3072 total in 2 blocks; 1888 free (1 chunks); 1184 used CachedPlanQuery: 1024 total in 1 blocks; 200 free (1 chunks); 824 used CachedPlanSource: 15360 total in 4 blocks; 1728 free (0 chunks); 13632 used CachedPlanQuery: 31744 total in 5 blocks; 13824 free (2 chunks); 17920 used CachedPlan: 130048 total in 7 blocks; 53056 free (0 chunks); 76992 used 932 more child contexts containing 14656224 total in 1968 blocks; 4506080 free (275 chunks); 10150144 used WAL record construction: 49768 total in 2 blocks; 6584 free (0 chunks); 43184 used PrivateRefCount: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used MdSmgr: 24576 total in 2 blocks; 1968 free (2 chunks); 22608 used LOCALLOCK hash: 57344 total in 3 blocks; 10776 free (9 chunks); 46568 used Timezones: 104120 total in 2 blocks; 2840 free (0 chunks); 101280 used ErrorContext: 8192 total in 1 blocks; 8152 free (4 chunks); 40 used Grand total: 44800632 bytes in 2693 blocks; 14308872 free (634 chunks); 30491760 used TopMemoryContext: 1213520 total in 15 blocks; 522480 free (164 chunks); 691040 used TopTransactionContext: 8192 total in 1 blocks; 2920 free (0 chunks); 5272 used SPI Exec: 8388608 total in 11 blocks; 1376944 free (7 chunks); 7011664 used ExecutorState: 4805760 total in 59 blocks; 2069184 free (8 chunks); 2736576 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 82152 total in 3 blocks; 0 free (0 chunks); 82152 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7840 free (0 chunks); 352 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used TupleSort main: 32824 total in 2 blocks; 7544 free (0 chunks); 25280 used Caller tuples: 8192 total in 1 blocks; 8072 free (0 chunks); 120 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Unique: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 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 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 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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 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 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 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (1 chunks); 40 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 ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 ExprContext: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 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 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 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: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used 59 more child contexts containing 90112 total in 11 blocks; 89008 free (6 chunks); 1104 used JoinRelHashTable: 24576 total in 2 blocks; 5680 free (3 chunks); 18896 used SPI Proc: 8192 total in 1 blocks; 7528 free (0 chunks); 664 used ExecutorState: 8192 total in 1 blocks; 7400 free (0 chunks); 792 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used AfterTriggerEvents: 8192 total in 1 blocks; 7112 free (1 chunks); 1080 used pgstat TabStatusArray lookup hash table: 24576 total in 2 blocks; 5552 free (3 chunks); 19024 used PL/pgSQL function context: 24576 total in 2 blocks; 14600 free (1 chunks); 9976 used PL/pgSQL function context: 57344 total in 3 blocks; 18544 free (4 chunks); 38800 used PL/pgSQL function context: 57344 total in 3 blocks; 35352 free (3 chunks); 21992 used HandleParallelMessages: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used PL/pgSQL function context: 24576 total in 2 blocks; 10480 free (1 chunks); 14096 used PL/pgSQL function context: 8192 total in 1 blocks; 4984 free (1 chunks); 3208 used PL/pgSQL function context: 24576 total in 2 blocks; 7352 free (3 chunks); 17224 used PL/pgSQL function context: 122880 total in 4 blocks; 31144 free (2 chunks); 91736 used PL/pgSQL function context: 135008 total in 5 blocks; 28352 free (5 chunks); 106656 used PL/pgSQL function context: 24576 total in 2 blocks; 12328 free (1 chunks); 12248 used RI compare cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used RI query cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used RI constraint cache: 40888 total in 2 blocks; 2840 free (0 chunks); 38048 used Sequence values: 24576 total in 2 blocks; 16080 free (4 chunks); 8496 used PL/pgSQL function context: 285640 total in 7 blocks; 62424 free (2 chunks); 223216 used Prepared Queries: 24576 total in 2 blocks; 6848 free (5 chunks); 17728 used PLpgSQL cast info: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PLpgSQL cast cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used PL/pgSQL function context: 24576 total in 2 blocks; 8632 free (2 chunks); 15944 used Function stat entries: 24576 total in 2 blocks; 15056 free (4 chunks); 9520 used CFuncHash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used Rendezvous variable hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PLpgSQL function cache: 137848 total in 2 blocks; 2840 free (0 chunks); 135008 used Record information cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used Type information cache: 24472 total in 2 blocks; 2840 free (0 chunks); 21632 used TableSpace cache: 8192 total in 1 blocks; 2312 free (0 chunks); 5880 used Operator lookup cache: 24576 total in 2 blocks; 10976 free (5 chunks); 13600 used MessageContext: 8192 total in 1 blocks; 6968 free (0 chunks); 1224 used Operator class cache: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used smgr relation table: 122880 total in 4 blocks; 16640 free (13 chunks); 106240 used TransactionAbortContext: 32768 total in 1 blocks; 32728 free (0 chunks); 40 used Portal hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PortalMemory: 8192 total in 1 blocks; 7880 free (1 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 672 free (0 chunks); 352 used ExecutorState: 24576 total in 2 blocks; 12400 free (4 chunks); 12176 used printtup: 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: 57344 total in 3 blocks; 15560 free (8 chunks); 41784 used CacheMemoryContext: 9581024 total in 78 blocks; 3850528 free (0 chunks); 5730496 used CachedPlan: 1047552 total in 10 blocks; 348904 free (0 chunks); 698648 used CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used CachedPlanSource: 3072 total in 2 blocks; 1288 free (0 chunks); 1784 used unnamed prepared statement: 8192 total in 1 blocks; 2536 free (3 chunks); 5656 used CachedPlan: 31744 total in 5 blocks; 15624 free (0 chunks); 16120 used CachedPlanSource: 31744 total in 5 blocks; 2744 free (0 chunks); 29000 used CachedPlanQuery: 31744 total in 5 blocks; 4824 free (1 chunks); 26920 used CachedPlanSource: 15360 total in 4 blocks; 6032 free (0 chunks); 9328 used CachedPlanQuery: 15360 total in 4 blocks; 2256 free (1 chunks); 13104 used CachedPlanSource: 3072 total in 2 blocks; 1176 free (0 chunks); 1896 used CachedPlanQuery: 7168 total in 3 blocks; 2168 free (1 chunks); 5000 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 2000 free (2 chunks); 1072 used CachedPlanSource: 3072 total in 2 blocks; 1448 free (0 chunks); 1624 used CachedPlanQuery: 3072 total in 2 blocks; 1936 free (1 chunks); 1136 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlanSource: 3072 total in 2 blocks; 592 free (0 chunks); 2480 used CachedPlanQuery: 7168 total in 3 blocks; 2504 free (5 chunks); 4664 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used CachedPlanSource: 15360 total in 4 blocks; 5768 free (0 chunks); 9592 used CachedPlanQuery: 15360 total in 4 blocks; 1456 free (1 chunks); 13904 used CachedPlanSource: 3072 total in 2 blocks; 344 free (0 chunks); 2728 used CachedPlanQuery: 7168 total in 3 blocks; 4048 free (1 chunks); 3120 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_1: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_TIMEZONE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_TIMEZONE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_4: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_7: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_3: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_2: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_6: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_5: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlan: 7168 total in 3 blocks; 3904 free (0 chunks); 3264 used CachedPlan: 7168 total in 3 blocks; 2936 free (0 chunks); 4232 used CachedPlan: 7168 total in 3 blocks; 3368 free (0 chunks); 3800 used CachedPlanSource: 3072 total in 2 blocks; 592 free (0 chunks); 2480 used CachedPlanQuery: 7168 total in 3 blocks; 2504 free (5 chunks); 4664 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used CachedPlanSource: 3072 total in 2 blocks; 1368 free (0 chunks); 1704 used CachedPlanQuery: 3072 total in 2 blocks; 376 free (1 chunks); 2696 used IX_DBO_CHANNEL_DAY_LOCK_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlan: 7168 total in 3 blocks; 2896 free (1 chunks); 4272 used CachedPlanSource: 3072 total in 2 blocks; 816 free (1 chunks); 2256 used CachedPlanQuery: 7168 total in 3 blocks; 3424 free (6 chunks); 3744 used CachedPlanSource: 3072 total in 2 blocks; 608 free (0 chunks); 2464 used CachedPlanQuery: 3072 total in 2 blocks; 312 free (5 chunks); 2760 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used CachedPlan: 15360 total in 4 blocks; 4904 free (0 chunks); 10456 used CachedPlan: 64512 total in 6 blocks; 5104 free (0 chunks); 59408 used CachedPlan: 130048 total in 7 blocks; 52128 free (0 chunks); 77920 used CachedPlan: 15360 total in 4 blocks; 6816 free (0 chunks); 8544 used CachedPlan: 31744 total in 5 blocks; 12880 free (0 chunks); 18864 used CachedPlan: 15360 total in 4 blocks; 1184 free (0 chunks); 14176 used CachedPlan: 15360 total in 4 blocks; 1160 free (0 chunks); 14200 used CachedPlan: 64512 total in 6 blocks; 1528 free (0 chunks); 62984 used CachedPlan: 31744 total in 5 blocks; 12496 free (1 chunks); 19248 used CachedPlan: 15360 total in 4 blocks; 1456 free (0 chunks); 13904 used CachedPlan: 15360 total in 4 blocks; 6584 free (0 chunks); 8776 used CachedPlan: 64512 total in 6 blocks; 11240 free (0 chunks); 53272 used CachedPlanSource: 7168 total in 3 blocks; 2496 free (0 chunks); 4672 used CachedPlanQuery: 15360 total in 4 blocks; 6280 free (2 chunks); 9080 used CachedPlan: 31744 total in 5 blocks; 8328 free (0 chunks); 23416 used CachedPlan: 7168 total in 3 blocks; 3624 free (0 chunks); 3544 used CachedPlan: 7168 total in 3 blocks; 3856 free (0 chunks); 3312 used CachedPlan: 7168 total in 3 blocks; 1104 free (0 chunks); 6064 used CachedPlan: 15360 total in 4 blocks; 3216 free (1 chunks); 12144 used CachedPlan: 7168 total in 3 blocks; 2928 free (0 chunks); 4240 used CachedPlan: 31744 total in 5 blocks; 9672 free (0 chunks); 22072 used CachedPlanSource: 15360 total in 4 blocks; 7208 free (1 chunks); 8152 used CachedPlanQuery: 15360 total in 4 blocks; 6384 free (1 chunks); 8976 used CachedPlanSource: 7168 total in 3 blocks; 1848 free (0 chunks); 5320 used CachedPlanQuery: 7168 total in 3 blocks; 424 free (1 chunks); 6744 used CachedPlanSource: 7168 total in 3 blocks; 1824 free (0 chunks); 5344 used CachedPlanQuery: 7168 total in 3 blocks; 400 free (1 chunks); 6768 used CachedPlanSource: 64512 total in 6 blocks; 25096 free (2 chunks); 39416 used CachedPlanQuery: 64512 total in 6 blocks; 14856 free (1 chunks); 49656 used CachedPlan: 31744 total in 5 blocks; 15952 free (0 chunks); 15792 used CachedPlan: 31744 total in 5 blocks; 15952 free (0 chunks); 15792 used CachedPlanSource: 15360 total in 4 blocks; 7768 free (3 chunks); 7592 used CachedPlanQuery: 15360 total in 4 blocks; 6896 free (2 chunks); 8464 used CachedPlanSource: 7168 total in 3 blocks; 2408 free (0 chunks); 4760 used CachedPlanQuery: 7168 total in 3 blocks; 936 free (1 chunks); 6232 used CachedPlanSource: 7168 total in 3 blocks; 2384 free (0 chunks); 4784 used CachedPlanQuery: 7168 total in 3 blocks; 912 free (1 chunks); 6256 used CachedPlanSource: 64512 total in 6 blocks; 25656 free (2 chunks); 38856 used CachedPlanQuery: 64512 total in 6 blocks; 15368 free (1 chunks); 49144 used CachedPlan: 31744 total in 5 blocks; 13944 free (0 chunks); 17800 used CachedPlanSource: 31744 total in 5 blocks; 6120 free (0 chunks); 25624 used CachedPlanQuery: 31744 total in 5 blocks; 8088 free (1 chunks); 23656 used CachedPlan: 3072 total in 2 blocks; 552 free (0 chunks); 2520 used CachedPlan: 7168 total in 3 blocks; 3088 free (0 chunks); 4080 used CachedPlan: 7168 total in 3 blocks; 2936 free (0 chunks); 4232 used CachedPlan: 7168 total in 3 blocks; 976 free (0 chunks); 6192 used CachedPlan: 64512 total in 6 blocks; 27352 free (0 chunks); 37160 used CachedPlan: 130048 total in 7 blocks; 22296 free (0 chunks); 107752 used CachedPlan: 64512 total in 6 blocks; 28768 free (0 chunks); 35744 used CachedPlan: 7168 total in 3 blocks; 2624 free (0 chunks); 4544 used CachedPlan: 7168 total in 3 blocks; 1280 free (0 chunks); 5888 used CachedPlan: 7168 total in 3 blocks; 2800 free (0 chunks); 4368 used CachedPlan: 7168 total in 3 blocks; 976 free (0 chunks); 6192 used CachedPlan: 7168 total in 3 blocks; 3856 free (0 chunks); 3312 used CachedPlan: 7168 total in 3 blocks; 3160 free (0 chunks); 4008 used CachedPlan: 7168 total in 3 blocks; 3728 free (0 chunks); 3440 used CachedPlan: 523264 total in 9 blocks; 75400 free (0 chunks); 447864 used CachedPlanSource: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used CachedPlanQuery: 3072 total in 2 blocks; 1072 free (1 chunks); 2000 used CachedPlanSource: 3072 total in 2 blocks; 1368 free (0 chunks); 1704 used CachedPlanQuery: 3072 total in 2 blocks; 328 free (1 chunks); 2744 used CachedPlanSource: 3072 total in 2 blocks; 632 free (0 chunks); 2440 used CachedPlanQuery: 7168 total in 3 blocks; 1632 free (1 chunks); 5536 used CachedPlanSource: 7168 total in 3 blocks; 3736 free (2 chunks); 3432 used CachedPlanQuery: 7168 total in 3 blocks; 1328 free (1 chunks); 5840 used CachedPlanSource: 3072 total in 2 blocks; 1232 free (0 chunks); 1840 used CachedPlanQuery: 7168 total in 3 blocks; 3672 free (1 chunks); 3496 used CachedPlan: 1024 total in 1 blocks; 264 free (0 chunks); 760 used CachedPlanSource: 3072 total in 2 blocks; 1888 free (1 chunks); 1184 used CachedPlanQuery: 1024 total in 1 blocks; 200 free (1 chunks); 824 used CachedPlanSource: 15360 total in 4 blocks; 1728 free (0 chunks); 13632 used CachedPlanQuery: 31744 total in 5 blocks; 13824 free (2 chunks); 17920 used CachedPlan: 130048 total in 7 blocks; 53056 free (0 chunks); 76992 used 932 more child contexts containing 14656224 total in 1968 blocks; 4506080 free (275 chunks); 10150144 used WAL record construction: 49768 total in 2 blocks; 6584 free (0 chunks); 43184 used PrivateRefCount: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used MdSmgr: 24576 total in 2 blocks; 1968 free (2 chunks); 22608 used LOCALLOCK hash: 57344 total in 3 blocks; 10776 free (9 chunks); 46568 used Timezones: 104120 total in 2 blocks; 2840 free (0 chunks); 101280 used ErrorContext: 8192 total in 1 blocks; 5992 free (2 chunks); 2200 used Grand total: 44800632 bytes in 2693 blocks; 14306712 free (632 chunks); 30493920 used 2018-06-18 15:02:22 EDT,28193,mydb,ERROR: out of memory 2018-06-18 15:02:22 EDT,28193,mydb,DETAIL: Failed on request of size 8192. 2018-06-18 15:02:22 EDT,26927,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.1101931262" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,26927,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id 2018-06-18 15:02:22 EDT,19940,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.998319266" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,19940,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id 2018-06-18 15:02:22 EDT,26708,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.473958565" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,26708,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id TopMemoryContext: 1213520 total in 15 blocks; 522480 free (164 chunks); 691040 used pgstat TabStatusArray lookup hash table: 24576 total in 2 blocks; 10736 free (3 chunks); 13840 used TopTransactionContext: 8192 total in 1 blocks; 2920 free (0 chunks); 5272 used SPI Exec: 8388608 total in 11 blocks; 1376944 free (7 chunks); 7011664 used ExecutorState: 4814160 total in 60 blocks; 2068648 free (9 chunks); 2745512 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 82152 total in 3 blocks; 0 free (0 chunks); 82152 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7840 free (0 chunks); 352 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used TupleSort main: 32824 total in 2 blocks; 7544 free (0 chunks); 25280 used Caller tuples: 8192 total in 1 blocks; 8072 free (0 chunks); 120 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Unique: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 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 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 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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 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 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 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (1 chunks); 40 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 ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 ExprContext: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 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 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 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: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used 59 more child contexts containing 98304 total in 12 blocks; 97128 free (6 chunks); 1176 used JoinRelHashTable: 24576 total in 2 blocks; 5680 free (3 chunks); 18896 used SPI Proc: 8192 total in 1 blocks; 7528 free (0 chunks); 664 used ExecutorState: 8192 total in 1 blocks; 7400 free (0 chunks); 792 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used AfterTriggerEvents: 8192 total in 1 blocks; 7112 free (1 chunks); 1080 used PL/pgSQL function context: 24576 total in 2 blocks; 14600 free (1 chunks); 9976 used PL/pgSQL function context: 57344 total in 3 blocks; 18544 free (4 chunks); 38800 used PL/pgSQL function context: 57344 total in 3 blocks; 35352 free (3 chunks); 21992 used HandleParallelMessages: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used PL/pgSQL function context: 24576 total in 2 blocks; 10480 free (1 chunks); 14096 used PL/pgSQL function context: 8192 total in 1 blocks; 4984 free (1 chunks); 3208 used PL/pgSQL function context: 24576 total in 2 blocks; 7352 free (3 chunks); 17224 used PL/pgSQL function context: 122880 total in 4 blocks; 31144 free (2 chunks); 91736 used PL/pgSQL function context: 135008 total in 5 blocks; 28352 free (5 chunks); 106656 used PL/pgSQL function context: 24576 total in 2 blocks; 12328 free (1 chunks); 12248 used RI compare cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used RI query cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used RI constraint cache: 40888 total in 2 blocks; 2840 free (0 chunks); 38048 used Sequence values: 24576 total in 2 blocks; 16080 free (4 chunks); 8496 used PL/pgSQL function context: 285640 total in 7 blocks; 62424 free (2 chunks); 223216 used Prepared Queries: 24576 total in 2 blocks; 6848 free (5 chunks); 17728 used PLpgSQL cast info: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PLpgSQL cast cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used PL/pgSQL function context: 24576 total in 2 blocks; 8632 free (2 chunks); 15944 used Function stat entries: 24576 total in 2 blocks; 15056 free (4 chunks); 9520 used CFuncHash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used Rendezvous variable hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PLpgSQL function cache: 137848 total in 2 blocks; 2840 free (0 chunks); 135008 used Record information cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used Type information cache: 24472 total in 2 blocks; 2840 free (0 chunks); 21632 used TableSpace cache: 8192 total in 1 blocks; 2312 free (0 chunks); 5880 used Operator lookup cache: 24576 total in 2 blocks; 10976 free (5 chunks); 13600 used MessageContext: 8192 total in 1 blocks; 6968 free (0 chunks); 1224 used Operator class cache: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used smgr relation table: 122880 total in 4 blocks; 16640 free (13 chunks); 106240 used TransactionAbortContext: 32768 total in 1 blocks; 32728 free (0 chunks); 40 used Portal hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PortalMemory: 8192 total in 1 blocks; 7880 free (1 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 672 free (0 chunks); 352 used ExecutorState: 24576 total in 2 blocks; 12400 free (4 chunks); 12176 used printtup: 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: 57344 total in 3 blocks; 15560 free (8 chunks); 41784 used CacheMemoryContext: 9581024 total in 78 blocks; 3850528 free (0 chunks); 5730496 used CachedPlan: 1047552 total in 10 blocks; 348904 free (0 chunks); 698648 used CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used CachedPlanSource: 3072 total in 2 blocks; 1288 free (0 chunks); 1784 used unnamed prepared statement: 8192 total in 1 blocks; 2536 free (3 chunks); 5656 used CachedPlan: 31744 total in 5 blocks; 15624 free (0 chunks); 16120 used CachedPlanSource: 31744 total in 5 blocks; 2744 free (0 chunks); 29000 used CachedPlanQuery: 31744 total in 5 blocks; 4824 free (1 chunks); 26920 used CachedPlanSource: 15360 total in 4 blocks; 6032 free (0 chunks); 9328 used CachedPlanQuery: 15360 total in 4 blocks; 2256 free (1 chunks); 13104 used CachedPlanSource: 3072 total in 2 blocks; 1176 free (0 chunks); 1896 used CachedPlanQuery: 7168 total in 3 blocks; 2168 free (1 chunks); 5000 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 2000 free (2 chunks); 1072 used CachedPlanSource: 3072 total in 2 blocks; 1448 free (0 chunks); 1624 used CachedPlanQuery: 3072 total in 2 blocks; 1936 free (1 chunks); 1136 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlanSource: 3072 total in 2 blocks; 592 free (0 chunks); 2480 used CachedPlanQuery: 7168 total in 3 blocks; 2504 free (5 chunks); 4664 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used CachedPlanSource: 15360 total in 4 blocks; 5768 free (0 chunks); 9592 used CachedPlanQuery: 15360 total in 4 blocks; 1456 free (1 chunks); 13904 used CachedPlanSource: 3072 total in 2 blocks; 344 free (0 chunks); 2728 used CachedPlanQuery: 7168 total in 3 blocks; 4048 free (1 chunks); 3120 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_1: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_TIMEZONE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_TIMEZONE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_4: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_7: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_3: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_2: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_6: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_5: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlan: 7168 total in 3 blocks; 3904 free (0 chunks); 3264 used CachedPlan: 7168 total in 3 blocks; 2936 free (0 chunks); 4232 used CachedPlan: 7168 total in 3 blocks; 3368 free (0 chunks); 3800 used CachedPlanSource: 3072 total in 2 blocks; 592 free (0 chunks); 2480 used CachedPlanQuery: 7168 total in 3 blocks; 2504 free (5 chunks); 4664 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used CachedPlanSource: 3072 total in 2 blocks; 1368 free (0 chunks); 1704 used CachedPlanQuery: 3072 total in 2 blocks; 376 free (1 chunks); 2696 used IX_DBO_CHANNEL_DAY_LOCK_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlan: 7168 total in 3 blocks; 2896 free (1 chunks); 4272 used CachedPlanSource: 3072 total in 2 blocks; 816 free (1 chunks); 2256 used CachedPlanQuery: 7168 total in 3 blocks; 3424 free (6 chunks); 3744 used CachedPlanSource: 3072 total in 2 blocks; 608 free (0 chunks); 2464 used CachedPlanQuery: 3072 total in 2 blocks; 312 free (5 chunks); 2760 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used CachedPlan: 15360 total in 4 blocks; 4904 free (0 chunks); 10456 used CachedPlan: 64512 total in 6 blocks; 5104 free (0 chunks); 59408 used CachedPlan: 130048 total in 7 blocks; 52128 free (0 chunks); 77920 used CachedPlan: 15360 total in 4 blocks; 6816 free (0 chunks); 8544 used CachedPlan: 31744 total in 5 blocks; 12880 free (0 chunks); 18864 used CachedPlan: 15360 total in 4 blocks; 1184 free (0 chunks); 14176 used CachedPlan: 15360 total in 4 blocks; 1160 free (0 chunks); 14200 used CachedPlan: 64512 total in 6 blocks; 1528 free (0 chunks); 62984 used CachedPlan: 31744 total in 5 blocks; 12496 free (1 chunks); 19248 used CachedPlan: 15360 total in 4 blocks; 1456 free (0 chunks); 13904 used CachedPlan: 15360 total in 4 blocks; 6584 free (0 chunks); 8776 used CachedPlan: 64512 total in 6 blocks; 11240 free (0 chunks); 53272 used CachedPlanSource: 7168 total in 3 blocks; 2496 free (0 chunks); 4672 used CachedPlanQuery: 15360 total in 4 blocks; 6280 free (2 chunks); 9080 used CachedPlan: 31744 total in 5 blocks; 8328 free (0 chunks); 23416 used CachedPlan: 7168 total in 3 blocks; 3624 free (0 chunks); 3544 used CachedPlan: 7168 total in 3 blocks; 3856 free (0 chunks); 3312 used CachedPlan: 7168 total in 3 blocks; 1104 free (0 chunks); 6064 used CachedPlan: 15360 total in 4 blocks; 3216 free (1 chunks); 12144 used CachedPlan: 7168 total in 3 blocks; 2928 free (0 chunks); 4240 used CachedPlan: 31744 total in 5 blocks; 9672 free (0 chunks); 22072 used CachedPlanSource: 15360 total in 4 blocks; 7208 free (1 chunks); 8152 used CachedPlanQuery: 15360 total in 4 blocks; 6384 free (1 chunks); 8976 used CachedPlanSource: 7168 total in 3 blocks; 1848 free (0 chunks); 5320 used CachedPlanQuery: 7168 total in 3 blocks; 424 free (1 chunks); 6744 used CachedPlanSource: 7168 total in 3 blocks; 1824 free (0 chunks); 5344 used CachedPlanQuery: 7168 total in 3 blocks; 400 free (1 chunks); 6768 used CachedPlanSource: 64512 total in 6 blocks; 25096 free (2 chunks); 39416 used CachedPlanQuery: 64512 total in 6 blocks; 14856 free (1 chunks); 49656 used CachedPlan: 31744 total in 5 blocks; 15952 free (0 chunks); 15792 used CachedPlan: 31744 total in 5 blocks; 15952 free (0 chunks); 15792 used CachedPlanSource: 15360 total in 4 blocks; 7768 free (3 chunks); 7592 used CachedPlanQuery: 15360 total in 4 blocks; 6896 free (2 chunks); 8464 used CachedPlanSource: 7168 total in 3 blocks; 2408 free (0 chunks); 4760 used CachedPlanQuery: 7168 total in 3 blocks; 936 free (1 chunks); 6232 used CachedPlanSource: 7168 total in 3 blocks; 2384 free (0 chunks); 4784 used CachedPlanQuery: 7168 total in 3 blocks; 912 free (1 chunks); 6256 used CachedPlanSource: 64512 total in 6 blocks; 25656 free (2 chunks); 38856 used CachedPlanQuery: 64512 total in 6 blocks; 15368 free (1 chunks); 49144 used CachedPlan: 31744 total in 5 blocks; 13944 free (0 chunks); 17800 used CachedPlanSource: 31744 total in 5 blocks; 6120 free (0 chunks); 25624 used CachedPlanQuery: 31744 total in 5 blocks; 8088 free (1 chunks); 23656 used CachedPlan: 3072 total in 2 blocks; 552 free (0 chunks); 2520 used CachedPlan: 7168 total in 3 blocks; 3088 free (0 chunks); 4080 used CachedPlan: 7168 total in 3 blocks; 2936 free (0 chunks); 4232 used CachedPlan: 7168 total in 3 blocks; 976 free (0 chunks); 6192 used CachedPlan: 64512 total in 6 blocks; 27352 free (0 chunks); 37160 used CachedPlan: 130048 total in 7 blocks; 22296 free (0 chunks); 107752 used CachedPlan: 64512 total in 6 blocks; 28768 free (0 chunks); 35744 used CachedPlan: 7168 total in 3 blocks; 2624 free (0 chunks); 4544 used CachedPlan: 7168 total in 3 blocks; 1280 free (0 chunks); 5888 used CachedPlan: 7168 total in 3 blocks; 2800 free (0 chunks); 4368 used CachedPlan: 7168 total in 3 blocks; 976 free (0 chunks); 6192 used CachedPlan: 7168 total in 3 blocks; 3856 free (0 chunks); 3312 used CachedPlan: 7168 total in 3 blocks; 3160 free (0 chunks); 4008 used CachedPlan: 7168 total in 3 blocks; 3728 free (0 chunks); 3440 used CachedPlan: 523264 total in 9 blocks; 75400 free (0 chunks); 447864 used CachedPlanSource: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used CachedPlanQuery: 3072 total in 2 blocks; 1072 free (1 chunks); 2000 used CachedPlanSource: 3072 total in 2 blocks; 1368 free (0 chunks); 1704 used CachedPlanQuery: 3072 total in 2 blocks; 328 free (1 chunks); 2744 used CachedPlanSource: 3072 total in 2 blocks; 632 free (0 chunks); 2440 used CachedPlanQuery: 7168 total in 3 blocks; 1632 free (1 chunks); 5536 used CachedPlanSource: 7168 total in 3 blocks; 3736 free (2 chunks); 3432 used CachedPlanQuery: 7168 total in 3 blocks; 1328 free (1 chunks); 5840 used CachedPlanSource: 3072 total in 2 blocks; 1232 free (0 chunks); 1840 used CachedPlanQuery: 7168 total in 3 blocks; 3672 free (1 chunks); 3496 used CachedPlan: 1024 total in 1 blocks; 264 free (0 chunks); 760 used CachedPlanSource: 3072 total in 2 blocks; 1888 free (1 chunks); 1184 used CachedPlanQuery: 1024 total in 1 blocks; 200 free (1 chunks); 824 used CachedPlanSource: 15360 total in 4 blocks; 1728 free (0 chunks); 13632 used CachedPlanQuery: 31744 total in 5 blocks; 13824 free (2 chunks); 17920 used CachedPlan: 130048 total in 7 blocks; 53056 free (0 chunks); 76992 used 932 more child contexts containing 14656224 total in 1968 blocks; 4506080 free (275 chunks); 10150144 used WAL record construction: 49768 total in 2 blocks; 6584 free (0 chunks); 43184 used PrivateRefCount: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used MdSmgr: 24576 total in 2 blocks; 1968 free (2 chunks); 22608 used LOCALLOCK hash: 57344 total in 3 blocks; 10776 free (9 chunks); 46568 used Timezones: 104120 total in 2 blocks; 2840 free (0 chunks); 101280 used ErrorContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used Grand total: 44817224 bytes in 2695 blocks; 14321640 free (631 chunks); 30495584 used 2018-06-18 15:02:22 EDT,28193,mydb,ERROR: out of memory 2018-06-18 15:02:22 EDT,28193,mydb,DETAIL: Failed on request of size 16384. 2018-06-18 15:02:22 EDT,28193,mydb,CONTEXT: SQL statement "ommited" line 72 at SQL statement 2018-06-18 15:02:22 EDT,28193,mydb,STATEMENT: SELECT summary.spt_create_program_summary(15493207, 15493207) 2018-06-18 15:02:22 EDT,28195,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.504656179" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,28195,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id 2018-06-18 15:02:22 EDT,28183,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.682431448" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,28183,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id 2018-06-18 15:02:22 EDT,26927,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.1819325017" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,26927,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id 2018-06-18 15:02:22 EDT,20120,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.1507684535" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,20120,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id TopMemoryContext: 1225592 total in 16 blocks; 500112 free (167 chunks); 725480 used pgstat TabStatusArray lookup hash table: 24576 total in 2 blocks; 10736 free (3 chunks); 13840 used TopTransactionContext: 8192 total in 1 blocks; 2920 free (0 chunks); 5272 used SPI Exec: 8388608 total in 11 blocks; 1376944 free (7 chunks); 7011664 used ExecutorState: 4830600 total in 61 blocks; 2068544 free (8 chunks); 2762056 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 82152 total in 3 blocks; 0 free (0 chunks); 82152 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7840 free (0 chunks); 352 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used TupleSort main: 32824 total in 2 blocks; 7544 free (0 chunks); 25280 used Caller tuples: 8192 total in 1 blocks; 8072 free (0 chunks); 120 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Unique: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 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 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 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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 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 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 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (1 chunks); 40 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 ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 ExprContext: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 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 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 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: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used 59 more child contexts containing 98304 total in 12 blocks; 97128 free (6 chunks); 1176 used JoinRelHashTable: 24576 total in 2 blocks; 5680 free (3 chunks); 18896 used SPI Proc: 8192 total in 1 blocks; 7528 free (0 chunks); 664 used ExecutorState: 8192 total in 1 blocks; 7400 free (0 chunks); 792 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used MultiXact cache context: 1024 total in 1 blocks; 904 free (0 chunks); 120 used AfterTriggerEvents: 8192 total in 1 blocks; 7112 free (1 chunks); 1080 used PL/pgSQL function context: 24576 total in 2 blocks; 13320 free (2 chunks); 11256 used PL/pgSQL function context: 24576 total in 2 blocks; 13424 free (4 chunks); 11152 used PL/pgSQL function context: 24576 total in 2 blocks; 14600 free (1 chunks); 9976 used PL/pgSQL function context: 57344 total in 3 blocks; 18544 free (4 chunks); 38800 used PL/pgSQL function context: 57344 total in 3 blocks; 35352 free (3 chunks); 21992 used HandleParallelMessages: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used PL/pgSQL function context: 24576 total in 2 blocks; 10480 free (1 chunks); 14096 used PL/pgSQL function context: 8192 total in 1 blocks; 4984 free (1 chunks); 3208 used PL/pgSQL function context: 24576 total in 2 blocks; 7352 free (3 chunks); 17224 used PL/pgSQL function context: 122880 total in 4 blocks; 31144 free (2 chunks); 91736 used PL/pgSQL function context: 135008 total in 5 blocks; 28352 free (5 chunks); 106656 used PL/pgSQL function context: 24576 total in 2 blocks; 12328 free (1 chunks); 12248 used RI compare cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used RI query cache: 8192 total in 1 blocks; 760 free (0 chunks); 7432 used RI constraint cache: 40888 total in 2 blocks; 2840 free (0 chunks); 38048 used Sequence values: 24576 total in 2 blocks; 16080 free (4 chunks); 8496 used PL/pgSQL function context: 285640 total in 7 blocks; 62424 free (2 chunks); 223216 used Prepared Queries: 24576 total in 2 blocks; 6848 free (5 chunks); 17728 used PLpgSQL cast info: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PLpgSQL cast cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used PL/pgSQL function context: 24576 total in 2 blocks; 8632 free (2 chunks); 15944 used Function stat entries: 24576 total in 2 blocks; 15056 free (4 chunks); 9520 used CFuncHash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used Rendezvous variable hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PLpgSQL function cache: 137848 total in 2 blocks; 2840 free (0 chunks); 135008 used Record information cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used Type information cache: 24472 total in 2 blocks; 2840 free (0 chunks); 21632 used TableSpace cache: 8192 total in 1 blocks; 2312 free (0 chunks); 5880 used Operator lookup cache: 24576 total in 2 blocks; 10976 free (5 chunks); 13600 used MessageContext: 8192 total in 1 blocks; 6968 free (0 chunks); 1224 used Operator class cache: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used smgr relation table: 122880 total in 4 blocks; 12528 free (13 chunks); 110352 used TransactionAbortContext: 32768 total in 1 blocks; 32728 free (0 chunks); 40 used Portal hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PortalMemory: 8192 total in 1 blocks; 7880 free (1 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 672 free (0 chunks); 352 used ExecutorState: 24576 total in 2 blocks; 12400 free (4 chunks); 12176 used printtup: 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: 57344 total in 3 blocks; 15560 free (8 chunks); 41784 used CacheMemoryContext: 9581024 total in 78 blocks; 3763664 free (27 chunks); 5817360 used CachedPlan: 1047552 total in 10 blocks; 348904 free (0 chunks); 698648 used CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used CachedPlanSource: 3072 total in 2 blocks; 1288 free (0 chunks); 1784 used unnamed prepared statement: 8192 total in 1 blocks; 2536 free (3 chunks); 5656 used CachedPlan: 64512 total in 6 blocks; 27712 free (0 chunks); 36800 used CachedPlanSource: 3072 total in 2 blocks; 96 free (0 chunks); 2976 used CachedPlanQuery: 3072 total in 2 blocks; 200 free (1 chunks); 2872 used CachedPlanSource: 15888 total in 3 blocks; 1160 free (0 chunks); 14728 used CachedPlanQuery: 64512 total in 6 blocks; 27544 free (1 chunks); 36968 used CachedPlan: 7168 total in 3 blocks; 2208 free (0 chunks); 4960 used IX_DBO_MAPPABLE_PLACEHOLDER_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlanSource: 15360 total in 4 blocks; 6032 free (0 chunks); 9328 used CachedPlanQuery: 15360 total in 4 blocks; 2256 free (1 chunks); 13104 used CachedPlanSource: 31744 total in 5 blocks; 2744 free (0 chunks); 29000 used CachedPlanQuery: 31744 total in 5 blocks; 4824 free (1 chunks); 26920 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_1: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_TIMEZONE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_TIMEZONE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_4: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_7: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_3: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_2: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_6: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_5: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlanSource: 3072 total in 2 blocks; 624 free (0 chunks); 2448 used CachedPlanQuery: 3072 total in 2 blocks; 632 free (5 chunks); 2440 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used IX_DBO_CHANNEL_DAY_LOCK_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlan: 31744 total in 5 blocks; 15624 free (0 chunks); 16120 used CachedPlanSource: 31744 total in 5 blocks; 4432 free (0 chunks); 27312 used CachedPlanQuery: 31744 total in 5 blocks; 6456 free (1 chunks); 25288 used CachedPlan: 31744 total in 5 blocks; 8328 free (0 chunks); 23416 used CachedPlanSource: 15360 total in 4 blocks; 5768 free (0 chunks); 9592 used CachedPlanQuery: 15360 total in 4 blocks; 1456 free (1 chunks); 13904 used CachedPlan: 7168 total in 3 blocks; 3904 free (0 chunks); 3264 used CachedPlanSource: 7168 total in 3 blocks; 2184 free (0 chunks); 4984 used CachedPlanQuery: 7168 total in 3 blocks; 2896 free (1 chunks); 4272 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 1088 free (0 chunks); 1984 used CachedPlanSource: 7168 total in 3 blocks; 3960 free (2 chunks); 3208 used CachedPlanQuery: 3072 total in 2 blocks; 1024 free (1 chunks); 2048 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 7168 total in 3 blocks; 1992 free (0 chunks); 5176 used CachedPlanSource: 7168 total in 3 blocks; 3408 free (4 chunks); 3760 used CachedPlanQuery: 7168 total in 3 blocks; 1824 free (1 chunks); 5344 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used pg_inherits_relid_seqno_index: 1024 total in 1 blocks; 312 free (0 chunks); 712 used pg_init_privs_o_c_o_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used pg_seclabel_object_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used pg_description_o_c_o_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used CachedPlan: 130048 total in 7 blocks; 26496 free (0 chunks); 103552 used CachedPlanSource: 130048 total in 7 blocks; 51056 free (5 chunks); 78992 used CachedPlanQuery: 261120 total in 8 blocks; 94032 free (3 chunks); 167088 used CachedPlanSource: 7168 total in 3 blocks; 2888 free (0 chunks); 4280 used CachedPlanQuery: 7168 total in 3 blocks; 3328 free (1 chunks); 3840 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 1088 free (0 chunks); 1984 used CachedPlanSource: 7168 total in 3 blocks; 3960 free (2 chunks); 3208 used CachedPlanQuery: 3072 total in 2 blocks; 1024 free (1 chunks); 2048 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 7168 total in 3 blocks; 2984 free (1 chunks); 4184 used CachedPlanSource: 7168 total in 3 blocks; 3440 free (4 chunks); 3728 used CachedPlanQuery: 7168 total in 3 blocks; 2816 free (1 chunks); 4352 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used pg_constraint_contypid_index: 1024 total in 1 blocks; 400 free (0 chunks); 624 used pg_constraint_conname_nsp_index: 1024 total in 1 blocks; 264 free (0 chunks); 760 used pg_shdepend_depender_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used pg_shdepend_reference_index: 1024 total in 1 blocks; 264 free (0 chunks); 760 used pg_class_tblspc_relfilenode_index: 1024 total in 1 blocks; 264 free (0 chunks); 760 used pg_depend_depender_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used pg_depend_reference_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used EventTriggerCache: 8192 total in 1 blocks; 7608 free (2 chunks); 584 used Event Trigger Cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used CachedPlanSource: 3072 total in 2 blocks; 592 free (0 chunks); 2480 used CachedPlanQuery: 7168 total in 3 blocks; 2504 free (5 chunks); 4664 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used CachedPlan: 7168 total in 3 blocks; 2896 free (1 chunks); 4272 used CachedPlanSource: 3072 total in 2 blocks; 816 free (1 chunks); 2256 used CachedPlanQuery: 7168 total in 3 blocks; 3424 free (6 chunks); 3744 used CachedPlanSource: 3072 total in 2 blocks; 608 free (0 chunks); 2464 used CachedPlanQuery: 3072 total in 2 blocks; 312 free (5 chunks); 2760 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used CachedPlanSource: 31744 total in 5 blocks; 14024 free (0 chunks); 17720 used CachedPlanQuery: 31744 total in 5 blocks; 14616 free (1 chunks); 17128 used CachedPlan: 7168 total in 3 blocks; 2936 free (0 chunks); 4232 used CachedPlan: 3072 total in 2 blocks; 1440 free (0 chunks); 1632 used CachedPlan: 7168 total in 3 blocks; 3656 free (0 chunks); 3512 used CachedPlan: 64512 total in 6 blocks; 4648 free (0 chunks); 59864 used CachedPlan: 7168 total in 3 blocks; 3744 free (0 chunks); 3424 used CachedPlan: 7168 total in 3 blocks; 2592 free (0 chunks); 4576 used CachedPlan: 7168 total in 3 blocks; 3104 free (0 chunks); 4064 used CachedPlan: 7168 total in 3 blocks; 3488 free (0 chunks); 3680 used CachedPlan: 7168 total in 3 blocks; 2880 free (0 chunks); 4288 used CachedPlan: 7168 total in 3 blocks; 3568 free (0 chunks); 3600 used CachedPlan: 7168 total in 3 blocks; 784 free (1 chunks); 6384 used CachedPlan: 7168 total in 3 blocks; 432 free (0 chunks); 6736 used CachedPlan: 31744 total in 5 blocks; 6176 free (0 chunks); 25568 used CachedPlan: 7168 total in 3 blocks; 3736 free (0 chunks); 3432 used CachedPlan: 31744 total in 5 blocks; 7800 free (0 chunks); 23944 used CachedPlan: 31744 total in 5 blocks; 6224 free (0 chunks); 25520 used CachedPlan: 31744 total in 5 blocks; 15344 free (0 chunks); 16400 used CachedPlan: 31744 total in 5 blocks; 14936 free (0 chunks); 16808 used CachedPlan: 7168 total in 3 blocks; 3936 free (0 chunks); 3232 used CachedPlan: 7168 total in 3 blocks; 1528 free (0 chunks); 5640 used CachedPlan: 31744 total in 5 blocks; 16168 free (0 chunks); 15576 used CachedPlan: 15360 total in 4 blocks; 1520 free (0 chunks); 13840 used CachedPlan: 7168 total in 3 blocks; 3968 free (1 chunks); 3200 used CachedPlan: 7168 total in 3 blocks; 1568 free (0 chunks); 5600 used CachedPlan: 7168 total in 3 blocks; 3280 free (1 chunks); 3888 used CachedPlan: 7168 total in 3 blocks; 3432 free (0 chunks); 3736 used CachedPlan: 7168 total in 3 blocks; 3936 free (0 chunks); 3232 used 969 more child contexts containing 16499424 total in 2178 blocks; 4996752 free (315 chunks); 11502672 used WAL record construction: 49768 total in 2 blocks; 6584 free (0 chunks); 43184 used PrivateRefCount: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used MdSmgr: 24576 total in 2 blocks; 1376 free (7 chunks); 23200 used LOCALLOCK hash: 57344 total in 3 blocks; 10776 free (9 chunks); 46568 used Timezones: 104120 total in 2 blocks; 2840 free (0 chunks); 101280 used ErrorContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used Grand total: 45835448 bytes in 2832 blocks; 14564496 free (708 chunks); 31270952 used TopMemoryContext: 1225592 total in 16 blocks; 500112 free (167 chunks); 725480 used pgstat TabStatusArray lookup hash table: 24576 total in 2 blocks; 10736 free (3 chunks); 13840 used TopTransactionContext: 8192 total in 1 blocks; 2920 free (0 chunks); 5272 used SPI Exec: 8388608 total in 11 blocks; 1376944 free (7 chunks); 7011664 used ExecutorState: 4830600 total in 61 blocks; 2068544 free (8 chunks); 2762056 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 82152 total in 3 blocks; 0 free (0 chunks); 82152 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7840 free (0 chunks); 352 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used TupleSort main: 32824 total in 2 blocks; 7544 free (0 chunks); 25280 used Caller tuples: 8192 total in 1 blocks; 8072 free (0 chunks); 120 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used 2018-06-18 15:02:22 EDT,20066,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.884929577" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,20066,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Unique: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 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 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 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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 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 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 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (1 chunks); 40 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 ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 ExprContext: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 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 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 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: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used 59 more child contexts containing 98304 total in 12 blocks; 97128 free (6 chunks); 1176 used JoinRelHashTable: 24576 total in 2 blocks; 5680 free (3 chunks); 18896 used SPI Proc: 8192 total in 1 blocks; 7528 free (0 chunks); 664 used ExecutorState: 8192 total in 1 blocks; 7400 free (0 chunks); 792 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used MultiXact cache context: 1024 total in 1 blocks; 904 free (0 chunks); 120 used AfterTriggerEvents: 8192 total in 1 blocks; 7112 free (1 chunks); 1080 used PL/pgSQL function context: 24576 total in 2 blocks; 13320 free (2 chunks); 11256 used PL/pgSQL function context: 24576 total in 2 blocks; 13424 free (4 chunks); 11152 used PL/pgSQL function context: 24576 total in 2 blocks; 14600 free (1 chunks); 9976 used PL/pgSQL function context: 57344 total in 3 blocks; 18544 free (4 chunks); 38800 used PL/pgSQL function context: 57344 total in 3 blocks; 35352 free (3 chunks); 21992 used HandleParallelMessages: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used PL/pgSQL function context: 24576 total in 2 blocks; 10480 free (1 chunks); 14096 used PL/pgSQL function context: 8192 total in 1 blocks; 4984 free (1 chunks); 3208 used PL/pgSQL function context: 24576 total in 2 blocks; 7352 free (3 chunks); 17224 used PL/pgSQL function context: 122880 total in 4 blocks; 31144 free (2 chunks); 91736 used PL/pgSQL function context: 135008 total in 5 blocks; 28352 free (5 chunks); 106656 used PL/pgSQL function context: 24576 total in 2 blocks; 12328 free (1 chunks); 12248 used RI compare cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used RI query cache: 8192 total in 1 blocks; 760 free (0 chunks); 7432 used RI constraint cache: 40888 total in 2 blocks; 2840 free (0 chunks); 38048 used Sequence values: 24576 total in 2 blocks; 16080 free (4 chunks); 8496 used PL/pgSQL function context: 285640 total in 7 blocks; 62424 free (2 chunks); 223216 used Prepared Queries: 24576 total in 2 blocks; 6848 free (5 chunks); 17728 used PLpgSQL cast info: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PLpgSQL cast cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used PL/pgSQL function context: 24576 total in 2 blocks; 8632 free (2 chunks); 15944 used Function stat entries: 24576 total in 2 blocks; 15056 free (4 chunks); 9520 used CFuncHash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used Rendezvous variable hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PLpgSQL function cache: 137848 total in 2 blocks; 2840 free (0 chunks); 135008 used Record information cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used Type information cache: 24472 total in 2 blocks; 2840 free (0 chunks); 21632 used TableSpace cache: 8192 total in 1 blocks; 2312 free (0 chunks); 5880 used Operator lookup cache: 24576 total in 2 blocks; 10976 free (5 chunks); 13600 used MessageContext: 8192 total in 1 blocks; 6968 free (0 chunks); 1224 used Operator class cache: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used smgr relation table: 122880 total in 4 blocks; 12528 free (13 chunks); 110352 used TransactionAbortContext: 32768 total in 1 blocks; 32728 free (0 chunks); 40 used Portal hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PortalMemory: 8192 total in 1 blocks; 7880 free (1 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 672 free (0 chunks); 352 used ExecutorState: 24576 total in 2 blocks; 12400 free (4 chunks); 12176 used printtup: 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: 57344 total in 3 blocks; 15560 free (8 chunks); 41784 used CacheMemoryContext: 9581024 total in 78 blocks; 3763664 free (27 chunks); 5817360 used CachedPlan: 1047552 total in 10 blocks; 348904 free (0 chunks); 698648 used CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used CachedPlanSource: 3072 total in 2 blocks; 1288 free (0 chunks); 1784 used unnamed prepared statement: 8192 total in 1 blocks; 2536 free (3 chunks); 5656 used CachedPlan: 64512 total in 6 blocks; 27712 free (0 chunks); 36800 used CachedPlanSource: 3072 total in 2 blocks; 96 free (0 chunks); 2976 used CachedPlanQuery: 3072 total in 2 blocks; 200 free (1 chunks); 2872 used CachedPlanSource: 15888 total in 3 blocks; 1160 free (0 chunks); 14728 used CachedPlanQuery: 64512 total in 6 blocks; 27544 free (1 chunks); 36968 used CachedPlan: 7168 total in 3 blocks; 2208 free (0 chunks); 4960 used IX_DBO_MAPPABLE_PLACEHOLDER_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlanSource: 15360 total in 4 blocks; 6032 free (0 chunks); 9328 used CachedPlanQuery: 15360 total in 4 blocks; 2256 free (1 chunks); 13104 used CachedPlanSource: 31744 total in 5 blocks; 2744 free (0 chunks); 29000 used CachedPlanQuery: 31744 total in 5 blocks; 4824 free (1 chunks); 26920 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_UNMAP_CONFIG_1: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_TIMEZONE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_TIMEZONE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_PROGSERV_STATUS_TYPE_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_3: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_SOURCE_FINDER_4: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_7: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_4: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_3: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_2: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used IX_DBO_MAPPABLE_PROGSRV_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used IX_DBO_MAPPABLE_PROGSRV_6: 1024 total in 1 blocks; 264 free (0 chunks); 760 used IX_DBO_MAPPABLE_PROGSRV_5: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlanSource: 3072 total in 2 blocks; 624 free (0 chunks); 2448 used CachedPlanQuery: 3072 total in 2 blocks; 632 free (5 chunks); 2440 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used IX_DBO_CHANNEL_DAY_LOCK_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlan: 31744 total in 5 blocks; 15624 free (0 chunks); 16120 used CachedPlanSource: 31744 total in 5 blocks; 4432 free (0 chunks); 27312 used CachedPlanQuery: 31744 total in 5 blocks; 6456 free (1 chunks); 25288 used CachedPlan: 31744 total in 5 blocks; 8328 free (0 chunks); 23416 used CachedPlanSource: 15360 total in 4 blocks; 5768 free (0 chunks); 9592 used CachedPlanQuery: 15360 total in 4 blocks; 1456 free (1 chunks); 13904 used CachedPlan: 7168 total in 3 blocks; 3904 free (0 chunks); 3264 used CachedPlanSource: 7168 total in 3 blocks; 2184 free (0 chunks); 4984 used CachedPlanQuery: 7168 total in 3 blocks; 2896 free (1 chunks); 4272 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 1088 free (0 chunks); 1984 used CachedPlanSource: 7168 total in 3 blocks; 3960 free (2 chunks); 3208 used CachedPlanQuery: 3072 total in 2 blocks; 1024 free (1 chunks); 2048 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 7168 total in 3 blocks; 1992 free (0 chunks); 5176 used CachedPlanSource: 7168 total in 3 blocks; 3408 free (4 chunks); 3760 used CachedPlanQuery: 7168 total in 3 blocks; 1824 free (1 chunks); 5344 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used pg_inherits_relid_seqno_index: 1024 total in 1 blocks; 312 free (0 chunks); 712 used pg_init_privs_o_c_o_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used pg_seclabel_object_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used pg_description_o_c_o_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used CachedPlan: 130048 total in 7 blocks; 26496 free (0 chunks); 103552 used CachedPlanSource: 130048 total in 7 blocks; 51056 free (5 chunks); 78992 used CachedPlanQuery: 261120 total in 8 blocks; 94032 free (3 chunks); 167088 used CachedPlanSource: 7168 total in 3 blocks; 2888 free (0 chunks); 4280 used CachedPlanQuery: 7168 total in 3 blocks; 3328 free (1 chunks); 3840 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 1088 free (0 chunks); 1984 used CachedPlanSource: 7168 total in 3 blocks; 3960 free (2 chunks); 3208 used CachedPlanQuery: 3072 total in 2 blocks; 1024 free (1 chunks); 2048 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 7168 total in 3 blocks; 2984 free (1 chunks); 4184 used CachedPlanSource: 7168 total in 3 blocks; 3440 free (4 chunks); 3728 used CachedPlanQuery: 7168 total in 3 blocks; 2816 free (1 chunks); 4352 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used pg_constraint_contypid_index: 1024 total in 1 blocks; 400 free (0 chunks); 624 used pg_constraint_conname_nsp_index: 1024 total in 1 blocks; 264 free (0 chunks); 760 used pg_shdepend_depender_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used pg_shdepend_reference_index: 1024 total in 1 blocks; 264 free (0 chunks); 760 used pg_class_tblspc_relfilenode_index: 1024 total in 1 blocks; 264 free (0 chunks); 760 used pg_depend_depender_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used pg_depend_reference_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used EventTriggerCache: 8192 total in 1 blocks; 7608 free (2 chunks); 584 used Event Trigger Cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used CachedPlanSource: 3072 total in 2 blocks; 592 free (0 chunks); 2480 used CachedPlanQuery: 7168 total in 3 blocks; 2504 free (5 chunks); 4664 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used CachedPlan: 7168 total in 3 blocks; 2896 free (1 chunks); 4272 used CachedPlanSource: 3072 total in 2 blocks; 816 free (1 chunks); 2256 used CachedPlanQuery: 7168 total in 3 blocks; 3424 free (6 chunks); 3744 used CachedPlanSource: 3072 total in 2 blocks; 608 free (0 chunks); 2464 used CachedPlanQuery: 3072 total in 2 blocks; 312 free (5 chunks); 2760 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used CachedPlanSource: 31744 total in 5 blocks; 14024 free (0 chunks); 17720 used CachedPlanQuery: 31744 total in 5 blocks; 14616 free (1 chunks); 17128 used CachedPlan: 7168 total in 3 blocks; 2936 free (0 chunks); 4232 used CachedPlan: 3072 total in 2 blocks; 1440 free (0 chunks); 1632 used CachedPlan: 7168 total in 3 blocks; 3656 free (0 chunks); 3512 used CachedPlan: 64512 total in 6 blocks; 4648 free (0 chunks); 59864 used CachedPlan: 7168 total in 3 blocks; 3744 free (0 chunks); 3424 used CachedPlan: 7168 total in 3 blocks; 2592 free (0 chunks); 4576 used CachedPlan: 7168 total in 3 blocks; 3104 free (0 chunks); 4064 used CachedPlan: 7168 total in 3 blocks; 3488 free (0 chunks); 3680 used CachedPlan: 7168 total in 3 blocks; 2880 free (0 chunks); 4288 used CachedPlan: 7168 total in 3 blocks; 3568 free (0 chunks); 3600 used CachedPlan: 7168 total in 3 blocks; 784 free (1 chunks); 6384 used CachedPlan: 7168 total in 3 blocks; 432 free (0 chunks); 6736 used CachedPlan: 31744 total in 5 blocks; 6176 free (0 chunks); 25568 used CachedPlan: 7168 total in 3 blocks; 3736 free (0 chunks); 3432 used CachedPlan: 31744 total in 5 blocks; 7800 free (0 chunks); 23944 used CachedPlan: 31744 total in 5 blocks; 6224 free (0 chunks); 25520 used CachedPlan: 31744 total in 5 blocks; 15344 free (0 chunks); 16400 used CachedPlan: 31744 total in 5 blocks; 14936 free (0 chunks); 16808 used CachedPlan: 7168 total in 3 blocks; 3936 free (0 chunks); 3232 used CachedPlan: 7168 total in 3 blocks; 1528 free (0 chunks); 5640 used CachedPlan: 31744 total in 5 blocks; 16168 free (0 chunks); 15576 used CachedPlan: 15360 total in 4 blocks; 1520 free (0 chunks); 13840 used CachedPlan: 7168 total in 3 blocks; 3968 free (1 chunks); 3200 used CachedPlan: 7168 total in 3 blocks; 1568 free (0 chunks); 5600 used CachedPlan: 7168 total in 3 blocks; 3280 free (1 chunks); 3888 used CachedPlan: 7168 total in 3 blocks; 3432 free (0 chunks); 3736 used CachedPlan: 7168 total in 3 blocks; 3936 free (0 chunks); 3232 used 969 more child contexts containing 16499424 total in 2178 blocks; 4996752 free (315 chunks); 11502672 used WAL record construction: 49768 total in 2 blocks; 6584 free (0 chunks); 43184 used PrivateRefCount: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used MdSmgr: 24576 total in 2 blocks; 1376 free (7 chunks); 23200 used LOCALLOCK hash: 57344 total in 3 blocks; 10776 free (9 chunks); 46568 used Timezones: 104120 total in 2 blocks; 2840 free (0 chunks); 101280 used ErrorContext: 8192 total in 1 blocks; 5992 free (0 chunks); 2200 used Grand total: 45835448 bytes in 2832 blocks; 14562336 free (708 chunks); 31273112 used 2018-06-18 15:02:22 EDT,26805,mydb,ERROR: out of memory 2018-06-18 15:02:22 EDT,26805,mydb,DETAIL: Failed on request of size 8192. 2018-06-18 15:02:22 EDT,26815,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.335872331" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,26815,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id 2018-06-18 15:02:22 EDT,19801,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.1317307954" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,19801,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id 2018-06-18 15:02:22 EDT,19834,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.824752341" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,19834,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id 2018-06-18 15:02:22 EDT,19814,mydb,ERROR: could not resize shared memory segment "/PostgreSQL.105356890" to 192088 bytes: No space left on device 2018-06-18 15:02:22 EDT,19814,mydb,STATEMENT: SELECT lmmu.legacy_mappable_id as id, lmmu.highest_update_priority as updatePriority FROM showtimes.legacy_mappable_meta_updates lmmu, showtimes.legacy_mappable lm WHERE lm.mapping_scheme_id = $1 and lm.legacy_mappable_id = lmmu.legacy_mappable_id TopMemoryContext: 1225592 total in 16 blocks; 416608 free (161 chunks); 808984 used TopTransactionContext: 8192 total in 1 blocks; 2920 free (0 chunks); 5272 used SPI Exec: 8388608 total in 11 blocks; 1376944 free (7 chunks); 7011664 used ExecutorState: 4847400 total in 63 blocks; 2067448 free (9 chunks); 2779952 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 82152 total in 3 blocks; 0 free (0 chunks); 82152 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used HashTableContext: 8192 total in 1 blocks; 7840 free (0 chunks); 352 used HashBatchContext: 16384 total in 1 blocks; 8136 free (0 chunks); 8248 used TupleSort main: 32824 total in 2 blocks; 7544 free (0 chunks); 25280 used Caller tuples: 8192 total in 1 blocks; 8072 free (0 chunks); 120 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used HashTableContext: 8192 total in 1 blocks; 7968 free (0 chunks); 224 used HashBatchContext: 49240 total in 2 blocks; 8136 free (0 chunks); 41104 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Unique: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 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 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 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 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 ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 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 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 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 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 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: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8120 free (0 chunks); 72 used ExprContext: 8192 total in 1 blocks; 8152 free (1 chunks); 40 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 ExprContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 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 ExprContext: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 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 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 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: 8192 total in 1 blocks; 8152 free (2 chunks); 40 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used 59 more child contexts containing 114688 total in 14 blocks; 113368 free (6 chunks); 1320 used JoinRelHashTable: 24576 total in 2 blocks; 5680 free (3 chunks); 18896 used SPI Proc: 8192 total in 1 blocks; 7528 free (0 chunks); 664 used ExecutorState: 8192 total in 1 blocks; 7400 free (0 chunks); 792 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used MultiXact cache context: 1024 total in 1 blocks; 824 free (0 chunks); 200 used AfterTriggerEvents: 8192 total in 1 blocks; 7112 free (1 chunks); 1080 used pgstat TabStatusArray lookup hash table: 24576 total in 2 blocks; 5552 free (3 chunks); 19024 used PL/pgSQL function context: 24576 total in 2 blocks; 13320 free (2 chunks); 11256 used PL/pgSQL function context: 24576 total in 2 blocks; 13424 free (4 chunks); 11152 used PL/pgSQL function context: 24576 total in 2 blocks; 14600 free (1 chunks); 9976 used PL/pgSQL function context: 57344 total in 3 blocks; 18544 free (4 chunks); 38800 used PL/pgSQL function context: 57344 total in 3 blocks; 35352 free (3 chunks); 21992 used HandleParallelMessages: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used PL/pgSQL function context: 24576 total in 2 blocks; 10480 free (1 chunks); 14096 used PL/pgSQL function context: 8192 total in 1 blocks; 4984 free (1 chunks); 3208 used PL/pgSQL function context: 24576 total in 2 blocks; 7352 free (3 chunks); 17224 used PL/pgSQL function context: 122880 total in 4 blocks; 31144 free (2 chunks); 91736 used PL/pgSQL function context: 135008 total in 5 blocks; 28352 free (5 chunks); 106656 used PL/pgSQL function context: 24576 total in 2 blocks; 12328 free (1 chunks); 12248 used RI compare cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used RI query cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used RI constraint cache: 40888 total in 2 blocks; 2840 free (0 chunks); 38048 used Sequence values: 24576 total in 2 blocks; 16080 free (4 chunks); 8496 used PL/pgSQL function context: 285640 total in 7 blocks; 62424 free (2 chunks); 223216 used PLpgSQL cast info: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PLpgSQL cast cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used PL/pgSQL function context: 24576 total in 2 blocks; 8632 free (2 chunks); 15944 used Function stat entries: 24576 total in 2 blocks; 15056 free (4 chunks); 9520 used CFuncHash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used Rendezvous variable hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PLpgSQL function cache: 137848 total in 2 blocks; 2840 free (0 chunks); 135008 used Record information cache: 24576 total in 2 blocks; 15072 free (5 chunks); 9504 used Type information cache: 24472 total in 2 blocks; 2840 free (0 chunks); 21632 used Operator lookup cache: 24576 total in 2 blocks; 10976 free (5 chunks); 13600 used Prepared Queries: 24576 total in 2 blocks; 6848 free (5 chunks); 17728 used TableSpace cache: 8192 total in 1 blocks; 2312 free (0 chunks); 5880 used MessageContext: 8192 total in 1 blocks; 6968 free (0 chunks); 1224 used Operator class cache: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used smgr relation table: 253952 total in 5 blocks; 90088 free (17 chunks); 163864 used TransactionAbortContext: 32768 total in 1 blocks; 32728 free (0 chunks); 40 used Portal hash: 8192 total in 1 blocks; 776 free (0 chunks); 7416 used PortalMemory: 8192 total in 1 blocks; 7880 free (1 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 672 free (0 chunks); 352 used ExecutorState: 24576 total in 2 blocks; 12400 free (4 chunks); 12176 used printtup: 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: 122880 total in 4 blocks; 62368 free (9 chunks); 60512 used CacheMemoryContext: 9593192 total in 78 blocks; 2067264 free (0 chunks); 7525928 used CachedPlan: 1047552 total in 10 blocks; 348904 free (0 chunks); 698648 used CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used CachedPlanSource: 3072 total in 2 blocks; 1288 free (0 chunks); 1784 used unnamed prepared statement: 8192 total in 1 blocks; 2536 free (3 chunks); 5656 used CachedPlanSource: 15360 total in 4 blocks; 5768 free (0 chunks); 9592 used CachedPlanQuery: 15360 total in 4 blocks; 1296 free (1 chunks); 14064 used CachedPlan: 31744 total in 5 blocks; 5320 free (0 chunks); 26424 used CachedPlan: 7168 total in 3 blocks; 3432 free (0 chunks); 3736 used CachedPlanSource: 15888 total in 3 blocks; 1160 free (0 chunks); 14728 used CachedPlanQuery: 64512 total in 6 blocks; 27544 free (1 chunks); 36968 used CachedPlanSource: 15360 total in 4 blocks; 6032 free (0 chunks); 9328 used CachedPlanQuery: 15360 total in 4 blocks; 2256 free (1 chunks); 13104 used CachedPlanSource: 31744 total in 5 blocks; 2744 free (0 chunks); 29000 used CachedPlanQuery: 31744 total in 5 blocks; 4824 free (1 chunks); 26920 used CachedPlan: 31744 total in 5 blocks; 8328 free (0 chunks); 23416 used IX_DBO_CHANNEL_DAY_LOCK_1: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlan: 7168 total in 3 blocks; 3904 free (0 chunks); 3264 used CachedPlanSource: 130048 total in 7 blocks; 51056 free (5 chunks); 78992 used CachedPlanQuery: 261120 total in 8 blocks; 94032 free (3 chunks); 167088 used CachedPlan: 7168 total in 3 blocks; 2800 free (0 chunks); 4368 used CachedPlan: 7168 total in 3 blocks; 2208 free (0 chunks); 4960 used CachedPlanSource: 130048 total in 7 blocks; 51056 free (5 chunks); 78992 used CachedPlanQuery: 261120 total in 8 blocks; 94032 free (3 chunks); 167088 used CachedPlanSource: 7168 total in 3 blocks; 2184 free (0 chunks); 4984 used CachedPlanQuery: 7168 total in 3 blocks; 2896 free (1 chunks); 4272 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 1088 free (0 chunks); 1984 used CachedPlanSource: 7168 total in 3 blocks; 3960 free (2 chunks); 3208 used CachedPlanQuery: 3072 total in 2 blocks; 1024 free (1 chunks); 2048 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 7168 total in 3 blocks; 1992 free (0 chunks); 5176 used CachedPlanSource: 7168 total in 3 blocks; 3408 free (4 chunks); 3760 used CachedPlanQuery: 7168 total in 3 blocks; 1824 free (1 chunks); 5344 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used pg_inherits_relid_seqno_index: 1024 total in 1 blocks; 312 free (0 chunks); 712 used pg_init_privs_o_c_o_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used pg_seclabel_object_index: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used pg_description_o_c_o_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used CachedPlanSource: 7168 total in 3 blocks; 2888 free (0 chunks); 4280 used CachedPlanQuery: 7168 total in 3 blocks; 3328 free (1 chunks); 3840 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 1088 free (0 chunks); 1984 used CachedPlanSource: 7168 total in 3 blocks; 3960 free (2 chunks); 3208 used CachedPlanQuery: 3072 total in 2 blocks; 1024 free (1 chunks); 2048 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 7168 total in 3 blocks; 2984 free (1 chunks); 4184 used CachedPlanSource: 7168 total in 3 blocks; 3440 free (4 chunks); 3728 used CachedPlanQuery: 7168 total in 3 blocks; 2816 free (1 chunks); 4352 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used pg_constraint_contypid_index: 1024 total in 1 blocks; 400 free (0 chunks); 624 used pg_constraint_conname_nsp_index: 1024 total in 1 blocks; 264 free (0 chunks); 760 used pg_shdepend_depender_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used pg_shdepend_reference_index: 1024 total in 1 blocks; 264 free (0 chunks); 760 used pg_class_tblspc_relfilenode_index: 1024 total in 1 blocks; 264 free (0 chunks); 760 used pg_depend_depender_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used pg_depend_reference_index: 3072 total in 2 blocks; 1976 free (0 chunks); 1096 used EventTriggerCache: 8192 total in 1 blocks; 7608 free (2 chunks); 584 used Event Trigger Cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used CachedPlanSource: 3072 total in 2 blocks; 344 free (0 chunks); 2728 used CachedPlanQuery: 7168 total in 3 blocks; 4048 free (1 chunks); 3120 used CachedPlanSource: 3072 total in 2 blocks; 1176 free (0 chunks); 1896 used CachedPlanQuery: 7168 total in 3 blocks; 2168 free (1 chunks); 5000 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlan: 3072 total in 2 blocks; 2000 free (2 chunks); 1072 used CachedPlanSource: 3072 total in 2 blocks; 1448 free (0 chunks); 1624 used CachedPlanQuery: 3072 total in 2 blocks; 1936 free (1 chunks); 1136 used SPI Plan: 1024 total in 1 blocks; 824 free (0 chunks); 200 used CachedPlanSource: 3072 total in 2 blocks; 592 free (0 chunks); 2480 used CachedPlanQuery: 7168 total in 3 blocks; 2504 free (5 chunks); 4664 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used CachedPlan: 31744 total in 5 blocks; 13944 free (0 chunks); 17800 used CachedPlanSource: 3072 total in 2 blocks; 96 free (0 chunks); 2976 used CachedPlanQuery: 3072 total in 2 blocks; 200 free (1 chunks); 2872 used CachedPlanSource: 31744 total in 5 blocks; 14024 free (0 chunks); 17720 used CachedPlanQuery: 31744 total in 5 blocks; 14616 free (1 chunks); 17128 used CachedPlan: 7168 total in 3 blocks; 2936 free (0 chunks); 4232 used CachedPlanSource: 3072 total in 2 blocks; 1368 free (0 chunks); 1704 used CachedPlanQuery: 3072 total in 2 blocks; 376 free (1 chunks); 2696 used CachedPlan: 7168 total in 3 blocks; 3624 free (0 chunks); 3544 used CachedPlan: 7168 total in 3 blocks; 3856 free (0 chunks); 3312 used CachedPlan: 7168 total in 3 blocks; 1104 free (0 chunks); 6064 used CachedPlan: 15360 total in 4 blocks; 3216 free (1 chunks); 12144 used CachedPlan: 7168 total in 3 blocks; 2928 free (0 chunks); 4240 used CachedPlan: 31744 total in 5 blocks; 9672 free (0 chunks); 22072 used CachedPlanSource: 31744 total in 5 blocks; 6120 free (0 chunks); 25624 used CachedPlanQuery: 31744 total in 5 blocks; 8088 free (1 chunks); 23656 used CachedPlan: 7168 total in 3 blocks; 2936 free (0 chunks); 4232 used CachedPlan: 7168 total in 3 blocks; 976 free (0 chunks); 6192 used CachedPlan: 64512 total in 6 blocks; 27352 free (0 chunks); 37160 used CachedPlan: 130048 total in 7 blocks; 22296 free (0 chunks); 107752 used CachedPlan: 64512 total in 6 blocks; 28768 free (0 chunks); 35744 used CachedPlan: 7168 total in 3 blocks; 2624 free (0 chunks); 4544 used CachedPlan: 7168 total in 3 blocks; 1280 free (0 chunks); 5888 used CachedPlan: 7168 total in 3 blocks; 2800 free (0 chunks); 4368 used CachedPlan: 7168 total in 3 blocks; 976 free (0 chunks); 6192 used CachedPlan: 7168 total in 3 blocks; 3856 free (0 chunks); 3312 used CachedPlan: 7168 total in 3 blocks; 3160 free (0 chunks); 4008 used CachedPlan: 7168 total in 3 blocks; 3728 free (0 chunks); 3440 used CachedPlanSource: 15360 total in 4 blocks; 2960 free (0 chunks); 12400 used CachedPlanQuery: 15360 total in 4 blocks; 6696 free (1 chunks); 8664 used CachedPlan: 523264 total in 9 blocks; 75400 free (0 chunks); 447864 used CachedPlan: 15360 total in 4 blocks; 6816 free (0 chunks); 8544 used CachedPlanSource: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used CachedPlanQuery: 3072 total in 2 blocks; 1072 free (1 chunks); 2000 used CachedPlanSource: 3072 total in 2 blocks; 1368 free (0 chunks); 1704 used CachedPlanQuery: 3072 total in 2 blocks; 328 free (1 chunks); 2744 used CachedPlanSource: 3072 total in 2 blocks; 632 free (0 chunks); 2440 used CachedPlanQuery: 7168 total in 3 blocks; 1632 free (1 chunks); 5536 used CachedPlanSource: 7168 total in 3 blocks; 3736 free (2 chunks); 3432 used CachedPlanQuery: 7168 total in 3 blocks; 1328 free (1 chunks); 5840 used CachedPlanSource: 3072 total in 2 blocks; 1232 free (0 chunks); 1840 used CachedPlanQuery: 7168 total in 3 blocks; 3672 free (1 chunks); 3496 used CachedPlan: 1024 total in 1 blocks; 264 free (0 chunks); 760 used CachedPlanSource: 3072 total in 2 blocks; 1888 free (1 chunks); 1184 used CachedPlanQuery: 1024 total in 1 blocks; 200 free (1 chunks); 824 used CachedPlanSource: 15360 total in 4 blocks; 1728 free (0 chunks); 13632 used CachedPlanQuery: 31744 total in 5 blocks; 13824 free (2 chunks); 17920 used CachedPlanSource: 3072 total in 2 blocks; 592 free (0 chunks); 2480 used CachedPlanQuery: 3072 total in 2 blocks; 408 free (5 chunks); 2664 used SPI Plan: 1024 total in 1 blocks; 800 free (0 chunks); 224 used IX_DBO_UPDATE_PREVIOUS_VALUE_2: 1024 total in 1 blocks; 400 free (0 chunks); 624 used CachedPlan: 31744 total in 5 blocks; 12880 free (0 chunks); 18864 used CachedPlan: 15360 total in 4 blocks; 1184 free (0 chunks); 14176 used CachedPlan: 15360 total in 4 blocks; 1160 free (0 chunks); 14200 used CachedPlan: 64512 total in 6 blocks; 1528 free (0 chunks); 62984 used CachedPlan: 15360 total in 4 blocks; 6584 free (0 chunks); 8776 used CachedPlan: 3072 total in 2 blocks; 552 free (0 chunks); 2520 used CachedPlan: 7168 total in 3 blocks; 3088 free (0 chunks); 4080 used CachedPlan: 31744 total in 5 blocks; 12496 free (1 chunks); 19248 used CachedPlan: 15360 total in 4 blocks; 1456 free (0 chunks); 13904 used CachedPlan: 64512 total in 6 blocks; 11240 free (0 chunks); 53272 used 1272 more child contexts containing 15940320 total in 2444 blocks; 4951008 free (299 chunks); 10989312 used WAL record construction: 49768 total in 2 blocks; 6584 free (0 chunks); 43184 used PrivateRefCount: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used MdSmgr: 57344 total in 3 blocks; 22872 free (4 chunks); 34472 used LOCALLOCK hash: 57344 total in 3 blocks; 10776 free (9 chunks); 46568 used Timezones: 104120 total in 2 blocks; 2840 free (0 chunks); 101280 used ErrorContext: 8192 total in 1 blocks; 8152 free (0 chunks); 40 used Grand total: 46719456 bytes in 3181 blocks; 13175304 free (674 chunks); 33544152 used