To answer my own question, never mind...just read Tom's writeup on how
to get the db-specific profile:
http://fts.postgresql.org/db/mw/msg.html?mid=32379
-Kyle, off to read more online docs
Kyle wrote:
> When I profile the postmaster do the forked backends also show up in
> the profile? Or do I need to profile those separately? (and how?)
>
>
>
>
> Tom Lane wrote:
> > Kyle <kaf@nwlink.com> writes:
> > > I'm getting poor performance on 7.1 as compared to 7.0.
> >
> > Hm. I don't know why 7.1 might be slower for plain SELECTs (the WAL
> > changes would certainly not affect that). Could you compile 7.1 for
> > profiling ("make clean; make PROFILE=-pg all" in the src/backend
> > subdirectory should do it) and send along a gprof table for your
> > test run?
> >
> > > I've got a btree index on the first 16 of the data elements, and
> > > explain verifies that the index is used.
> >
> > Simple explain doesn't prove that the index is being fully used ---
> > the display doesn't distinguish how many index columns are actually
> > being looked at. EXPLAIN VERBOSE output would resolve that doubt.
> >
> > regards, tom lane
> >
