kgrittn@ATHENA:~> gdb /usr/local/pgsql-8.4devel-20090202/bin/postgres 10750 GNU gdb 6.6 Copyright (C) 2006 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "x86_64-suse-linux"... Using host libthread_db library "/lib64/libthread_db.so.1". Attaching to program: /usr/local/pgsql-8.4devel-20090202/bin/postgres, process 10750 Reading symbols from /usr/lib64/libxml2.so.2...done. Loaded symbols for /usr/lib64/libxml2.so.2 Reading symbols from /lib64/libdl.so.2...done. Loaded symbols for /lib64/libdl.so.2 Reading symbols from /lib64/libm.so.6...done. Loaded symbols for /lib64/libm.so.6 Reading symbols from /lib64/libc.so.6...done. Loaded symbols for /lib64/libc.so.6 Reading symbols from /lib64/libz.so.1...done. Loaded symbols for /lib64/libz.so.1 Reading symbols from /lib64/ld-linux-x86-64.so.2...done. Loaded symbols for /lib64/ld-linux-x86-64.so.2 Reading symbols from /lib64/libnss_compat.so.2...done. Loaded symbols for /lib64/libnss_compat.so.2 Reading symbols from /lib64/libnsl.so.1...done. Loaded symbols for /lib64/libnsl.so.1 Reading symbols from /lib64/libnss_nis.so.2...done. Loaded symbols for /lib64/libnss_nis.so.2 Reading symbols from /lib64/libnss_files.so.2...done. Loaded symbols for /lib64/libnss_files.so.2 0x0000000000465d6a in index_getnext (scan=0x2b423d644c88, direction=ForwardScanDirection) at indexam.c:554 554 if (at_chain_start && HeapTupleIsHeapOnly(heapTuple)) (gdb) bt #0 0x0000000000465d6a in index_getnext (scan=0x2b423d644c88, direction=ForwardScanDirection) at indexam.c:554 #1 0x000000000053a35c in IndexNext (node=0x2b423d643c90) at nodeIndexscan.c:109 #2 0x000000000053190c in ExecScan (node=0x2b424ac190b8, accessMtd=0x53a260 ) at execScan.c:68 #3 0x000000000052ac8a in ExecProcNode (node=0x2b423d643c90) at execProcnode.c:367 #4 0x000000000053b749 in ExecMergeJoin (node=0x2b423d63f410) at nodeMergejoin.c:845 #5 0x000000000052ad1a in ExecProcNode (node=0x2b423d63f410) at execProcnode.c:408 #6 0x000000000053b7b1 in ExecMergeJoin (node=0x2b423d63e8c0) at nodeMergejoin.c:1181 #7 0x000000000052ad1a in ExecProcNode (node=0x2b423d63e8c0) at execProcnode.c:408 #8 0x000000000053bdcf in ExecNestLoop (node=0x2b423d63de50) at nodeNestloop.c:120 #9 0x000000000052ad0a in ExecProcNode (node=0x2b423d63de50) at execProcnode.c:404 #10 0x0000000000538d29 in ExecHashJoin (node=0x2b423d63c9d0) at nodeHashjoin.c:567 #11 0x000000000052ad2a in ExecProcNode (node=0x2b423d63c9d0) at execProcnode.c:412 #12 0x0000000000538d29 in ExecHashJoin (node=0x18e8ee0) at nodeHashjoin.c:567 #13 0x000000000052ad2a in ExecProcNode (node=0x18e8ee0) at execProcnode.c:412 #14 0x0000000000534c0d in ExecAppend (node=0x18e8db0) at nodeAppend.c:269 #15 0x000000000052ac63 in ExecProcNode (node=0x18e8db0) at execProcnode.c:348 #16 0x0000000000535c4c in ExecAgg (node=0x18e8190) at nodeAgg.c:1053 #17 0x000000000052ad6a in ExecProcNode (node=0x18e8190) at execProcnode.c:431 #18 0x000000000053d63d in ExecSort (node=0x18e8080) at nodeSort.c:102 #19 0x000000000052ad4a in ExecProcNode (node=0x18e8080) at execProcnode.c:423 #20 0x0000000000528aaf in standard_ExecutorRun (queryDesc=0x14d1540, direction=ForwardScanDirection, count=0) at execMain.c:1504 #21 0x00000000004eeb9f in ExplainOnePlan (plannedstmt=0x14d15d0, stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"na meF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=, tstate=0xbc8c70) at explain.c:262 #22 0x00000000004eeda0 in ExplainQuery (stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"na meF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=0x0, dest=0xc4bb08) at explain.c:175 #23 0x00000000005c9489 in PortalRunUtility (portal=0xb108f0, utilityStmt=0xc1b7d0, isTopLevel=104 'h', dest=0xc4bb08, completionTag=0x7fff6d534c90 "") at pquery.c:1191 #24 0x00000000005ca614 in FillPortalStore (portal=0xb108f0, isTopLevel=100 'd') at pquery.c:1066 #25 0x00000000005cabd3 in PortalRun (portal=0x2b424ac190b8, count=9223372036854775807, isTopLevel=1 '\001', dest=0xc1bb10, altdest=0xc1bb10, completionTag=0x7fff6d534e70 "") at pquery.c:802 #26 0x00000000005c68cb in exec_simple_query ( query_string=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"n ameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"...) at postgres.c:991 #27 0x00000000005c75e4 in PostgresMain (argc=4, argv=0xa1d060, username=0xa1d030 "kgrittn") at postgres.c:3606 #28 0x000000000059f0e9 in ServerLoop () at postmaster.c:3258 #29 0x000000000059fbfa in PostmasterMain (argc=3, argv=0xa172e0) at postmaster.c:1031 #30 0x000000000054f2be in main (argc=3, argv=0xa172e0) at main.c:188 (gdb) (gdb) bt #0 0x0000000000465d6a in index_getnext (scan=0x2b423d644c88, direction=ForwardScanDirection) at indexam.c:554 #1 0x000000000053a35c in IndexNext (node=0x2b423d643c90) at nodeIndexscan.c:109 #2 0x000000000053190c in ExecScan (node=0x2b424ac190b8, accessMtd=0x53a260 ) at execScan.c:68 #3 0x000000000052ac8a in ExecProcNode (node=0x2b423d643c90) at execProcnode.c:367 #4 0x000000000053b749 in ExecMergeJoin (node=0x2b423d63f410) at nodeMergejoin.c:845 #5 0x000000000052ad1a in ExecProcNode (node=0x2b423d63f410) at execProcnode.c:408 #6 0x000000000053b7b1 in ExecMergeJoin (node=0x2b423d63e8c0) at nodeMergejoin.c:1181 #7 0x000000000052ad1a in ExecProcNode (node=0x2b423d63e8c0) at execProcnode.c:408 #8 0x000000000053bdcf in ExecNestLoop (node=0x2b423d63de50) at nodeNestloop.c:120 #9 0x000000000052ad0a in ExecProcNode (node=0x2b423d63de50) at execProcnode.c:404 #10 0x0000000000538d29 in ExecHashJoin (node=0x2b423d63c9d0) at nodeHashjoin.c:567 #11 0x000000000052ad2a in ExecProcNode (node=0x2b423d63c9d0) at execProcnode.c:412 #12 0x0000000000538d29 in ExecHashJoin (node=0x18e8ee0) at nodeHashjoin.c:567 #13 0x000000000052ad2a in ExecProcNode (node=0x18e8ee0) at execProcnode.c:412 #14 0x0000000000534c0d in ExecAppend (node=0x18e8db0) at nodeAppend.c:269 #15 0x000000000052ac63 in ExecProcNode (node=0x18e8db0) at execProcnode.c:348 #16 0x0000000000535c4c in ExecAgg (node=0x18e8190) at nodeAgg.c:1053 #17 0x000000000052ad6a in ExecProcNode (node=0x18e8190) at execProcnode.c:431 #18 0x000000000053d63d in ExecSort (node=0x18e8080) at nodeSort.c:102 #19 0x000000000052ad4a in ExecProcNode (node=0x18e8080) at execProcnode.c:423 #20 0x0000000000528aaf in standard_ExecutorRun (queryDesc=0x14d1540, direction=ForwardScanDirection, count=0) at execMain.c:1504 #21 0x00000000004eeb9f in ExplainOnePlan (plannedstmt=0x14d15d0, stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=, tstate=0xbc8c70) at explain.c:262 #22 0x00000000004eeda0 in ExplainQuery (stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=0x0, dest=0xc4bb08) at explain.c:175 #23 0x00000000005c9489 in PortalRunUtility (portal=0xb108f0, utilityStmt=0xc1b7d0, isTopLevel=104 'h', dest=0xc4bb08, completionTag=0x7fff6d534c90 "") at pquery.c:1191 #24 0x00000000005ca614 in FillPortalStore (portal=0xb108f0, isTopLevel=100 'd') at pquery.c:1066 #25 0x00000000005cabd3 in PortalRun (portal=0x2b424ac190b8, count=9223372036854775807, isTopLevel=1 '\001', dest=0xc1bb10, altdest=0xc1bb10, completionTag=0x7fff6d534e70 "") at pquery.c:802 #26 0x00000000005c68cb in exec_simple_query ( query_string=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"...) at postgres.c:991 #27 0x00000000005c75e4 in PostgresMain (argc=4, argv=0xa1d060, username=0xa1d030 "kgrittn") at postgres.c:3606 #28 0x000000000059f0e9 in ServerLoop () at postmaster.c:3258 #29 0x000000000059fbfa in PostmasterMain (argc=3, argv=0xa172e0) at postmaster.c:1031 #30 0x000000000054f2be in main (argc=3, argv=0xa172e0) at main.c:188 (gdb) cont Continuing. Program received signal SIGINT, Interrupt. ExecMakeFunctionResultNoSets (fcache=0x2b423d6401f0, econtext=0x2b423d63f520, isNull=0x7fff6d53428f "", isDone=) at execQual.c:1726 1726 result = FunctionCallInvoke(&fcinfo); (gdb) bt #0 ExecMakeFunctionResultNoSets (fcache=0x2b423d6401f0, econtext=0x2b423d63f520, isNull=0x7fff6d53428f "", isDone=) at execQual.c:1726 #1 0x000000000053001f in ExecQual (qual=, econtext=0x2b423d63f520, resultForNull=0 '\0') at execQual.c:4895 #2 0x000000000053b603 in ExecMergeJoin (node=0x2b423d63f410) at nodeMergejoin.c:760 #3 0x000000000052ad1a in ExecProcNode (node=0x2b423d63f410) at execProcnode.c:408 #4 0x000000000053b7b1 in ExecMergeJoin (node=0x2b423d63e8c0) at nodeMergejoin.c:1181 #5 0x000000000052ad1a in ExecProcNode (node=0x2b423d63e8c0) at execProcnode.c:408 #6 0x000000000053bdcf in ExecNestLoop (node=0x2b423d63de50) at nodeNestloop.c:120 #7 0x000000000052ad0a in ExecProcNode (node=0x2b423d63de50) at execProcnode.c:404 #8 0x0000000000538d29 in ExecHashJoin (node=0x2b423d63c9d0) at nodeHashjoin.c:567 #9 0x000000000052ad2a in ExecProcNode (node=0x2b423d63c9d0) at execProcnode.c:412 #10 0x0000000000538d29 in ExecHashJoin (node=0x18e8ee0) at nodeHashjoin.c:567 #11 0x000000000052ad2a in ExecProcNode (node=0x18e8ee0) at execProcnode.c:412 #12 0x0000000000534c0d in ExecAppend (node=0x18e8db0) at nodeAppend.c:269 #13 0x000000000052ac63 in ExecProcNode (node=0x18e8db0) at execProcnode.c:348 #14 0x0000000000535c4c in ExecAgg (node=0x18e8190) at nodeAgg.c:1053 #15 0x000000000052ad6a in ExecProcNode (node=0x18e8190) at execProcnode.c:431 #16 0x000000000053d63d in ExecSort (node=0x18e8080) at nodeSort.c:102 #17 0x000000000052ad4a in ExecProcNode (node=0x18e8080) at execProcnode.c:423 #18 0x0000000000528aaf in standard_ExecutorRun (queryDesc=0x14d1540, direction=ForwardScanDirection, count=0) at execMain.c:1504 #19 0x00000000004eeb9f in ExplainOnePlan (plannedstmt=0x14d15d0, stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=, tstate=0xbc8c70) at explain.c:262 #20 0x00000000004eeda0 in ExplainQuery (stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=0x0, dest=0xc4bb08) at explain.c:175 #21 0x00000000005c9489 in PortalRunUtility (portal=0xb108f0, utilityStmt=0xc1b7d0, isTopLevel=2 '\002', dest=0xc4bb08, completionTag=0x7fff6d534c90 "") at pquery.c:1191 #22 0x00000000005ca614 in FillPortalStore (portal=0xb108f0, isTopLevel=-1 '�') at pquery.c:1066 #23 0x00000000005cabd3 in PortalRun (portal=0x7fff6d533e50, count=9223372036854775807, isTopLevel=0 '\0', dest=0xc1bb10, altdest=0xc1bb10, completionTag=0x7fff6d534e70 "") at pquery.c:802 #24 0x00000000005c68cb in exec_simple_query ( query_string=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"...) at postgres.c:991 #25 0x00000000005c75e4 in PostgresMain (argc=4, argv=0xa1d060, username=0xa1d030 "kgrittn") at postgres.c:3606 #26 0x000000000059f0e9 in ServerLoop () at postmaster.c:3258 #27 0x000000000059fbfa in PostmasterMain (argc=3, argv=0xa172e0) at postmaster.c:1031 #28 0x000000000054f2be in main (argc=3, argv=0xa172e0) at main.c:188 (gdb) cont Continuing. Program received signal SIGINT, Interrupt. 0x0000000000638235 in texteq (fcinfo=0x7fff6d533e50) at varlena.c:1332 1332 result = (strncmp(VARDATA_ANY(arg1), VARDATA_ANY(arg2), (gdb) bt #0 0x0000000000638235 in texteq (fcinfo=0x7fff6d533e50) at varlena.c:1332 #1 0x000000000052ff80 in ExecMakeFunctionResultNoSets (fcache=0x2b423d6401f0, econtext=0x2b423d63f520, isNull=0x7fff6d53428f "", isDone=) at execQual.c:1726 #2 0x000000000053001f in ExecQual (qual=, econtext=0x2b423d63f520, resultForNull=0 '\0') at execQual.c:4895 #3 0x000000000053b603 in ExecMergeJoin (node=0x2b423d63f410) at nodeMergejoin.c:760 #4 0x000000000052ad1a in ExecProcNode (node=0x2b423d63f410) at execProcnode.c:408 #5 0x000000000053b7b1 in ExecMergeJoin (node=0x2b423d63e8c0) at nodeMergejoin.c:1181 #6 0x000000000052ad1a in ExecProcNode (node=0x2b423d63e8c0) at execProcnode.c:408 #7 0x000000000053bdcf in ExecNestLoop (node=0x2b423d63de50) at nodeNestloop.c:120 #8 0x000000000052ad0a in ExecProcNode (node=0x2b423d63de50) at execProcnode.c:404 #9 0x0000000000538d29 in ExecHashJoin (node=0x2b423d63c9d0) at nodeHashjoin.c:567 #10 0x000000000052ad2a in ExecProcNode (node=0x2b423d63c9d0) at execProcnode.c:412 #11 0x0000000000538d29 in ExecHashJoin (node=0x18e8ee0) at nodeHashjoin.c:567 #12 0x000000000052ad2a in ExecProcNode (node=0x18e8ee0) at execProcnode.c:412 #13 0x0000000000534c0d in ExecAppend (node=0x18e8db0) at nodeAppend.c:269 #14 0x000000000052ac63 in ExecProcNode (node=0x18e8db0) at execProcnode.c:348 #15 0x0000000000535c4c in ExecAgg (node=0x18e8190) at nodeAgg.c:1053 #16 0x000000000052ad6a in ExecProcNode (node=0x18e8190) at execProcnode.c:431 #17 0x000000000053d63d in ExecSort (node=0x18e8080) at nodeSort.c:102 #18 0x000000000052ad4a in ExecProcNode (node=0x18e8080) at execProcnode.c:423 #19 0x0000000000528aaf in standard_ExecutorRun (queryDesc=0x14d1540, direction=ForwardScanDirection, count=0) at execMain.c:1504 #20 0x00000000004eeb9f in ExplainOnePlan (plannedstmt=0x14d15d0, stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=, tstate=0xbc8c70) at explain.c:262 #21 0x00000000004eeda0 in ExplainQuery (stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=0x0, dest=0xc4bb08) at explain.c:175 #22 0x00000000005c9489 in PortalRunUtility (portal=0xb108f0, utilityStmt=0xc1b7d0, isTopLevel=27 '\033', dest=0xc4bb08, completionTag=0x7fff6d534c90 "") at pquery.c:1191 #23 0x00000000005ca614 in FillPortalStore (portal=0xb108f0, isTopLevel=27 '\033') at pquery.c:1066 #24 0x00000000005cabd3 in PortalRun (portal=0x2b424c795c08, count=9223372036854775807, isTopLevel=12 '\f', dest=0xc1bb10, altdest=0xc1bb10, completionTag=0x7fff6d534e70 "") at pquery.c:802 #25 0x00000000005c68cb in exec_simple_query ( query_string=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"...) at postgres.c:991 #26 0x00000000005c75e4 in PostgresMain (argc=4, argv=0xa1d060, username=0xa1d030 "kgrittn") at postgres.c:3606 #27 0x000000000059f0e9 in ServerLoop () at postmaster.c:3258 #28 0x000000000059fbfa in PostmasterMain (argc=3, argv=0xa172e0) at postmaster.c:1031 #29 0x000000000054f2be in main (argc=3, argv=0xa172e0) at main.c:188 (gdb) cont Continuing. Program received signal SIGINT, Interrupt. 0x000000000068827c in MemoryContextReset (context=0x18daec0) at mcxt.c:130 130 (*context->methods->reset) (context); (gdb) bt #0 0x000000000068827c in MemoryContextReset (context=0x18daec0) at mcxt.c:130 #1 0x000000004989b769 in ?? () #2 0x00002b423d63f410 in ?? () #3 0x00000000014e4968 in ?? () #4 0x00002b423d643c90 in ?? () #5 0x0000000000000000 in ?? () (gdb) cont Continuing. Program received signal SIGINT, Interrupt. index_getnext (scan=0x2b423d644c88, direction=ForwardScanDirection) at indexam.c:521 521 lp = PageGetItemId(dp, offnum); (gdb) bt #0 index_getnext (scan=0x2b423d644c88, direction=ForwardScanDirection) at indexam.c:521 #1 0x000000000053a35c in IndexNext (node=0x2b423d643c90) at nodeIndexscan.c:109 #2 0x000000000053190c in ExecScan (node=0x507c, accessMtd=0x53a260 ) at execScan.c:68 #3 0x000000000052ac8a in ExecProcNode (node=0x2b423d643c90) at execProcnode.c:367 #4 0x000000000053b749 in ExecMergeJoin (node=0x2b423d63f410) at nodeMergejoin.c:845 #5 0x000000000052ad1a in ExecProcNode (node=0x2b423d63f410) at execProcnode.c:408 #6 0x000000000053b7b1 in ExecMergeJoin (node=0x2b423d63e8c0) at nodeMergejoin.c:1181 #7 0x000000000052ad1a in ExecProcNode (node=0x2b423d63e8c0) at execProcnode.c:408 #8 0x000000000053bdcf in ExecNestLoop (node=0x2b423d63de50) at nodeNestloop.c:120 #9 0x000000000052ad0a in ExecProcNode (node=0x2b423d63de50) at execProcnode.c:404 #10 0x0000000000538d29 in ExecHashJoin (node=0x2b423d63c9d0) at nodeHashjoin.c:567 #11 0x000000000052ad2a in ExecProcNode (node=0x2b423d63c9d0) at execProcnode.c:412 #12 0x0000000000538d29 in ExecHashJoin (node=0x18e8ee0) at nodeHashjoin.c:567 #13 0x000000000052ad2a in ExecProcNode (node=0x18e8ee0) at execProcnode.c:412 #14 0x0000000000534c0d in ExecAppend (node=0x18e8db0) at nodeAppend.c:269 #15 0x000000000052ac63 in ExecProcNode (node=0x18e8db0) at execProcnode.c:348 #16 0x0000000000535c4c in ExecAgg (node=0x18e8190) at nodeAgg.c:1053 #17 0x000000000052ad6a in ExecProcNode (node=0x18e8190) at execProcnode.c:431 #18 0x000000000053d63d in ExecSort (node=0x18e8080) at nodeSort.c:102 #19 0x000000000052ad4a in ExecProcNode (node=0x18e8080) at execProcnode.c:423 #20 0x0000000000528aaf in standard_ExecutorRun (queryDesc=0x14d1540, direction=ForwardScanDirection, count=0) at execMain.c:1504 #21 0x00000000004eeb9f in ExplainOnePlan (plannedstmt=0x14d15d0, stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=, tstate=0xbc8c70) at explain.c:262 #22 0x00000000004eeda0 in ExplainQuery (stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=0x0, dest=0xc4bb08) at explain.c:175 #23 0x00000000005c9489 in PortalRunUtility (portal=0xb108f0, utilityStmt=0xc1b7d0, isTopLevel=35 '#', dest=0xc4bb08, completionTag=0x7fff6d534c90 "") at pquery.c:1191 #24 0x00000000005ca614 in FillPortalStore (portal=0xb108f0, isTopLevel=124 '|') at pquery.c:1066 #25 0x00000000005cabd3 in PortalRun (portal=0x507c, count=9223372036854775807, isTopLevel=1 '\001', dest=0xc1bb10, altdest=0xc1bb10, completionTag=0x7fff6d534e70 "") at pquery.c:802 #26 0x00000000005c68cb in exec_simple_query ( query_string=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"...) at postgres.c:991 #27 0x00000000005c75e4 in PostgresMain (argc=4, argv=0xa1d060, username=0xa1d030 "kgrittn") at postgres.c:3606 #28 0x000000000059f0e9 in ServerLoop () at postmaster.c:3258 #29 0x000000000059fbfa in PostmasterMain (argc=3, argv=0xa172e0) at postmaster.c:1031 #30 0x000000000054f2be in main (argc=3, argv=0xa172e0) at main.c:188 (gdb) cont Continuing. Program received signal SIGINT, Interrupt. 0xffffffffff60008c in ?? () (gdb) bt #0 0xffffffffff60008c in ?? () #1 0x00002b423d63f410 in ?? () #2 0x00002b423d643c90 in ?? () #3 0x00002b423dbb065d in gettimeofday () from /lib64/libc.so.6 #4 0x000000000052abc7 in ExecProcNode (node=0x2b423d643c90) at execProcnode.c:336 #5 0x000000000053b749 in ExecMergeJoin (node=0x2b423d63f410) at nodeMergejoin.c:845 #6 0x000000000052ad1a in ExecProcNode (node=0x2b423d63f410) at execProcnode.c:408 #7 0x000000000053b7b1 in ExecMergeJoin (node=0x2b423d63e8c0) at nodeMergejoin.c:1181 #8 0x000000000052ad1a in ExecProcNode (node=0x2b423d63e8c0) at execProcnode.c:408 #9 0x000000000053bdcf in ExecNestLoop (node=0x2b423d63de50) at nodeNestloop.c:120 #10 0x000000000052ad0a in ExecProcNode (node=0x2b423d63de50) at execProcnode.c:404 #11 0x0000000000538d29 in ExecHashJoin (node=0x2b423d63c9d0) at nodeHashjoin.c:567 #12 0x000000000052ad2a in ExecProcNode (node=0x2b423d63c9d0) at execProcnode.c:412 #13 0x0000000000538d29 in ExecHashJoin (node=0x18e8ee0) at nodeHashjoin.c:567 #14 0x000000000052ad2a in ExecProcNode (node=0x18e8ee0) at execProcnode.c:412 #15 0x0000000000534c0d in ExecAppend (node=0x18e8db0) at nodeAppend.c:269 #16 0x000000000052ac63 in ExecProcNode (node=0x18e8db0) at execProcnode.c:348 #17 0x0000000000535c4c in ExecAgg (node=0x18e8190) at nodeAgg.c:1053 #18 0x000000000052ad6a in ExecProcNode (node=0x18e8190) at execProcnode.c:431 #19 0x000000000053d63d in ExecSort (node=0x18e8080) at nodeSort.c:102 #20 0x000000000052ad4a in ExecProcNode (node=0x18e8080) at execProcnode.c:423 #21 0x0000000000528aaf in standard_ExecutorRun (queryDesc=0x14d1540, direction=ForwardScanDirection, count=0) at execMain.c:1504 #22 0x00000000004eeb9f in ExplainOnePlan (plannedstmt=0x14d15d0, stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=, tstate=0xbc8c70) at explain.c:262 #23 0x00000000004eeda0 in ExplainQuery (stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=0x0, dest=0xc4bb08) at explain.c:175 #24 0x00000000005c9489 in PortalRunUtility (portal=0xb108f0, utilityStmt=0xc1b7d0, isTopLevel=2 '\002', dest=0xc4bb08, completionTag=0x7fff6d534c90 "") at pquery.c:1191 #25 0x00000000005ca614 in FillPortalStore (portal=0xb108f0, isTopLevel=-113 '\217') at pquery.c:1066 #26 0x00000000005cabd3 in PortalRun (portal=0x2b423d646d30, count=9223372036854775807, isTopLevel=0 '\0', dest=0xc1bb10, altdest=0xc1bb10, completionTag=0x7fff6d534e70 "") at pquery.c:802 #27 0x00000000005c68cb in exec_simple_query ( query_string=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"...) at postgres.c:991 #28 0x00000000005c75e4 in PostgresMain (argc=4, argv=0xa1d060, username=0xa1d030 "kgrittn") at postgres.c:3606 #29 0x000000000059f0e9 in ServerLoop () at postmaster.c:3258 #30 0x000000000059fbfa in PostmasterMain (argc=3, argv=0xa172e0) at postmaster.c:1031 #31 0x000000000054f2be in main (argc=3, argv=0xa172e0) at main.c:188 (gdb) cont Continuing. Program received signal SIGINT, Interrupt. ResourceOwnerRememberBuffer (owner=0x18dca90, buffer=28739) at resowner.c:526 526 if (owner != NULL) (gdb) bt #0 ResourceOwnerRememberBuffer (owner=0x18dca90, buffer=28739) at resowner.c:526 #1 0x00000000005b145c in PinBuffer (buf=0x2b423e6bc248, strategy=0x0) at bufmgr.c:1038 #2 0x00000000005b238e in ReadBuffer_common (smgr=0xb0e5f0, isLocalBuf=0 '\0', forkNum=MAIN_FORKNUM, blockNum=3830, mode=RBM_NORMAL, strategy=0x0, hit=0x7fff6d53418f "") at bufmgr.c:701 #3 0x00000000005b2a0f in ReadBufferExtended (reln=0x2b423d6307b0, forkNum=MAIN_FORKNUM, blockNum=3830, mode=RBM_NORMAL, strategy=0x0) at bufmgr.c:212 #4 0x0000000000465e5b in index_getnext (scan=0x2b423d644c88, direction=ForwardScanDirection) at indexam.c:483 #5 0x000000000053a35c in IndexNext (node=0x2b423d643c90) at nodeIndexscan.c:109 #6 0x000000000053190c in ExecScan (node=0x18dca90, accessMtd=0x53a260 ) at execScan.c:68 #7 0x000000000052ac8a in ExecProcNode (node=0x2b423d643c90) at execProcnode.c:367 #8 0x000000000053b749 in ExecMergeJoin (node=0x2b423d63f410) at nodeMergejoin.c:845 #9 0x000000000052ad1a in ExecProcNode (node=0x2b423d63f410) at execProcnode.c:408 #10 0x000000000053b7b1 in ExecMergeJoin (node=0x2b423d63e8c0) at nodeMergejoin.c:1181 #11 0x000000000052ad1a in ExecProcNode (node=0x2b423d63e8c0) at execProcnode.c:408 #12 0x000000000053bdcf in ExecNestLoop (node=0x2b423d63de50) at nodeNestloop.c:120 #13 0x000000000052ad0a in ExecProcNode (node=0x2b423d63de50) at execProcnode.c:404 #14 0x0000000000538d29 in ExecHashJoin (node=0x2b423d63c9d0) at nodeHashjoin.c:567 #15 0x000000000052ad2a in ExecProcNode (node=0x2b423d63c9d0) at execProcnode.c:412 #16 0x0000000000538d29 in ExecHashJoin (node=0x18e8ee0) at nodeHashjoin.c:567 #17 0x000000000052ad2a in ExecProcNode (node=0x18e8ee0) at execProcnode.c:412 #18 0x0000000000534c0d in ExecAppend (node=0x18e8db0) at nodeAppend.c:269 #19 0x000000000052ac63 in ExecProcNode (node=0x18e8db0) at execProcnode.c:348 #20 0x0000000000535c4c in ExecAgg (node=0x18e8190) at nodeAgg.c:1053 #21 0x000000000052ad6a in ExecProcNode (node=0x18e8190) at execProcnode.c:431 #22 0x000000000053d63d in ExecSort (node=0x18e8080) at nodeSort.c:102 #23 0x000000000052ad4a in ExecProcNode (node=0x18e8080) at execProcnode.c:423 #24 0x0000000000528aaf in standard_ExecutorRun (queryDesc=0x14d1540, direction=ForwardScanDirection, count=0) at execMain.c:1504 #25 0x00000000004eeb9f in ExplainOnePlan (plannedstmt=0x14d15d0, stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=, tstate=0xbc8c70) at explain.c:262 #26 0x00000000004eeda0 in ExplainQuery (stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=0x0, dest=0xc4bb08) at explain.c:175 #27 0x00000000005c9489 in PortalRunUtility (portal=0xb108f0, utilityStmt=0xc1b7d0, isTopLevel=0 '\0', dest=0xc4bb08, completionTag=0x7fff6d534c90 "") at pquery.c:1191 #28 0x00000000005ca614 in FillPortalStore (portal=0xb108f0, isTopLevel=0 '\0') at pquery.c:1066 #29 0x00000000005cabd3 in PortalRun (portal=0x18dca90, count=9223372036854775807, isTopLevel=67 'C', dest=0xc1bb10, altdest=0xc1bb10, completionTag=0x7fff6d534e70 "") at pquery.c:802 #30 0x00000000005c68cb in exec_simple_query ( query_string=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"...) at postgres.c:991 #31 0x00000000005c75e4 in PostgresMain (argc=4, argv=0xa1d060, username=0xa1d030 "kgrittn") at postgres.c:3606 #32 0x000000000059f0e9 in ServerLoop () at postmaster.c:3258 ---Type to continue, or q to quit--- #33 0x000000000059fbfa in PostmasterMain (argc=3, argv=0xa172e0) at postmaster.c:1031 #34 0x000000000054f2be in main (argc=3, argv=0xa172e0) at main.c:188 (gdb) cont Continuing. Program received signal SIGINT, Interrupt. 0x0000000000465d6a in index_getnext (scan=0x2b423d644c88, direction=ForwardScanDirection) at indexam.c:554 554 if (at_chain_start && HeapTupleIsHeapOnly(heapTuple)) (gdb) bt #0 0x0000000000465d6a in index_getnext (scan=0x2b423d644c88, direction=ForwardScanDirection) at indexam.c:554 #1 0x000000000053a35c in IndexNext (node=0x2b423d643c90) at nodeIndexscan.c:109 #2 0x000000000053190c in ExecScan (node=0x2b424c7f6d58, accessMtd=0x53a260 ) at execScan.c:68 #3 0x000000000052ac8a in ExecProcNode (node=0x2b423d643c90) at execProcnode.c:367 #4 0x000000000053b749 in ExecMergeJoin (node=0x2b423d63f410) at nodeMergejoin.c:845 #5 0x000000000052ad1a in ExecProcNode (node=0x2b423d63f410) at execProcnode.c:408 #6 0x000000000053b7b1 in ExecMergeJoin (node=0x2b423d63e8c0) at nodeMergejoin.c:1181 #7 0x000000000052ad1a in ExecProcNode (node=0x2b423d63e8c0) at execProcnode.c:408 #8 0x000000000053bdcf in ExecNestLoop (node=0x2b423d63de50) at nodeNestloop.c:120 #9 0x000000000052ad0a in ExecProcNode (node=0x2b423d63de50) at execProcnode.c:404 #10 0x0000000000538d29 in ExecHashJoin (node=0x2b423d63c9d0) at nodeHashjoin.c:567 #11 0x000000000052ad2a in ExecProcNode (node=0x2b423d63c9d0) at execProcnode.c:412 #12 0x0000000000538d29 in ExecHashJoin (node=0x18e8ee0) at nodeHashjoin.c:567 #13 0x000000000052ad2a in ExecProcNode (node=0x18e8ee0) at execProcnode.c:412 #14 0x0000000000534c0d in ExecAppend (node=0x18e8db0) at nodeAppend.c:269 #15 0x000000000052ac63 in ExecProcNode (node=0x18e8db0) at execProcnode.c:348 #16 0x0000000000535c4c in ExecAgg (node=0x18e8190) at nodeAgg.c:1053 #17 0x000000000052ad6a in ExecProcNode (node=0x18e8190) at execProcnode.c:431 #18 0x000000000053d63d in ExecSort (node=0x18e8080) at nodeSort.c:102 #19 0x000000000052ad4a in ExecProcNode (node=0x18e8080) at execProcnode.c:423 #20 0x0000000000528aaf in standard_ExecutorRun (queryDesc=0x14d1540, direction=ForwardScanDirection, count=0) at execMain.c:1504 #21 0x00000000004eeb9f in ExplainOnePlan (plannedstmt=0x14d15d0, stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=, tstate=0xbc8c70) at explain.c:262 #22 0x00000000004eeda0 in ExplainQuery (stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=0x0, dest=0xc4bb08) at explain.c:175 #23 0x00000000005c9489 in PortalRunUtility (portal=0xb108f0, utilityStmt=0xc1b7d0, isTopLevel=-104 '\230', dest=0xc4bb08, completionTag=0x7fff6d534c90 "") at pquery.c:1191 #24 0x00000000005ca614 in FillPortalStore (portal=0xb108f0, isTopLevel=-108 '\224') at pquery.c:1066 #25 0x00000000005cabd3 in PortalRun (portal=0x2b424c7f6d58, count=9223372036854775807, isTopLevel=1 '\001', dest=0xc1bb10, altdest=0xc1bb10, completionTag=0x7fff6d534e70 "") at pquery.c:802 #26 0x00000000005c68cb in exec_simple_query ( query_string=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"...) at postgres.c:991 #27 0x00000000005c75e4 in PostgresMain (argc=4, argv=0xa1d060, username=0xa1d030 "kgrittn") at postgres.c:3606 #28 0x000000000059f0e9 in ServerLoop () at postmaster.c:3258 #29 0x000000000059fbfa in PostmasterMain (argc=3, argv=0xa172e0) at postmaster.c:1031 #30 0x000000000054f2be in main (argc=3, argv=0xa172e0) at main.c:188 (gdb) cont Continuing. Program received signal SIGINT, Interrupt. LWLockAcquire (lockid=791, mode=LW_SHARED) at lwlock.c:380 380 SpinLockAcquire(&lock->mutex); (gdb) bt #0 LWLockAcquire (lockid=791, mode=LW_SHARED) at lwlock.c:380 #1 0x0000000000465ccd in index_getnext (scan=0x2b423d644c88, direction=ForwardScanDirection) at indexam.c:506 #2 0x000000000053a35c in IndexNext (node=0x2b423d643c90) at nodeIndexscan.c:109 #3 0x000000000053190c in ExecScan (node=0x317, accessMtd=0x53a260 ) at execScan.c:68 #4 0x000000000052ac8a in ExecProcNode (node=0x2b423d643c90) at execProcnode.c:367 #5 0x000000000053b749 in ExecMergeJoin (node=0x2b423d63f410) at nodeMergejoin.c:845 #6 0x000000000052ad1a in ExecProcNode (node=0x2b423d63f410) at execProcnode.c:408 #7 0x000000000053b7b1 in ExecMergeJoin (node=0x2b423d63e8c0) at nodeMergejoin.c:1181 #8 0x000000000052ad1a in ExecProcNode (node=0x2b423d63e8c0) at execProcnode.c:408 #9 0x000000000053bdcf in ExecNestLoop (node=0x2b423d63de50) at nodeNestloop.c:120 #10 0x000000000052ad0a in ExecProcNode (node=0x2b423d63de50) at execProcnode.c:404 #11 0x0000000000538d29 in ExecHashJoin (node=0x2b423d63c9d0) at nodeHashjoin.c:567 #12 0x000000000052ad2a in ExecProcNode (node=0x2b423d63c9d0) at execProcnode.c:412 #13 0x0000000000538d29 in ExecHashJoin (node=0x18e8ee0) at nodeHashjoin.c:567 #14 0x000000000052ad2a in ExecProcNode (node=0x18e8ee0) at execProcnode.c:412 #15 0x0000000000534c0d in ExecAppend (node=0x18e8db0) at nodeAppend.c:269 #16 0x000000000052ac63 in ExecProcNode (node=0x18e8db0) at execProcnode.c:348 #17 0x0000000000535c4c in ExecAgg (node=0x18e8190) at nodeAgg.c:1053 #18 0x000000000052ad6a in ExecProcNode (node=0x18e8190) at execProcnode.c:431 #19 0x000000000053d63d in ExecSort (node=0x18e8080) at nodeSort.c:102 #20 0x000000000052ad4a in ExecProcNode (node=0x18e8080) at execProcnode.c:423 #21 0x0000000000528aaf in standard_ExecutorRun (queryDesc=0x14d1540, direction=ForwardScanDirection, count=0) at execMain.c:1504 #22 0x00000000004eeb9f in ExplainOnePlan (plannedstmt=0x14d15d0, stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=, tstate=0xbc8c70) at explain.c:262 #23 0x00000000004eeda0 in ExplainQuery (stmt=0xc1b7d0, queryString=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"..., params=0x0, dest=0xc4bb08) at explain.c:175 #24 0x00000000005c9489 in PortalRunUtility (portal=0xb108f0, utilityStmt=0xc1b7d0, isTopLevel=0 '\0', dest=0xc4bb08, completionTag=0x7fff6d534c90 "") at pquery.c:1191 #25 0x00000000005ca614 in FillPortalStore (portal=0xb108f0, isTopLevel=3 '\003') at pquery.c:1066 #26 0x00000000005cabd3 in PortalRun (portal=0x317, count=9223372036854775807, isTopLevel=1 '\001', dest=0xc1bb10, altdest=0xc1bb10, completionTag=0x7fff6d534e70 "") at pquery.c:802 #27 0x00000000005c68cb in exec_simple_query ( query_string=0xb12900 "explain analyze \n(\nSELECT\n\"C\".\"caseNo\",\n\"C\".\"filingDate\",\n\"CY\".\"countyName\",\n\"S\".\"descr\" AS \"statusCodeDescr\",\n\"P\".\"nameF\",\n\"P\".\"nameM\",\n\"P\".\"nameL\",\n\"P\".\"suffix\",\n\"P\".\"dob\",\n\"C\".\"caption\",\n\"CY\".\"coun"...) at postgres.c:991 #28 0x00000000005c75e4 in PostgresMain (argc=4, argv=0xa1d060, username=0xa1d030 "kgrittn") at postgres.c:3606 #29 0x000000000059f0e9 in ServerLoop () at postmaster.c:3258 #30 0x000000000059fbfa in PostmasterMain (argc=3, argv=0xa172e0) at postmaster.c:1031 #31 0x000000000054f2be in main (argc=3, argv=0xa172e0) at main.c:188 (gdb) cont Continuing.