explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mRJB

Settings
# exclusive inclusive rows x rows loops node
1. 0.905 1.511 ↑ 1.0 2,525 1

Sort (cost=222.72..229.03 rows=2,525 width=29) (actual time=1.366..1.511 rows=2,525 loops=1)

  • Output: composer, milliseconds
  • Sort Key: track.milliseconds DESC
  • Sort Method: quicksort Memory: 304kB
  • Buffers: shared hit=48
  • Settings: search_path = 'chinook'
2. 0.606 0.606 ↑ 1.0 2,525 1

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

  • Output: composer, milliseconds
  • Filter: (track.composer IS NOT NULL)
  • Rows Removed by Filter: 978
  • Buffers: shared hit=45
Planning time : 0.616 ms
Execution time : 1.693 ms