explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MYRQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 6.414 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1,331.44..4,624.72 rows=1 width=8) (actual time=6.407..6.414 rows=0 loops=1)

  • Buffers: shared hit=4,261
2. 0.017 6.397 ↓ 0.0 0 1

Nested Loop (cost=1,330.88..3,822.96 rows=338 width=16) (actual time=6.389..6.397 rows=0 loops=1)

  • Buffers: shared hit=4,261
3. 0.021 6.380 ↓ 0.0 0 1

HashAggregate (cost=1,330.45..1,333.82 rows=337 width=8) (actual time=6.372..6.380 rows=0 loops=1)

  • Group Key: prop_1.node_id
  • Buffers: shared hit=4,261
4. 4.011 6.359 ↓ 0.0 0 1

Bitmap Heap Scan on alf_node_properties prop_1 (cost=20.02..1,329.61 rows=338 width=8) (actual time=6.351..6.359 rows=0 loops=1)

  • Recheck Cond: ((237 = qname_id) AND ((string_value)::text = 'Coverage-5000'::text))
  • Heap Blocks: exact=4,142
  • Buffers: shared hit=4,261
5. 2.348 2.348 ↓ 59.2 20,010 1

Bitmap Index Scan on idx_alf_nprop_s (cost=0.00..19.94 rows=338 width=0) (actual time=2.339..2.348 rows=20,010 loops=1)

  • Index Cond: ((237 = qname_id) AND ((string_value)::text = 'Coverage-5000'::text))
  • Buffers: shared hit=119
6. 0.000 0.000 ↓ 0.0 0

Index Only Scan using alf_node_pkey on alf_node node (cost=0.42..7.39 rows=1 width=8) (never executed)

  • Index Cond: (id = prop_1.node_id)
  • Heap Fetches: 0
7. 0.000 0.000 ↓ 0.0 0

Index Scan using alf_node_properties_pkey on alf_node_properties prop (cost=0.56..2.37 rows=1 width=8) (never executed)

  • Index Cond: ((node_id = node.id) AND (240 = qname_id))
  • Filter: ((string_value)::text = 'Contributor-5000'::text)
Planning time : 0.871 ms
Execution time : 6.645 ms