DEBUG:  query: SELECT ATTEMPTS FROM bad_urls WHERE ID=3364
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname bad_urls :relid 96568  :subquery <> :alias <> :eref { ATTR :relname bad_urls :attrs ( "id"   "data"   "attempts"   "reason" )} :inh true :inFromCl true :checkForRead true :checkForWrite false :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 13 36 ] })}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname attempts :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 3 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  rewritten parse tree:
DEBUG:  { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname bad_urls :relid 96568  :subquery <> :alias <> :eref { ATTR :relname bad_urls :attrs ( "id"   "data"   "attempts"   "reason" )} :inh true :inFromCl true :checkForRead true :checkForWrite false :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 13 36 ] })}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname attempts :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 3 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  plan: { INDEXSCAN :startup_cost 0.00 :total_cost 8.14 :rows 10 :width 4 :qptargetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname attempts :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 3 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3}}) :qpqual <> :lefttree <> :righttree <> :extprm () :locprm () :initplan <> :nprm 0  :scanrelid 1 :indxid ( 96596) :indxqual (({ EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 13 36 ] })})) :indxqualorig (({ EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 13 36 ] })})) :indxorderdir 1 }
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: INSERT INTO bad_urls(ID,DATA,ATTEMPTS,REASON) VALUES (3364,'http://www.discovery.com/stories/nature/hibirds/hibirds.html',0,'Not Found - 404')
DEBUG:  parse tree: { QUERY :command 3  :utility <> :resultRelation 1 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname bad_urls :relid 96568  :subquery <> :alias <> :eref { ATTR :relname bad_urls :attrs ( "id"   "data"   "attempts"   "reason" )} :inh false :inFromCl false :checkForRead false :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist <> :quals <>} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 13 36 ] }} { TARGETENTRY :resdom { RESDOM :resno 2 :restype 25 :restypmod -1 :resname data :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue  64 [ 0 0 0 64 104 116 116 112 58 47 47 119 119 119 46 100 105 115 99 111 118 101 114 121 46 99 111 109 47 115 116 111 114 105 101 115 47 110 97 116 117 114 101 47 104 105 98 105 114 100 115 47 104 105 98 105 114 100 115 46 104 116 109 108 ] }} { TARGETENTRY :resdom { RESDOM :resno 3 :restype 23 :restypmod -1 :resname attempts :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 4 :restype 25 :restypmod -1 :resname reason :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue  19 [ 0 0 0 19 78 111 116 32 70 111 117 110 100 32 45 32 52 48 52 ] }}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  rewritten parse tree:
DEBUG:  { QUERY :command 3  :utility <> :resultRelation 1 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname bad_urls :relid 96568  :subquery <> :alias <> :eref { ATTR :relname bad_urls :attrs ( "id"   "data"   "attempts"   "reason" )} :inh false :inFromCl false :checkForRead false :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist <> :quals <>} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 13 36 ] }} { TARGETENTRY :resdom { RESDOM :resno 2 :restype 25 :restypmod -1 :resname data :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue  64 [ 0 0 0 64 104 116 116 112 58 47 47 119 119 119 46 100 105 115 99 111 118 101 114 121 46 99 111 109 47 115 116 111 114 105 101 115 47 110 97 116 117 114 101 47 104 105 98 105 114 100 115 47 104 105 98 105 114 100 115 46 104 116 109 108 ] }} { TARGETENTRY :resdom { RESDOM :resno 3 :restype 23 :restypmod -1 :resname attempts :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 4 :restype 25 :restypmod -1 :resname reason :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue  19 [ 0 0 0 19 78 111 116 32 70 111 117 110 100 32 45 32 52 48 52 ] }}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  plan: { RESULT :startup_cost 0.00 :total_cost 0.00 :rows 0 :width 0 :qptargetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 13 36 ] }} { TARGETENTRY :resdom { RESDOM :resno 2 :restype 25 :restypmod -1 :resname data :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue  64 [ 0 0 0 64 104 116 116 112 58 47 47 119 119 119 46 100 105 115 99 111 118 101 114 121 46 99 111 109 47 115 116 111 114 105 101 115 47 110 97 116 117 114 101 47 104 105 98 105 114 100 115 47 104 105 98 105 114 100 115 46 104 116 109 108 ] }} { TARGETENTRY :resdom { RESDOM :resno 3 :restype 23 :restypmod -1 :resname attempts :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 4 :restype 25 :restypmod -1 :resname reason :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue  19 [ 0 0 0 19 78 111 116 32 70 111 117 110 100 32 45 32 52 48 52 ] }}) :qpqual <> :lefttree <> :righttree <> :extprm () :locprm () :initplan <> :nprm 0  :resconstantqual <>}
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 18076 exited with status 0
DEBUG:  StartTransactionCommand
DEBUG:  query: SELECT ATTEMPTS FROM bad_urls WHERE ID=3375
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname bad_urls :relid 96568  :subquery <> :alias <> :eref { ATTR :relname bad_urls :attrs ( "id"   "data"   "attempts"   "reason" )} :inh true :inFromCl true :checkForRead true :checkForWrite false :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 13 47 ] })}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname attempts :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 3 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  rewritten parse tree:
DEBUG:  { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname bad_urls :relid 96568  :subquery <> :alias <> :eref { ATTR :relname bad_urls :attrs ( "id"   "data"   "attempts"   "reason" )} :inh true :inFromCl true :checkForRead true :checkForWrite false :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 13 47 ] })}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname attempts :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 3 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  plan: { INDEXSCAN :startup_cost 0.00 :total_cost 8.14 :rows 10 :width 4 :qptargetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname attempts :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 3 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3}}) :qpqual <> :lefttree <> :righttree <> :extprm () :locprm () :initplan <> :nprm 0  :scanrelid 1 :indxid ( 96596) :indxqual (({ EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 13 47 ] })})) :indxqualorig (({ EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 13 47 ] })})) :indxorderdir 1 }
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: INSERT INTO bad_urls(ID,DATA,ATTEMPTS,REASON) VALUES (3375,'http://www.oit.itd.umich.edu/projects/adw2k/chordata/aves.html',0,'Unknown Host')
DEBUG:  parse tree: { QUERY :command 3  :utility <> :resultRelation 1 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname bad_urls :relid 96568  :subquery <> :alias <> :eref { ATTR :relname bad_urls :attrs ( "id"   "data"   "attempts"   "reason" )} :inh false :inFromCl false :checkForRead false :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist <> :quals <>} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 13 47 ] }} { TARGETENTRY :resdom { RESDOM :resno 2 :restype 25 :restypmod -1 :resname data :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue  66 [ 0 0 0 66 104 116 116 112 58 47 47 119 119 119 46 111 105 116 46 105 116 100 46 117 109 105 99 104 46 101 100 117 47 112 114 111 106 101 99 116 115 47 97 100 119 50 107 47 99 104 111 114 100 97 116 97 47 97 118 101 115 46 104 116 109 108 ] }} { TARGETENTRY :resdom { RESDOM :resno 3 :restype 23 :restypmod -1 :resname attempts :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 4 :restype 25 :restypmod -1 :resname reason :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue  16 [ 0 0 0 16 85 110 107 110 111 119 110 32 72 111 115 116 ] }}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  rewritten parse tree:
DEBUG:  { QUERY :command 3  :utility <> :resultRelation 1 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname bad_urls :relid 96568  :subquery <> :alias <> :eref { ATTR :relname bad_urls :attrs ( "id"   "data"   "attempts"   "reason" )} :inh false :inFromCl false :checkForRead false :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist <> :quals <>} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 13 47 ] }} { TARGETENTRY :resdom { RESDOM :resno 2 :restype 25 :restypmod -1 :resname data :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue  66 [ 0 0 0 66 104 116 116 112 58 47 47 119 119 119 46 111 105 116 46 105 116 100 46 117 109 105 99 104 46 101 100 117 47 112 114 111 106 101 99 116 115 47 97 100 119 50 107 47 99 104 111 114 100 97 116 97 47 97 118 101 115 46 104 116 109 108 ] }} { TARGETENTRY :resdom { RESDOM :resno 3 :restype 23 :restypmod -1 :resname attempts :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 4 :restype 25 :restypmod -1 :resname reason :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue  16 [ 0 0 0 16 85 110 107 110 111 119 110 32 72 111 115 116 ] }}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  plan: { RESULT :startup_cost 0.00 :total_cost 0.00 :rows 0 :width 0 :qptargetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 13 47 ] }} { TARGETENTRY :resdom { RESDOM :resno 2 :restype 25 :restypmod -1 :resname data :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue  66 [ 0 0 0 66 104 116 116 112 58 47 47 119 119 119 46 111 105 116 46 105 116 100 46 117 109 105 99 104 46 101 100 117 47 112 114 111 106 101 99 116 115 47 97 100 119 50 107 47 99 104 111 114 100 97 116 97 47 97 118 101 115 46 104 116 109 108 ] }} { TARGETENTRY :resdom { RESDOM :resno 3 :restype 23 :restypmod -1 :resname attempts :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 0 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 4 :restype 25 :restypmod -1 :resname reason :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 25 :constlen -1 :constbyval false :constisnull false :constvalue  16 [ 0 0 0 16 85 110 107 110 111 119 110 32 72 111 115 116 ] }}) :qpqual <> :lefttree <> :righttree <> :extprm () :locprm () :initplan <> :nprm 0  :resconstantqual <>}
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand