How Do You Associate a Query With its Invoking Procedure?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: How Do You Associate a Query With its Invoking Procedure?
From: Fd Habash <fmhabash@xxxxxxxxx>
Date: Thu, 13 Sep 2018 15:49:41 -0400
Importance: normal

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

Follow-Ups:
- Re: How Do You Associate a Query With its Invoking Procedure?
  - From: Roman Konoval
- Re: How Do You Associate a Query With its Invoking Procedure?
  - From: David G. Johnston
- Re: How Do You Associate a Query With its Invoking Procedure?
  - From: Fred Habash

Prev by Date: Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours
Next by Date: Re: Performance of INSERT into temporary tables using psqlODBC driver
Previous by thread: Select count(*) on a 2B Rows Tables Takes ~20 Hours
Next by thread: Re: How Do You Associate a Query With its Invoking Procedure?
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux