Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala 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: 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 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$ 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