explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YpckY

Settings
# exclusive inclusive rows x rows loops node
1. 265,817.782 265,817.782 ↑ 1.2 54,553,038 1

Seq Scan on streaming_file (cost=0.00..3,789,485.24 rows=62,913,724 width=697) (actual time=0.529..265,817.782 rows=54,553,038 loops=1)

  • Buffers: shared hit=1341035 read=1819313 dirtied=53
  • I/O Timings: read=144605.606
Planning time : 3.113 ms
Execution time : 278,077.499 ms