Re: debug_print_plan (pg7.4) doesn't seem to do anything

Eric Brown <eric.brown@propel.com> writes:
> I thought setting debug_print_plan was supposed to explain every query
> in my log file? I don't see the plan print either.

No, it just prints the plan.  With settings like yours I get

DEBUG:  StartTransactionCommand
LOG:  statement: select 2+2;
DEBUG:  parse tree:
DETAIL:  {QUERY :commandType 1 :querySource 0 :canSetTag true :utilityStmt <>
    :resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable <>
    :jointree {FROMEXPR :fromlist <> :quals <>} :rowMarks () :targetList
    ({TARGETENTRY :resdom {RESDOM :resno 1 :restype 23 :restypmod -1 :resname
    ?column? :ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk false} :expr
    {OPEXPR :opno 551 :opfuncid 0 :opresulttype 23 :opretset false :args ({CONST
    :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue 4 [
    0 0 0 2 ]} {CONST :consttype 23 :constlen 4 :constbyval true :constisnull
    false :constvalue 4 [ 0 0 0 2 ]})}}) :groupClause <> :havingQual <>
    :distinctClause <> :sortClause <> :limitOffset <> :limitCount <>
    :setOperations <> :resultRelations ()}

DEBUG:  plan:
DETAIL:  {RESULT :startup_cost 0.00 :total_cost 0.01 :plan_rows 1 :plan_width 0
    :targetlist ({TARGETENTRY :resdom {RESDOM :resno 1 :restype 23 :restypmod -1
    :resname ?column? :ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk
    false} :expr {CONST :consttype 23 :constlen 4 :constbyval true :constisnull
    false :constvalue 4 [ 0 0 0 4 ]}}) :qual <> :lefttree <> :righttree <>
    :initPlan <> :extParam () :allParam () :nParamExec 0 :resconstantqual <>}

DEBUG:  PortalRun
DEBUG:  CommitTransactionCommand
LOG:  duration: 7.439 ms

Maybe you forgot "pg_ctl reload" after changing your config?

            regards, tom lane