explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pgns : sfe

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=2,528.75..2,528.80 rows=20 width=9) (actual rows= loops=)

  • (actual time=4.548..4.558 rows=20 loops=1)
  • Buffers: shared hit=1000 read=6
2. 0.000 0.000 ↓ 0.0

Sort (cost=2,528.75..2,531.05 rows=919 width=9) (actual rows= loops=)

  • (actual time=4.545..4.549 rows=20 loops=1)
  • Sort Key: sort
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=1000 read=6
  • -> Bitmap Heap Scan on skewed
  • (cost=19.91..2504.30 rows=919 width=9)
  • (actual time=0.685..4.108 rows=950 loops=1)
  • Recheck Cond: (category = 42)
  • Filter: interesting
  • Rows Removed by Filter: 50
  • Heap Blocks: exact=1000
  • Buffers: shared hit=1000 read=6
  • -> Bitmap Index Scan on skewed_category_idx
  • (cost=0.00..19.68 rows=967 width=0)
  • (actual time=0.368..0.368 rows=1000 loops=1)
  • Index Cond: (category = 42)
  • Buffers: shared read=6
Planning time : 0.371 ms
Execution time : 4.625 ms