explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1tXA

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 990.051 ↓ 31.9 14,550 1

Nested Loop (cost=1,795.96..4,953.43 rows=456 width=16) (actual time=315.606..990.051 rows=14,550 loops=1)

  • Buffers: shared hit=46,876 read=19,034
2. 235.785 430.339 ↓ 32.0 14,550 1

HashAggregate (cost=1,795.53..1,800.08 rows=455 width=8) (actual time=315.554..430.339 rows=14,550 loops=1)

  • Group Key: prop_1.node_id
  • Buffers: shared hit=2,924 read=9,413
3. 191.731 194.554 ↓ 31.9 14,550 1

Bitmap Heap Scan on alf_node_properties prop_1 (cost=29.23..1,794.39 rows=456 width=8) (actual time=4.293..194.554 rows=14,550 loops=1)

  • Recheck Cond: ((238 = qname_id) AND ((string_value)::text = 'Action and Adventure'::text))
  • Heap Blocks: exact=12,137
  • Buffers: shared hit=2,924 read=9,413
4. 2.823 2.823 ↓ 31.9 14,550 1

Bitmap Index Scan on idx_alf_nprop_s (cost=0.00..29.12 rows=456 width=0) (actual time=2.817..2.823 rows=14,550 loops=1)

  • Index Cond: ((238 = qname_id) AND ((string_value)::text = 'Action and Adventure'::text))
  • Buffers: shared read=200
5. 232.800 232.800 ↑ 1.0 1 14,550

Index Only Scan using alf_node_pkey on alf_node node (cost=0.42..6.93 rows=1 width=8) (actual time=0.016..0.016 rows=1 loops=14,550)

  • Index Cond: (id = prop_1.node_id)
  • Heap Fetches: 9,882
  • Buffers: shared hit=43,952 read=9,621
6. 334.650 334.650 ↓ 0.0 0 14,550

Index Scan using alf_node_properties_pkey on alf_node_properties prop (cost=0.56..2.35 rows=1 width=8) (actual time=0.023..0.023 rows=0 loops=14,550)

  • Index Cond: ((node_id = node.id) AND (239 = qname_id))
  • Filter: ((string_value)::text = 'Hachette Livre'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=48,211 read=24,726
Planning time : 14.289 ms
Execution time : 1,604.584 ms