[HACKERS] Planning counters in pg_stat_statements
От | Thomas Munro |
---|---|
Тема | [HACKERS] Planning counters in pg_stat_statements |
Дата | |
Msg-id | CAEepm=0e59Y_6Q_YXYCTHZkqOc6H2pJ54C_Xe=VFu50Aqqp_sA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: [HACKERS] Planning counters in pg_stat_statements
Re: [HACKERS] Planning counters in pg_stat_statements |
Список | pgsql-hackers |
Hi hackers, I have often wanted $SUBJECT and was happy to find that Fujii-san had posted a patch five years ago[1]. The reception then seemed positive. So here is a refurbished and (hopefully) improved version of his patch with a new column for the replan count. Thoughts? Example output: query | plans | plan_time | calls | total_time --------------------------------+-------+-----------+-------+------------ prepare x as select $1 | 1 | 0.026 | 12 | 0.06 select substr(query, $1, $2), | 11 | 1.427 | 11 | 3.565 prepare y as select * from foo | 2 | 7.336 | 5 | 0.331 I agree with the sentiment on the old thread that {total,min,max,mean,stddev}_time now seem badly named, but adding "execution" makes them so long... Thoughts? [1] https://www.postgresql.org/message-id/CAHGQGwFx_%3DDO-Gu-MfPW3VQ4qC7TfVdH2zHmvZfrGv6fQ3D-Tw%40mail.gmail.com -- Thomas Munro http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Вложения
В списке pgsql-hackers по дате отправления: