Postgres Pro
Downloads
Home   >   mailing lists

Possible to find disk IOs for a Query? - Mailing list pgsql-performance

From Bobby Mozumder
Subject Possible to find disk IOs for a Query?
Date
Msg-id EF9FCE30-FF02-41BE-A616-C099DF9DDE97@gmail.com
Whole thread Raw
Responses Re: Possible to find disk IOs for a Query?  (Ben Chobot <bench@silentmedia.com>)
Re: Possible to find disk IOs for a Query?  (Lukas Fittl <lukas@fittl.com>)
Re: Possible to find disk IOs for a Query?  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-performance
Tree view 
Is it possible to find the number of disk IOs performed for a query?  EXPLAIN ANALYZE looks like it shows number of
sequentialrows 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

pgsql-performance by date:

Previous
From: Andres Freund
Date:
Subject: Re: pgsql-performance issue
Next
From: Ben Chobot
Date:
Subject: Re: Possible to find disk IOs for a Query?