explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iIcH

Settings
# exclusive inclusive rows x rows loops node
1. 134.704 797.956 ↓ 302.0 302 1

Nested Loop Semi Join (cost=1,331.43..4,624.56 rows=1 width=8) (actual time=167.955..797.956 rows=302 loops=1)

  • Buffers: shared hit=86,028
2. 207.639 533.200 ↓ 29.6 10,004 1

Nested Loop (cost=1,330.87..3,822.95 rows=338 width=16) (actual time=166.729..533.200 rows=10,004 loops=1)

  • Buffers: shared hit=35,852
3. 149.171 235.525 ↓ 29.7 10,004 1

HashAggregate (cost=1,330.44..1,333.81 rows=337 width=8) (actual time=166.687..235.525 rows=10,004 loops=1)

  • Group Key: prop_1.node_id
  • Buffers: shared hit=4,238
4. 84.531 86.354 ↓ 29.6 10,004 1

Bitmap Heap Scan on alf_node_properties prop_1 (cost=20.02..1,329.60 rows=338 width=8) (actual time=2.458..86.354 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
5. 1.823 1.823 ↓ 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.817..1.823 rows=10,006 loops=1)

  • Index Cond: ((237 = qname_id) AND ((string_value)::text = 'Coverage-5000'::text))
  • Buffers: shared hit=118
6. 90.036 90.036 ↑ 1.0 1 10,004

Index Only Scan using alf_node_pkey on alf_node node (cost=0.42..7.39 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=10,004)

  • Index Cond: (id = prop_1.node_id)
  • Heap Fetches: 1,567
  • Buffers: shared hit=31,614
7. 130.052 130.052 ↓ 0.0 0 10,004

Index Scan using alf_node_properties_pkey on alf_node_properties prop (cost=0.56..2.37 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=10,004)

  • Index Cond: ((node_id = node.id) AND (240 = qname_id))
  • Filter: ((string_value)::text = 'Contributor-5000'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=50,176
Planning time : 0.779 ms