How Do You Associate a Query With its Invoking Procedure?

From: Fd Habash <fmhabash(at)gmail(dot)com>
To: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: How Do You Associate a Query With its Invoking Procedure?
Date: 2018-09-13 19:49:41
Message-ID: 5b9abf54.1c69fb81.8e0e4.9e2d@mx.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tim Cross 2018-09-13 22:41:18 Re: Performance of INSERT into temporary tables using psqlODBC driver
Previous Message Andres Freund 2018-09-13 19:43:47 Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours