pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedProfiler for PostgreSQL
5+ messages / 5 participants
[nested] [flat]
* Profiler for PostgreSQL
@ 2005-07-14 05:58 Agha Asif Raza <aghaasif@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Agha Asif Raza @ 2005-07-14 05:58 UTC (permalink / raw)
To: pgsql-performance
Is there any MS-SQL Server like 'Profiler' available for PostgreSQL? A
profiler is a tool that monitors the database server and outputs a detailed
trace of all the transactions/queries that are executed on a database during
a specified period of time. Kindly let me know if any of you knows of such a
tool for PostgreSQL.
Agha Asif Raza
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Profiler for PostgreSQL
@ 2005-07-14 06:27 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Agha Asif Raza <aghaasif@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Bruce Momjian @ 2005-07-14 06:27 UTC (permalink / raw)
To: Agha Asif Raza <aghaasif@gmail.com>; +Cc: pgsql-performance
Agha Asif Raza wrote:
> Is there any MS-SQL Server like 'Profiler' available for PostgreSQL? A
> profiler is a tool that monitors the database server and outputs a detailed
> trace of all the transactions/queries that are executed on a database during
> a specified period of time. Kindly let me know if any of you knows of such a
> tool for PostgreSQL.
> Agha Asif Raza
Sure see log_statement in postgresql.conf. There are a lot of settings
in there to control what is logged.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Profiler for PostgreSQL
@ 2005-07-14 06:29 Christopher Kings-Lynne <chriskl@familyhealth.com.au>
parent: Agha Asif Raza <aghaasif@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Christopher Kings-Lynne @ 2005-07-14 06:29 UTC (permalink / raw)
To: Agha Asif Raza <aghaasif@gmail.com>; +Cc: pgsql-performance
Try turning on query logging and using the 'pqa' utility on pgfoundry.org.
Chris
Agha Asif Raza wrote:
> Is there any MS-SQL Server like 'Profiler' available for PostgreSQL? A
> profiler is a tool that monitors the database server and outputs a
> detailed trace of all the transactions/queries that are executed on a
> database during a specified period of time. Kindly let me know if any of
> you knows of such a tool for PostgreSQL.
>
> Agha Asif Raza
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Profiler for PostgreSQL
@ 2005-07-14 20:47 Simon Riggs <simon@2ndquadrant.com>
parent: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 0 replies; 5+ messages in thread
From: Simon Riggs @ 2005-07-14 20:47 UTC (permalink / raw)
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>; +Cc: Agha Asif Raza <aghaasif@gmail.com>; pgsql-performance
On Thu, 2005-07-14 at 14:29 +0800, Christopher Kings-Lynne wrote:
> Try turning on query logging and using the 'pqa' utility on pgfoundry.org.
Have you got that to work for 8 ?
pqa 1.5 doesn't even work with its own test file.
Best Regards, Simon Riggs
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Profiler for PostgreSQL
@ 2005-07-15 08:19 Andreas Pflug <pgadmin@pse-consulting.de>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Andreas Pflug @ 2005-07-15 08:19 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Agha Asif Raza <aghaasif@gmail.com>; pgsql-performance
Bruce Momjian wrote:
> Agha Asif Raza wrote:
>
>>Is there any MS-SQL Server like 'Profiler' available for PostgreSQL? A
>>profiler is a tool that monitors the database server and outputs a detailed
>>trace of all the transactions/queries that are executed on a database during
>>a specified period of time. Kindly let me know if any of you knows of such a
>>tool for PostgreSQL.
>> Agha Asif Raza
>
>
> Sure see log_statement in postgresql.conf. There are a lot of settings
> in there to control what is logged.
There's nothing really comparable at the moment, but some tasks can be
done with log_statement.
I'm planning to implement a full-blown profiling like MSSQL's, but don't
expect this too soon (I'm thinking about this for a year now. So many
plans, so little time).
Regards,
Andreas
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2005-07-15 08:19 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-14 05:58 Profiler for PostgreSQL Agha Asif Raza <aghaasif@gmail.com>
2005-07-14 06:27 ` Bruce Momjian <pgman@candle.pha.pa.us>
2005-07-15 08:19 ` Andreas Pflug <pgadmin@pse-consulting.de>
2005-07-14 06:29 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2005-07-14 20:47 ` Simon Riggs <simon@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox