Skip site navigation (1) Skip section navigation (2)

Re: Selects query stats?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, Dan Gorman <dgorman(at)hi5(dot)com>,mischa(at)ca(dot)sophos(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: Selects query stats?
Date: 2006-05-23 19:50:01
Message-ID: 20060523195001.GH28863@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-performance
Tom Lane wrote:

> Counting individual statements would add overhead (which the OP already
> declared unacceptable) and there are some definitional issues too, like
> whether to count statements executed within functions.

Yeah, the problem seems underspecified.  How do you count statements
added or removed by rewrite rules?  Statements executed to answer RI
queries?  Do you count the statements issued by clients as part of the
startup sequence?  The hypothetical "reset session" of a connection pool
handler?  How do you count 2PC -- when they are executed, or when they
are committed?  What happens to statements in transactions that are
rolled back?  What happens to a statement that is executed partially
because it failed partway (e.g. because of division by zero)?


OTOH ISTM it would be easy to modify Postgres so as to count statements
in the stat collector, by turning pgstat_report_activity into a routine
that sent a count (presumably always 1) instead of the query string, and
then just add the count to a counter on receiving.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2006-05-23 19:55:50
Subject: Re: Selects query stats?
Previous:From: Tom LaneDate: 2006-05-23 19:13:13
Subject: Re: Selects query stats?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group