pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mitch Vincent <mitch@venux.net>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: More full text index..
Date: Sat, 24 Jun 2000 22:19:25 -0400
Message-ID: <22064.961899565@sss.pgh.pa.us> (raw)
In-Reply-To: <001d01bfde1d$a411a1a0$0300000a@doot.org>
References: <200006241833.OAA27704@candle.pha.pa.us>
	<001d01bfde1d$a411a1a0$0300000a@doot.org>

"Mitch Vincent" <mitch@venux.net> writes:
> EXPLAIN on a delete isn't very interesting..
> databasename=# explain delete from applicants_resumes where app_id=62908;
> NOTICE:  QUERY PLAN:

> Index Scan using app_resume_app_id_index on applicants_resumes
> (cost=0.00..3.70 rows=1 width=6)

I believe that doesn't tell you anything about triggers that might be
triggered during execution of the statement.  I think you are right that
the deletes issued by the trigger are the problem...

> Now this :

> query: delete from resumes_fti where id=86370016;
> ProcessQuery
> ! system usage stats:
> !       94.297058 elapsed 66.381692 user 24.776035 system sec
> !       [66.399740 user 24.785696 sys total]
> !       10926/8 [10926/8] filesystem blocks in/out
> !       0/30789 [0/31005] page faults/reclaims, 0 [0] swaps
> !       0 [0] signals rcvd, 0/0 [3/3] messages rcvd/sent
> !       186/1493 [189/1496] voluntary/involuntary context switches
> ! postgres usage stats:
> !       Shared blocks:      45945 read,         32 written, buffer hit rate
> = 3.24%
> !       Local  blocks:          0 read,          0 written, buffer hit rate
> = 0.00%
> !       Direct blocks:          0 read,          0 written

> Most of that is greek to me -- speaking of which, is there any place where
> these stats are explained a bit?

For the "system usage" stats, see man getrusage(2).  I think the other
thing you need to know is that the numbers in square brackets are total
getrusage for the current backend, the numbers before brackets are the
incremental usage for the current command.  These do count absolutely
everything including trigger activity.

The "postgres usage" stats are just I/O block request counts for the
shared and transaction-local buffer caches respectively ... but I forget
whether they are kernel I/O requests or logical I/O requests, ie which
side of the buffer cache they are counted on.

			regards, tom lane



view thread (5+ messages)

Message-ID: <22064.961899565@sss.pgh.pa.us>
Permalink:  ../22064.961899565@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/22064.961899565@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, mitch@venux.net, pgman@candle.pha.pa.us
  Subject: Re: More full text index..
  In-Reply-To: <22064.961899565@sss.pgh.pa.us>
  References: <200006241833.OAA27704@candle.pha.pa.us> <001d01bfde1d$a411a1a0$0300000a@doot.org> <22064.961899565@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox