Possible to find disk IOs for a Query?

From: Bobby Mozumder <bmozumder(at)gmail(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Possible to find disk IOs for a Query?
Date: 2016-08-31 22:01:19
Message-ID: EF9FCE30-FF02-41BE-A616-C099DF9DDE97@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Is it possible to find the number of disk IOs performed for a query? EXPLAIN ANALYZE looks like it shows number of sequential rows scanned, but not number of IOs.

My database is on an NVMe SSD, and am trying to cut microseconds of disk IO per query by possibly denormalizing.

Thank you,

-bobby

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ben Chobot 2016-08-31 22:10:10 Re: Possible to find disk IOs for a Query?
Previous Message Andres Freund 2016-08-29 20:14:03 Re: pgsql-performance issue