Home > mailing lists

How Do You Associate a Query With its Invoking Procedure? - Mailing list pgsql-performance

From	Fd Habash
Subject	How Do You Associate a Query With its Invoking Procedure?
Date	September 13, 2018 22:49:41
Msg-id	5b9abf54.1c69fb81.8e0e4.9e2d@mx.google.com Whole thread Raw
Responses	Re: How Do You Associate a Query With its Invoking Procedure? Re: How Do You Associate a Query With its Invoking Procedure? Re: How Do You Associate a Query With its Invoking Procedure?
List	pgsql-performance

In API function may invoke 10 queries. Ideally, I would like to know what queries are invoked by it and how long each took.

I’m using pg_stat_statement. I can see the API function statement, but how do I deterministically identify all queries invoked by it?

----------------
Thank you

From: Andres Freund
Date: 13 September 2018, 22:43:47
Subject: Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours

From: Tim Cross
Date: 14 September 2018, 01:41:18
Subject: Re: Performance of INSERT into temporary tables using psqlODBC driver