Possible to find disk IOs for a Query?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux