On 01/09/16 10:01, Bobby Mozumder wrote:
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 b
On Wed, Aug 31, 2016 at 3:01 PM, Bobby Mozumder wrote:
> 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 d
On Aug 31, 2016, at 3:01 PM, Bobby Mozumder wrote:
>
> 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.
Postgres knows the number of rows it will need to pull to do your que
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,
-bo
