explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eAcm

Settings
# exclusive inclusive rows x rows loops node
1. 261.986 15,271.287 ↓ 3,642.0 3,642 1

Nested Loop Semi Join (cost=1,796.52..6,025.89 rows=1 width=8) (actual time=5,832.244..15,271.287 rows=3,642 loops=1)

  • Buffers: shared hit=88,589 read=50,258 written=10,451
2. 337.955 8,520.001 ↓ 31.9 14,550 1

Nested Loop (cost=1,795.96..4,953.43 rows=456 width=16) (actual time=5,825.992..8,520.001 rows=14,550 loops=1)

  • Buffers: shared hit=42,595 read=23,315 written=8,819
3. 236.086 5,941.346 ↓ 32.0 14,550 1

HashAggregate (cost=1,795.53..1,800.08 rows=455 width=8) (actual time=5,824.640..5,941.346 rows=14,550 loops=1)

  • Group Key: prop_1.node_id
  • Buffers: shared read=12,337 written=8,234
4. 5,584.488 5,705.260 ↓ 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=122.178..5,705.260 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 read=12,337 written=8,234
5. 120.772 120.772 ↓ 31.9 14,550 1

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

  • Index Cond: ((238 = qname_id) AND ((string_value)::text = 'Action and Adventure'::text))
  • Buffers: shared read=200
6. 2,240.700 2,240.700 ↑ 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.154..0.154 rows=1 loops=14,550)

  • Index Cond: (id = prop_1.node_id)
  • Heap Fetches: 9,882
  • Buffers: shared hit=42,595 read=10,978 written=585
7. 6,489.300 6,489.300 ↓ 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.446..0.446 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=45,994 read=26,943 written=1,632
Planning time : 18.606 ms
Execution time : 15,297.961 ms