Re: [PROPOSAL] timestamp informations to pg_stat_statements

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PROPOSAL] timestamp informations to pg_stat_statements
Date: 2018-03-10 15:43:47
Message-ID: 1520696627569-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

+1
Having the time of first occurence of a statement is very usefull for
trouble shouting,
it permits for exemple to retrieve the order of operations in some complex
cases (and thoses informations aren't taken by any third party collecting
tool, that will only be able to provide a time range of occurence).

I thougth that pgss rows where removed randomly when max rows was reached,
wouldn't having last_executed information permit a kind of LRU removal ?

Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2018-03-10 17:05:25 Re: [HACKERS] [PATCH] Incremental sort
Previous Message Alexander Korotkov 2018-03-10 15:42:04 Re: [HACKERS] [PATCH] Incremental sort