Interpreting statistics collector output

From: Steve Madsen <steve(at)lightyearsoftware(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Interpreting statistics collector output
Date: 2007-08-08 15:01:13
Message-ID: 35B78CC2-E529-4C24-AF98-2D3D4D08B535@lightyearsoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can anyone provide a brief overview of how to go about interpreting
the information generated by the statistics collector? I've looked
around and can't find old mailing list messages or anything in the
manual beyond the basics of how to query the statistics.

Cache hit rates are easy to compute, but is this useful beyond
knowing if Postgres has enough buffers?

Can anything useful be gleaned from looking at idx_scan /
idx_tup_read / idx_tup_fetch?

--
Steve Madsen <steve(at)lightyearsoftware(dot)com>
Light Year Software, LLC http://lightyearsoftware.com
ZingLists: Stay organized, and share lists online. http://zinglists.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Reyes 2007-08-08 15:19:37 Re: Dealing with tsvector in fuctions for data split
Previous Message Leif B. Kristensen 2007-08-08 13:28:08 Re: Modified FIFO queue and insert rule