explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P5MD

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.019 ↑ 1.0 10 1

Limit (cost=0.00..0.32 rows=10 width=29) (actual time=0.015..0.019 rows=10 loops=1)

  • Output: composer, milliseconds
  • Buffers: shared hit=1
2. 0.016 0.016 ↑ 252.5 10 1

Seq Scan on chinook.track (cost=0.00..80.03 rows=2,525 width=29) (actual time=0.013..0.016 rows=10 loops=1)

  • Output: composer, milliseconds
  • Filter: (track.composer IS NOT NULL)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1
Planning time : 0.347 ms
Execution time : 0.034 ms