Interpreting statistics collector output - Mailing list pgsql-general

From Steve Madsen
Subject Interpreting statistics collector output
Date
Msg-id 35B78CC2-E529-4C24-AF98-2D3D4D08B535@lightyearsoftware.com
Whole thread Raw
Responses Re: Interpreting statistics collector output  (Decibel! <decibel@decibel.org>)
List 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@lightyearsoftware.com>
Light Year Software, LLC  http://lightyearsoftware.com
ZingLists: Stay organized, and share lists online.  http://zinglists.com



pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Dealing with tsvector in fuctions for data split
Next
From: "Jasbinder Singh Bali"
Date:
Subject: Automation using postgres