proposal - queryid can be used as filter for auto_explain - Mailing list pgsql-hackers

From Pavel Stehule
Subject proposal - queryid can be used as filter for auto_explain
Date
Msg-id CAFj8pRDVFfzcC20VLE-7Lh4R=ofcd0V4gCFCnL0u_+dDtmi5OA@mail.gmail.com
Whole thread Raw
Responses Re: proposal - queryid can be used as filter for auto_explain
List pgsql-hackers
Hi

I have to investigate strange behaviour of some specific query. One possibility is non stability of plan. This is a bigger server with a bigger load, and I am a little bit afraid to use auto_explain for all queries.

Currently auto_explain doesn't support it, but it can be practical if we can specify a list of queryid as a filter of auto_explain.

What do you think about this idea?

Regards

Pavel

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Add bms_offset_members() function for bitshifting Bitmapsets
Next
From: Etsuro Fujita
Date:
Subject: Re: Import Statistics in postgres_fdw before resorting to sampling.