Re: [PROPOSAL] timestamp informations to pg_stat_statements - Mailing list pgsql-hackers

From legrand legrand
Subject Re: [PROPOSAL] timestamp informations to pg_stat_statements
Date
Msg-id 1520696627569-0.post@n3.nabble.com
Whole thread Raw
In response to Re: [HACKERS] [PROPOSAL] timestamp informations to pg_stat_statements  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [PROPOSAL] timestamp informations to pg_stat_statements
List 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


pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: [HACKERS] [PATCH] Incremental sort
Next
From: Alexander Korotkov
Date:
Subject: Re: [HACKERS] [PATCH] Incremental sort