Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #325
| From | Mladen Gogala <gogala.mladen@gmail.com> |
|---|---|
| Newsgroups | comp.databases.postgresql |
| Subject | Re: Performance views/tables in PostgreSQL? |
| Date | 2012-03-22 13:16 +0000 |
| Organization | solani.org |
| Message-ID | <pan.2012.03.22.13.16.15@gmail.com> (permalink) |
| References | <4f69f15e@news.x-privat.org> |
On Wed, 21 Mar 2012 16:18:54 +0100, Pol wrote:
> Hi all,
>
> I'm just wondering, what is the equivalent of the Oracle Wait Interface
> (i.e. the V$<View_Name> system) in PostgreSQL?
>
> TIA and rgs.
>
>
> Paul...
Freeware Postgres doesn't have wait event interface. EnterpriseDB does
have one, but it isn't free.. There are some internal tables which show
statistics, the names start with "pg_".
One of the more useful ones is installed as extension:
gogala=# \d pg_stat_statements
View "public.pg_stat_statements"
Column | Type | Modifiers
---------------------+------------------+-----------
userid | oid |
dbid | oid |
query | text |
calls | bigint |
total_time | double precision |
rows | bigint |
shared_blks_hit | bigint |
shared_blks_read | bigint |
shared_blks_written | bigint |
local_blks_hit | bigint |
local_blks_read | bigint |
local_blks_written | bigint |
temp_blks_read | bigint |
temp_blks_written | bigint |
That is the basis for pg_statspack
--
http://mgogala.byethost5.com
Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar
Performance views/tables in PostgreSQL? Pol <eff.off.if.you.think.youre.getting.my.email@anon.com> - 2012-03-21 16:18 +0100
Re: Performance views/tables in PostgreSQL? Mladen Gogala <gogala.mladen@gmail.com> - 2012-03-22 13:16 +0000
Re: Performance views/tables in PostgreSQL? Jasen Betts <jasen@xnet.co.nz> - 2012-03-22 12:57 +0000
Re: Performance views/tables in PostgreSQL? Mladen Gogala <gogala.mladen@gmail.com> - 2012-03-23 05:04 +0000
csiph-web