query execution time

Started by David Hokszaalmost 20 years ago3 messagesgeneral

david.hoksza@seznam.cz

almost 20 years ago

Hi, is there a way how to get some more detailed times for query
execution like Kernel Time, User Time and Process Time? I would like
see the time which PG really spends with computing without times from
another processes (I'm running on Windows with PostgreSQL 8.1.3.).

Thanks,
David Hoksza

Tom Lane

tgl@sss.pgh.pa.us

almost 20 years ago

In reply to: David Hoksza (#1)

Re: query execution time

David Hoksza <david.hoksza@seznam.cz> writes:

Hi, is there a way how to get some more detailed times for query
execution like Kernel Time, User Time and Process Time?

See log_statement_stats and friends...

regards, tom lane

David Hoksza

david.hoksza@seznam.cz

almost 20 years ago

In reply to: Tom Lane (#2)

Re: query execution time

This is not exactly what I'm searching for, but thanks..

David

______________

TL> David Hoksza <david.hoksza@seznam.cz> writes:

Hi, is there a way how to get some more detailed times for query
execution like Kernel Time, User Time and Process Time?

TL> See log_statement_stats and friends...

TL> regards, tom lane