On Sun, Jul 17, 2016 at 7:15 PM, Tom Lane wrote:
> Peter Geoghegan writes:
>> On Sun, Jul 17, 2016 at 12:22 AM, Jun Cheol Gim wrote:
>>> If we have timestamp of first and last executed, we can easily gather thess
>>> informations and there are tons of more use cases.
>
>> -1 from me.
>
>> I thin
Hi guys,
Thank you for feedbacks.
> I think that this is the job of a tool that aggregates things from
> pg_stat_statements. It's unfortunate that there isn't a good
> third-party tool that does that, but there is nothing that prevents
> it.
Right. We can do this if we aggregate it frequently
On 18/07/2016 01:06, Peter Geoghegan wrote:
> On Sun, Jul 17, 2016 at 12:22 AM, Jun Cheol Gim wrote:
>> If we have timestamp of first and last executed, we can easily gather thess
>> informations and there are tons of more use cases.
>
> -1 from me.
>
> I think that this is the job of a tool tha
On Sun, Jul 17, 2016 at 4:15 PM, Tom Lane wrote:
> The concern I've got about this proposal is that the results get very
> questionable as soon as we start dropping statement entries for lack
> of space. last_executed would be okay, perhaps, but first_executed
> not so much.
Agreed.
Also, for w
Peter Geoghegan writes:
> On Sun, Jul 17, 2016 at 12:22 AM, Jun Cheol Gim wrote:
>> If we have timestamp of first and last executed, we can easily gather thess
>> informations and there are tons of more use cases.
> -1 from me.
> I think that this is the job of a tool that aggregates things fro
On Sun, Jul 17, 2016 at 12:22 AM, Jun Cheol Gim wrote:
> If we have timestamp of first and last executed, we can easily gather thess
> informations and there are tons of more use cases.
-1 from me.
I think that this is the job of a tool that aggregates things from
pg_stat_statements. It's unfort
Hi hackers!
Following is a proposal to add timestamp informations to
`pg_stat_statements`.
# Use case
- If we want to gather list and stats for queries executed at least once
last 1 hour, we had to reset a hours ago. There is no way if we didn't.
- If we found some strange query from `pg_stat_sta
