explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3sD

Settings
# exclusive inclusive rows x rows loops node
1. 43.905 1,122,073.486 ↓ 6.1 14,519 1

Nested Loop (cost=5,024.30..100,751.27 rows=2,379 width=8) (actual time=134,969.791..1,122,073.486 rows=14,519 loops=1)

2. 56.881 134,998.923 ↓ 1.3 14,519 1

HashAggregate (cost=5,023.74..5,137.87 rows=11,413 width=8) (actual time=134,967.488..134,998.923 rows=14,519 loops=1)

  • Group Key: parent.child_node_id
3. 134,942.042 134,942.042 ↓ 1.3 14,519 1

Index Only Scan using idx_alf_cass_pri on alf_child_assoc parent (cost=0.56..4,995.21 rows=11,413 width=8) (actual time=310.418..134,942.042 rows=14,519 loops=1)

  • Index Cond: (parent_node_id = '324428'::bigint)
  • Heap Fetches: 4028
4. 987,030.658 987,030.658 ↑ 1.0 1 14,519

Index Scan using alf_node_pkey on alf_node node (cost=0.56..8.37 rows=1 width=8) (actual time=67.776..67.982 rows=1 loops=14,519)

  • 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[])))