Re: [proposal] pg_stat_statements: extension timing instrumentation

2018-10-21 Thread legrand legrand
An other way is to use "waits" reporting ... something like : pgss_store (...) pgstat_report_wait_start(PG_WAIT_EXTENSION); ... pgstat_report_wait_end(); gives waits of type "Extension", name "Extension" when spending time in this part of pgss. This can help those working

[proposal] pg_stat_statements: extension timing instrumentation

2018-09-29 Thread legrand legrand
Don't you have been surprised by the duration of a query (seen in psql with \timing) and the duration for the same query found in pgss ? It seems that writting the first query text to file takes some time, that high execution rate on the same query could generate waits on locks as when pgss is u