Hi, On 13.8.2014 19:17, Tomas Vondra wrote: > On 13.8.2014 17:52, Tom Lane wrote: > >> * I'm a bit dubious about testing -DRANDOMIZE_ALLOCATED_MEMORY in the >> same build as -DCLOBBER_CACHE_RECURSIVELY, because each of these is >> darned expensive and it's not clear you'd learn anything by running >> them both together. I think you might be better advised to run two >> separate buildfarm critters with those two options, and thereby perhaps >> get turnaround in something less than 80 days. > > OK, I removed this for barnacle/addax/mite, let's see what's the impact. > > FWIW We have three other animals running with CLOBBER_CACHE_ALWAYS + > RANDOMIZE_ALLOCATED_MEMORY, and it takes ~20h per branch. But maybe the > price when combined with CLOBBER_CACHE_RECURSIVELY is much higher. > >> * It'd likely be a good idea to take out the TestUpgrade and TestDecoding >> modules from the config too. Otherwise, we won't be seeing barnacle's >> next report before 2015, judging from the runtime of the check step >> compared to some of the other slow buildfarm machines. (I wonder whether >> there's an easy way to skip the installcheck step, as that's going to >> require a much longer run than it can possibly be worth too.) > > OK, I did this too. > > I stopped the already running test on addax and started the test on > barnacle again. Let's see in a few days/weeks/months what is the result.
It seems to be running much faster (probably after removing the randomization), and apparently it passed the create_view tests without crashing, but then crashed at 'constraints' (again, because of OOM). PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 769654952 total in 103 blocks; 114984 free (296 chunks); 769539968 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used I suppose we don't expect 760MB ExecutorState here. Also, there's ~60MB MessageContext. It's still running, so I'm attaching the relevant part of log (again, with MemoryContextStats for backends with VSS >= 512MB . FWIW, it's running against a844c29966d7c0cd6a457e9324f175349bb12df0. regards Tomas
[53f203cf.585e:35] LOG: statement: INSERT INTO CHECK_TBL VALUES (1); [53f203cf.5862:12] LOG: statement: CREATE VIEW ro_view8 AS SELECT a, b FROM base_tbl ORDER BY a OFFSET 1; [53f203cf.5862:13] LOG: statement: CREATE VIEW ro_view9 AS SELECT a, b FROM base_tbl ORDER BY a LIMIT 1; [53f203cf.5862:14] LOG: statement: CREATE VIEW ro_view10 AS SELECT 1 AS a; [53f203cf.5862:15] LOG: statement: CREATE VIEW ro_view11 AS SELECT b1.a, b2.b FROM base_tbl b1, base_tbl b2; [53f203cf.5862:16] LOG: statement: CREATE VIEW ro_view12 AS SELECT * FROM generate_series(1, 10) AS g(a); [53f203cf.5862:17] LOG: statement: CREATE VIEW ro_view13 AS SELECT a, b FROM (SELECT * FROM base_tbl) AS t; [53f203cf.5862:18] LOG: statement: CREATE VIEW rw_view14 AS SELECT ctid, a, b FROM base_tbl; TopMemoryContext: 61792 total in 9 blocks; 4264 free (12 chunks); 57528 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6208 free (23 chunks); 1984 used SPI Exec: 50323456 total in 15 blocks; 2568088 free (79 chunks); 47755368 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 260744 free (49 chunks); 255352 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 144 free (1 chunks); 880 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used [53f203cf.5862:19] LOG: statement: CREATE VIEW rw_view15 AS SELECT a, upper(b) FROM base_tbl; [53f203cf.5862:20] LOG: statement: CREATE VIEW rw_view16 AS SELECT a, b, a AS aa FROM base_tbl; [53f203cf.5862:21] LOG: statement: CREATE VIEW ro_view17 AS SELECT * FROM ro_view1; [53f203cf.585e:36] ERROR: new row for relation "check_tbl" violates check constraint "check_con" [53f203cf.585e:37] DETAIL: Failing row contains (1). [53f203cf.585e:38] STATEMENT: INSERT INTO CHECK_TBL VALUES (1); [53f203cf.585e:39] LOG: statement: SELECT '' AS three, * FROM CHECK_TBL; TopMemoryContext: 61792 total in 9 blocks; 3960 free (10 chunks); 57832 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6208 free (23 chunks); 1984 used SPI Exec: 75489280 total in 18 blocks; 2351808 free (62 chunks); 73137472 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 259336 free (46 chunks); 256760 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used [53f203cf.5862:22] LOG: statement: CREATE VIEW ro_view18 AS SELECT * FROM (VALUES(1)) AS tmp(a); [53f203cf.5862:23] LOG: statement: CREATE SEQUENCE seq; [53f203cf.5862:24] LOG: statement: CREATE VIEW ro_view19 AS SELECT * FROM seq; TopMemoryContext: 61792 total in 9 blocks; 4112 free (11 chunks); 57680 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6208 free (23 chunks); 1984 used SPI Exec: 100655104 total in 21 blocks; 7311496 free (88 chunks); 93343608 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 263688 free (54 chunks); 252408 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 144 free (1 chunks); 880 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used [53f203cf.5862:25] LOG: statement: CREATE VIEW ro_view20 AS SELECT a, b, generate_series(1, a) g FROM base_tbl; [53f203cf.5862:26] LOG: statement: SELECT table_name, is_insertable_into FROM information_schema.tables WHERE table_name LIKE E'r_\\_view%' ORDER BY table_name; TopMemoryContext: 61792 total in 9 blocks; 4112 free (11 chunks); 57680 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6208 free (23 chunks); 1984 used SPI Exec: 117432320 total in 23 blocks; 2465392 free (134 chunks); 114966928 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 259008 free (52 chunks); 257088 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 144 free (1 chunks); 880 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used [53f203cf.585e:40] LOG: statement: CREATE SEQUENCE CHECK_SEQ; TopMemoryContext: 61792 total in 9 blocks; 3808 free (9 chunks); 57984 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6208 free (23 chunks); 1984 used SPI Exec: 134217896 total in 26 blocks; 298016 free (76 chunks); 133919880 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 249664 free (40 chunks); 266432 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 144 free (1 chunks); 880 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used [53f203cf.585e:41] LOG: statement: CREATE TABLE CHECK2_TBL (x int, y text, z int, CONSTRAINT SEQUENCE_CON CHECK (x > 3 and y <> 'check failed' and z < 8)); [53f203cf.585e:42] LOG: statement: INSERT INTO CHECK2_TBL VALUES (4, 'check ok', -2); TopMemoryContext: 61792 total in 9 blocks; 3808 free (9 chunks); 57984 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6208 free (23 chunks); 1984 used SPI Exec: 150995112 total in 28 blocks; 1456744 free (113 chunks); 149538368 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 259368 free (48 chunks); 256728 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 3656 free (8 chunks); 58136 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6208 free (23 chunks); 1984 used SPI Exec: 167763968 total in 29 blocks; 671944 free (65 chunks); 167092024 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 249384 free (40 chunks); 266712 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 144 free (1 chunks); 880 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 3656 free (8 chunks); 58136 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6120 free (22 chunks); 2072 used SPI Exec: 184549544 total in 32 blocks; 1423176 free (67 chunks); 183126368 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 247544 free (34 chunks); 268552 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 5232 free (15 chunks); 56560 used TopTransactionContext: 8192 total in 1 blocks; 7168 free (20 chunks); 1024 used Sequence values: 8192 total in 1 blocks; 2664 free (0 chunks); 5528 used Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used MessageContext: 67108864 total in 18 blocks; 4918512 free (203 chunks); 62190352 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 385876136 total in 56 blocks; 3674640 free (193 chunks); 382201496 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Relcache by OID: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 243568 free (85 chunks); 272528 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8120 free (3 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (4 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 4112 free (11 chunks); 57680 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6208 free (23 chunks); 1984 used SPI Exec: 201326760 total in 34 blocks; 470760 free (105 chunks); 200856000 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 256168 free (50 chunks); 259928 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 5232 free (15 chunks); 56560 used TopTransactionContext: 8192 total in 1 blocks; 7256 free (21 chunks); 936 used Sequence values: 8192 total in 1 blocks; 2664 free (0 chunks); 5528 used Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used MessageContext: 67108864 total in 18 blocks; 4918512 free (203 chunks); 62190352 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 578805760 total in 78 blocks; 3815032 free (222 chunks); 574990728 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Relcache by OID: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 247024 free (89 chunks); 269072 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 144 free (1 chunks); 880 used MdSmgr: 8192 total in 1 blocks; 8120 free (3 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (4 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 3960 free (10 chunks); 57832 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6120 free (22 chunks); 2072 used SPI Exec: 226492584 total in 37 blocks; 8382840 free (98 chunks); 218109744 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 251816 free (42 chunks); 264280 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 5560 free (18 chunks); 56232 used TopTransactionContext: 8192 total in 1 blocks; 7256 free (21 chunks); 936 used Sequence values: 8192 total in 1 blocks; 2664 free (0 chunks); 5528 used Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used MessageContext: 67108864 total in 18 blocks; 4918512 free (203 chunks); 62190352 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 763355136 total in 100 blocks; 6983168 free (295 chunks); 756371968 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Relcache by OID: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 242760 free (74 chunks); 273336 used pg_constraint_conrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8080 free (2 chunks); 112 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (4 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 5256 free (16 chunks); 56536 used TopTransactionContext: 8192 total in 1 blocks; 7168 free (20 chunks); 1024 used Sequence values: 8192 total in 1 blocks; 2664 free (0 chunks); 5528 used Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used MessageContext: 67108864 total in 18 blocks; 4918512 free (203 chunks); 62190352 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 769654952 total in 103 blocks; 114984 free (296 chunks); 769539968 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Relcache by OID: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 247768 free (78 chunks); 268328 used pg_constraint_conrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8080 free (2 chunks); 112 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (4 chunks); 32 used [53f203cf.585e:43] ERROR: out of memory [53f203cf.585e:44] DETAIL: Failed on request of size 1234. [53f203cf.585e:45] STATEMENT: INSERT INTO CHECK2_TBL VALUES (4, 'check ok', -2); [53f203cf.585e:46] LOG: statement: INSERT INTO CHECK2_TBL VALUES (1, 'x check failed', -2); TopMemoryContext: 61792 total in 9 blocks; 4112 free (11 chunks); 57680 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6208 free (23 chunks); 1984 used SPI Exec: 243261440 total in 38 blocks; 6623672 free (100 chunks); 236637768 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 259640 free (52 chunks); 256456 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 144 free (1 chunks); 880 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 3808 free (9 chunks); 57984 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6120 free (22 chunks); 2072 used SPI Exec: 260038656 total in 40 blocks; 4354032 free (129 chunks); 255684624 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 253352 free (42 chunks); 262744 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 5384 free (16 chunks); 56408 used TopTransactionContext: 8192 total in 1 blocks; 7256 free (21 chunks); 936 used Sequence values: 8192 total in 1 blocks; 2664 free (0 chunks); 5528 used Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used MessageContext: 67108864 total in 18 blocks; 4918496 free (203 chunks); 62190368 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 335536128 total in 49 blocks; 3666272 free (170 chunks); 331869856 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Relcache by OID: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 249816 free (82 chunks); 266280 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8160 free (4 chunks); 32 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (3 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 3808 free (9 chunks); 57984 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6208 free (23 chunks); 1984 used SPI Exec: 276815872 total in 42 blocks; 1935352 free (126 chunks); 274880520 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 249536 free (43 chunks); 266560 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 2024 free (1 chunks); 1048 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 4952 free (14 chunks); 56840 used TopTransactionContext: 8192 total in 1 blocks; 7256 free (21 chunks); 936 used Sequence values: 8192 total in 1 blocks; 2664 free (0 chunks); 5528 used Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used MessageContext: 67108864 total in 18 blocks; 4918496 free (203 chunks); 62190368 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 545259688 total in 75 blocks; 6056288 free (192 chunks); 539203400 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Relcache by OID: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 236952 free (58 chunks); 279144 used pg_constraint_conrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8080 free (2 chunks); 112 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (3 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 3656 free (8 chunks); 58136 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6208 free (23 chunks); 1984 used SPI Exec: 301981696 total in 45 blocks; 7791088 free (84 chunks); 294190608 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 249256 free (42 chunks); 266840 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 5600 free (16 chunks); 56192 used Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used TopTransactionContext: 8192 total in 1 blocks; 4840 free (21 chunks); 3352 used TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used MessageContext: 8192 total in 1 blocks; 3616 free (1 chunks); 4576 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 309771264 total in 37816 blocks; 4556568 free (75887 chunks); 305214696 used ExecutorState: 25157632 total in 12 blocks; 3144008 free (92 chunks); 22013624 used Relcache by OID: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 250224 free (69 chunks); 265872 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8160 free (4 chunks); 32 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 5232 free (15 chunks); 56560 used TopTransactionContext: 8192 total in 1 blocks; 7256 free (21 chunks); 936 used Sequence values: 8192 total in 1 blocks; 2664 free (0 chunks); 5528 used Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used MessageContext: 67108864 total in 18 blocks; 4918496 free (203 chunks); 62190368 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 763355136 total in 100 blocks; 6496880 free (205 chunks); 756858256 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Relcache by OID: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 232000 free (49 chunks); 284096 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8120 free (3 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (3 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 5256 free (16 chunks); 56536 used TopTransactionContext: 8192 total in 1 blocks; 7168 free (20 chunks); 1024 used Sequence values: 8192 total in 1 blocks; 2664 free (0 chunks); 5528 used Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used MessageContext: 67108864 total in 18 blocks; 4918496 free (203 chunks); 62190368 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 769654952 total in 103 blocks; 114984 free (296 chunks); 769539968 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Relcache by OID: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 241984 free (67 chunks); 274112 used pg_constraint_conrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8080 free (2 chunks); 112 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (3 chunks); 32 used [53f203cf.585e:47] ERROR: out of memory [53f203cf.585e:48] DETAIL: Failed on request of size 1234. [53f203cf.585e:49] STATEMENT: INSERT INTO CHECK2_TBL VALUES (1, 'x check failed', -2); [53f203cf.585e:50] LOG: statement: INSERT INTO CHECK2_TBL VALUES (5, 'z check failed', 10); TopMemoryContext: 61792 total in 9 blocks; 3656 free (8 chunks); 58136 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6208 free (23 chunks); 1984 used SPI Exec: 318758912 total in 47 blocks; 5456936 free (87 chunks); 313301976 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 253272 free (44 chunks); 262824 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 144 free (1 chunks); 880 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 5448 free (15 chunks); 56344 used Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used TopTransactionContext: 8192 total in 1 blocks; 4752 free (20 chunks); 3440 used TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used MessageContext: 8192 total in 1 blocks; 3616 free (1 chunks); 4576 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 309771264 total in 37816 blocks; 4556568 free (75887 chunks); 305214696 used ExecutorState: 75497640 total in 19 blocks; 4245152 free (23 chunks); 71252488 used Relcache by OID: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 241688 free (42 chunks); 274408 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8120 free (3 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used [53f203cf.5861:117] LOG: statement: select * from d; [53f203cf.5861:118] LOG: statement: create table p1(ff1 int); [53f203cf.5861:119] LOG: statement: alter table p1 add constraint p1chk check (ff1 > 0) no inherit; TopMemoryContext: 61792 total in 9 blocks; 3656 free (8 chunks); 58136 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6208 free (23 chunks); 1984 used SPI Exec: 335536128 total in 49 blocks; 3604176 free (116 chunks); 331931952 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 254680 free (48 chunks); 261416 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 5600 free (16 chunks); 56192 used Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used TopTransactionContext: 8192 total in 1 blocks; 4840 free (21 chunks); 3352 used TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used MessageContext: 8192 total in 1 blocks; 3616 free (1 chunks); 4576 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 309771264 total in 37816 blocks; 4556568 free (75887 chunks); 305214696 used ExecutorState: 125820928 total in 24 blocks; 4693872 free (103 chunks); 121127056 used Relcache by OID: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 250560 free (71 chunks); 265536 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 144 free (1 chunks); 880 used MdSmgr: 8192 total in 1 blocks; 8120 free (3 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 4800 free (13 chunks); 56992 used TopTransactionContext: 8192 total in 1 blocks; 7168 free (20 chunks); 1024 used Sequence values: 8192 total in 1 blocks; 2664 free (0 chunks); 5528 used Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used MessageContext: 67108864 total in 18 blocks; 4918496 free (203 chunks); 62190368 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 352321704 total in 52 blocks; 6380232 free (182 chunks); 345941472 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Relcache by OID: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 226600 free (51 chunks); 289496 used pg_constraint_conrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8080 free (2 chunks); 112 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (3 chunks); 32 used [53f203cf.5861:120] LOG: statement: alter table p1 add constraint p2chk check (ff1 > 10); TopMemoryContext: 61792 total in 9 blocks; 3960 free (10 chunks); 57832 used CFuncHash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used TopTransactionContext: 8192 total in 1 blocks; 6208 free (23 chunks); 1984 used SPI Exec: 352313344 total in 51 blocks; 84256 free (72 chunks); 352229088 used CachedPlanSource: 3072 total in 2 blocks; 672 free (0 chunks); 2400 used SPI Proc: 8192 total in 1 blocks; 8088 free (0 chunks); 104 used MessageContext: 4194304 total in 10 blocks; 1120840 free (130 chunks); 3073464 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 243261440 total in 38 blocks; 3436120 free (250 chunks); 239825320 used 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: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 252984 free (52 chunks); 263112 used fkeys2p_i: 1024 total in 1 blocks; 144 free (0 chunks); 880 used fkeys2_i: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 144 free (1 chunks); 880 used MdSmgr: 8192 total in 1 blocks; 8120 free (4 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 4760 free (13 chunks); 57032 used Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used TopTransactionContext: 8192 total in 1 blocks; 4840 free (21 chunks); 3352 used TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used MessageContext: 8192 total in 1 blocks; 3616 free (1 chunks); 4576 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 309771264 total in 37816 blocks; 4556568 free (75887 chunks); 305214696 used ExecutorState: 176152576 total in 30 blocks; 7300736 free (107 chunks); 168851840 used Relcache by OID: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 233616 free (41 chunks); 282480 used pg_attrdef_adrelid_adnum_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_constraint_conrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attrdef_adrelid_adnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used MdSmgr: 8192 total in 1 blocks; 8080 free (2 chunks); 112 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (5 chunks); 32 used TopMemoryContext: 61792 total in 9 blocks; 5080 free (14 chunks); 56712 used TopTransactionContext: 8192 total in 1 blocks; 7256 free (21 chunks); 936 used Sequence values: 8192 total in 1 blocks; 2664 free (0 chunks); 5528 used Operator lookup cache: 24576 total in 2 blocks; 11848 free (4 chunks); 12728 used TableSpace cache: 8192 total in 1 blocks; 3176 free (0 chunks); 5016 used MessageContext: 67108864 total in 18 blocks; 4918496 free (203 chunks); 62190368 used Operator class cache: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used smgr relation table: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1640 free (0 chunks); 6552 used PortalMemory: 8192 total in 1 blocks; 7880 free (0 chunks); 312 used PortalHeapMemory: 1024 total in 1 blocks; 840 free (0 chunks); 184 used ExecutorState: 553639936 total in 75 blocks; 6446656 free (168 chunks); 547193280 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Relcache by OID: 8192 total in 1 blocks; 592 free (0 chunks); 7600 used CacheMemoryContext: 516096 total in 6 blocks; 229104 free (60 chunks); 286992 used EventTriggerCache: 8192 total in 1 blocks; 8160 free (114 chunks); 32 used Event Trigger Cache: 8192 total in 1 blocks; 3712 free (0 chunks); 4480 used pg_auth_members_member_role_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_authid_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_authid_rolname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_database_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_database_datname_index: 1024 total in 1 blocks; 144 free (0 chunks); 880 used pg_trigger_tgrelid_tgname_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_rewrite_rel_rulename_index: 1024 total in 1 blocks; 8 free (0 chunks); 1016 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1672 free (1 chunks); 1400 used pg_opclass_oid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_index_indexrelid_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1968 free (0 chunks); 1104 used pg_class_oid_index: 1024 total in 1 blocks; 144 free (1 chunks); 880 used MdSmgr: 8192 total in 1 blocks; 8120 free (3 chunks); 72 used ident parser context: 0 total in 0 blocks; 0 free (0 chunks); 0 used hba parser context: 7168 total in 3 blocks; 3920 free (1 chunks); 3248 used LOCALLOCK hash: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used Timezones: 83480 total in 2 blocks; 3712 free (0 chunks); 79768 used ErrorContext: 8192 total in 1 blocks; 8160 free (3 chunks); 32 used [53ebafad.1055:2] LOG: server process (PID 22622) was terminated by signal 9: Killed [53ebafad.1055:3] DETAIL: Failed process was running: INSERT INTO CHECK2_TBL VALUES (5, 'z check failed', 10); [53ebafad.1055:4] LOG: terminating any other active server processes [53f203cf.5862:27] WARNING: terminating connection because of crash of another server process [53f203cf.5862:28] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. [53f203cf.5862:29] HINT: In a moment you should be able to reconnect to the database and repeat your command. [53f203cf.5863:60] WARNING: terminating connection because of crash of another server process [53f203cf.5863:61] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. [53f203cf.5863:62] HINT: In a moment you should be able to reconnect to the database and repeat your command. [53f21799.5cb7:1] WARNING: terminating connection because of crash of another server process [53f21799.5cb7:2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers