>>> Tom Lane <t...@sss.pgh.pa.us> wrote:
> If you can attach to the backend with gdb, try "bt", then "cont",
> then wait a few seconds, then control-C and "bt" again. Repeat
> five or ten times and see if there's any consistency to the traces.
Attached.
-Kevin
kgri...@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
<IndexNext>) 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=<value optimized out>, 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
<IndexNext>) 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=<value optimized out>, 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=<value optimized out>) at execQual.c:1726
1726 result = FunctionCallInvoke(&fcinfo);
(gdb) bt
#0 ExecMakeFunctionResultNoSets (fcache=0x2b423d6401f0,
econtext=0x2b423d63f520, isNull=0x7fff6d53428f "", isDone=<value optimized
out>) at execQual.c:1726
#1 0x000000000053001f in ExecQual (qual=<value optimized out>,
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=<value optimized out>, 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=<value optimized out>)
at execQual.c:1726
#2 0x000000000053001f in ExecQual (qual=<value optimized out>,
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=<value optimized out>, 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
<IndexNext>) 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=<value optimized out>, 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=<value optimized out>, 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
<IndexNext>) 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=<value optimized out>, 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 <return> to continue, or q <return> 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
<IndexNext>) 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=<value optimized out>, 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 <IndexNext>)
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=<value optimized out>, 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.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
