explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dq9

Settings
# exclusive inclusive rows x rows loops node
1. 49.195 913,871.649 ↓ 6.1 14,532 1

Nested Loop (cost=5,038.70..100,800.14 rows=2,380 width=8) (actual time=74,108.216..913,871.649 rows=14,532 loops=1)

2. 58.401 74,061.770 ↓ 1.3 14,532 1

HashAggregate (cost=5,038.14..5,152.31 rows=11,417 width=8) (actual time=74,025.997..74,061.770 rows=14,532 loops=1)

  • Group Key: parent.child_node_id
3. 74,003.369 74,003.369 ↓ 1.3 14,532 1

Index Only Scan using idx_alf_cass_pri on alf_child_assoc parent (cost=0.56..5,009.60 rows=11,417 width=8) (actual time=0.960..74,003.369 rows=14,532 loops=1)

  • Index Cond: (parent_node_id = '324428'::bigint)
  • Heap Fetches: 2987
4. 839,760.684 839,760.684 ↑ 1.0 1 14,532

Index Scan using alf_node_pkey on alf_node node (cost=0.56..8.37 rows=1 width=8) (actual time=57.608..57.787 rows=1 loops=14,532)

  • Index Cond: (id = parent.child_node_id)
  • Filter: ((type_qname_id <> '149'::bigint) AND (store_id = '6'::bigint) AND (type_qname_id = ANY ('{255,213,206,51,244,199,391,200,104,351,352,627}'::bigint[])))