explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x8eMM

Settings
# exclusive inclusive rows x rows loops node
1. 83.289 84.733 ↓ 29.6 10,004 1

Bitmap Heap Scan on alf_node_properties prop (cost=20.02..1,329.60 rows=338 width=8) (actual time=2.114..84.733 rows=10,004 loops=1)

  • Recheck Cond: ((237 = qname_id) AND ((string_value)::text = 'Coverage-5000'::text))
  • Heap Blocks: exact=4,120
  • Buffers: shared hit=4,238
2. 1.444 1.444 ↓ 29.6 10,006 1

Bitmap Index Scan on idx_alf_nprop_s (cost=0.00..19.94 rows=338 width=0) (actual time=1.438..1.444 rows=10,006 loops=1)

  • Index Cond: ((237 = qname_id) AND ((string_value)::text = 'Coverage-5000'::text))
  • Buffers: shared hit=118
Planning time : 0.138 ms
Execution time : 157.200 ms