Possible to find disk IOs for a Query?

Поиск
Список
Период
Сортировка
От Bobby Mozumder
Тема Possible to find disk IOs for a Query?
Дата
Msg-id EF9FCE30-FF02-41BE-A616-C099DF9DDE97@gmail.com
обсуждение исходный текст
Ответы 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>)
Список pgsql-performance
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: pgsql-performance issue
Следующее
От: Ben Chobot
Дата:
Сообщение: Re: Possible to find disk IOs for a Query?