Groups > comp.databases.postgresql > #325

Re: Performance views/tables in PostgreSQL?

Path	csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail
From	Mladen Gogala <gogala.mladen@gmail.com>
Newsgroups	comp.databases.postgresql
Subject	Re: Performance views/tables in PostgreSQL?
Date	Thu, 22 Mar 2012 13:16:15 +0000 (UTC)
Organization	solani.org
Lines	42
Message-ID	<pan.2012.03.22.13.16.15@gmail.com> (permalink)
References	<4f69f15e@news.x-privat.org>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	8bit
X-Trace	solani.org 1332422175 28447 eJwNw4ERwEAEBMCWwnMoJ3/ov4RkZ9YPBAyDw3x9xfmoE/iPjBSDWr2T8dZlxNSc3ci2m9b6AR4xEYE= (22 Mar 2012 13:16:15 GMT)
X-Complaints-To	abuse@news.solani.org
NNTP-Posting-Date	Thu, 22 Mar 2012 13:16:15 +0000 (UTC)
User-Agent	Pan/0.135 (Tomorrow I'll Wake Up and Scald Myself with Tea; GIT 30dc37b master)
X-User-ID	eJwFwQkBwDAIA0BNGQmlcniKfwm7kzm8D11OrTZkF1H9kClaDFZz9BHDqbXOWuycCNqthx8cxBFm
Cancel-Lock	sha1:n5wy2WczcbmNylcAubjJB5kLwSk=
X-NNTP-Posting-Host	eJwFwQkBwDAIA0BLfEmLHAbDv4TewansEwQDi7WRW9SERFIqrY56QFtXrvX057Sc/MHp8Xr+hhCY
Xref	csiph.com comp.databases.postgresql:325

Show key headers only | View raw

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

Thread

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