Re: contrib/pg_stat_statements 1202
От | Robert Haas |
---|---|
Тема | Re: contrib/pg_stat_statements 1202 |
Дата | |
Msg-id | 603c8f070812090726h50f41e3em68c219dab4f02b2@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: contrib/pg_stat_statements 1202 (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>) |
Ответы |
Re: contrib/pg_stat_statements 1202
Re: contrib/pg_stat_statements 1202 |
Список | pgsql-hackers |
> On the other hand, we don't have to > think of compatibility in EXPLAIN ANALYZE VERBOSE because it is newly > added in 8.4. Uh, it exists for me in 8.2.9. Welcome to psql 8.2.9, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g orterminate with semicolon to execute query \q to quit portal=# explain analyze verbose select 1; QUERY PLAN -------------------------------------------------------------------------------- ---- {RESULT :startup_cost 0.00 :total_cost 0.01 :plan_rows 1 :plan_width 0 :targetlist ( {TARGETENTRY :expr {CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue 4 [ 1 0 0 0 ] } :resno 1 :resname ?column? :ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk false } ) :qual <> :lefttree <> :righttree <> :initPlan <> :extParam (b) :allParam (b) :nParamExec 0 :resconstantqual <> } Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.010..0.012 rows=1 loops =1)Total runtime: 0.244 ms (35 rows) ...Robert
В списке pgsql-hackers по дате отправления: