Re: unreliable behaviour of track_functions

2018-04-01 Thread Adrian Klaver
On 04/01/2018 06:02 AM, pinker wrote: I mean this part describing track_function: https://www.postgresql.org/docs/10/static/runtime-config-statistics.html Enables tracking of function call counts and time used. Specify pl to track only procedural-language functions, all to also track SQL and C

Re: unreliable behaviour of track_functions

2018-04-01 Thread pinker
and to be clear I was experimenting with pg_stat_clear_snapshot() after your answer, but it doesn't change behaviour of track_functions. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: unreliable behaviour of track_functions

2018-04-01 Thread pinker
I mean this part describing track_function: https://www.postgresql.org/docs/10/static/runtime-config-statistics.html Enables tracking of function call counts and time used. Specify pl to track only procedural-language functions, all to also track SQL and C language functions. The default is none,

Re: unreliable behaviour of track_functions

2018-04-01 Thread pinker
I mean this part describing track_function: https://www.postgresql.org/docs/10/static/runtime-config-statistics.html Enables tracking of function call counts and time used. Specify pl to track only procedural-language functions, all to also track SQL and C language functions. The default is none,

Re: unreliable behaviour of track_functions

2018-03-31 Thread Adrian Klaver
On 03/31/2018 05:17 PM, pinker wrote: Adrian Klaver-4 wrote https://www.postgresql.org/docs/10/static/monitoring-stats.html#PG-STAT-USER-FUNCTIONS-VIEW "...But if you want to see new results with each query, be sure to do the queries outside any transaction block. Alternatively, you can invoke

Re: unreliable behaviour of track_functions

2018-03-31 Thread pinker
Adrian Klaver-4 wrote > https://www.postgresql.org/docs/10/static/monitoring-stats.html#PG-STAT-USER-FUNCTIONS-VIEW > > "...But if you want to see new results with each query, be sure to do > the queries outside any transaction block. Alternatively, you can invoke > pg_stat_clear_snapshot(), whi

Re: unreliable behaviour of track_functions

2018-03-31 Thread Adrian Klaver
On 03/31/2018 04:40 PM, pinker wrote: Hi All! I've been experimenting with track_functions options and what I've saw it's really puzzling me. Documentation says: / SQL-language functions that are simple enough to be "inlined" into the calling query will not be tracked, regardless of this setting

unreliable behaviour of track_functions

2018-03-31 Thread pinker
Hi All! I've been experimenting with track_functions options and what I've saw it's really puzzling me. Documentation says: / SQL-language functions that are simple enough to be "inlined" into the calling query will not be tracked, regardless of this setting./ But it came up, it depends on much