Postgres Pro
Downloads
Home   >   mailing lists

how to get the total statistics info and query time for many queries - Mailing list pgsql-general

From Yinan Li
Subject how to get the total statistics info and query time for many queries
Date
Msg-id 00db01c7fe7d$ffb7ef40$ff27cdc0$@ust.hk
Whole thread Raw
List pgsql-general
Tree view

Hi,

 

         With the option “-s” and “\timing”, I can get the statistics info from the postmaster process and query time from the psql process. My question is that how can I get the total statistics info and query time for many queries, such as 100 search query?

         Any help would be really appreciated.

 

Regards,

Yinan

pgsql-general by date:

Previous
From: "Anoo Sivadasan Pillai"
Date:
Subject: Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?
Next
From: "Ashish Karalkar"
Date:
Subject: Re: Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug?