explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2Qvn

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

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

  • Buffers: shared read=4,261 written=126
2. 0.017 27.484 ↓ 0.0 0 1

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

  • Buffers: shared read=4,261 written=126
3. 0.054 27.467 ↓ 0.0 0 1

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

  • Group Key: prop_1.node_id
  • Buffers: shared read=4,261 written=126
4. 22.229 27.413 ↓ 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=27.406..27.413 rows=0 loops=1)

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

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

  • Index Cond: ((237 = qname_id) AND ((string_value)::text = 'Coverage-5000'::text))
  • Buffers: shared read=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)