Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.postgresql > #326

Re: Performance views/tables in PostgreSQL?

From Jasen Betts <jasen@xnet.co.nz>
Newsgroups comp.databases.postgresql
Subject Re: Performance views/tables in PostgreSQL?
Date 2012-03-22 12:57 +0000
Organization Dis (not Dat) Organisation
Message-ID <jkf7kg$u20$1@reversiblemaps.ath.cx> (permalink)
References <4f69f15e@news.x-privat.org>

Show all headers | View raw


On 2012-03-21, Pol <eff.off.if.you.think.youre.getting.my.email@anon.com> wrote:

> I'm just wondering, what is the equivalent of the Oracle
> Wait Interface (i.e. the V$<View_Name> system) in PostgreSQL?

explain analyze is the most commonly used query performance metric.

I think there may be something else too.

-- 
⚂⚃ 100% natural

Back to comp.databases.postgresql | Previous | NextPrevious 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