explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nBaV

Settings
# exclusive inclusive rows x rows loops node
1. 99.081 1,255,619.157 ↓ 6.8 14,518 1

Sort (cost=531,218.99..531,224.31 rows=2,129 width=32) (actual time=1,255,615.144..1,255,619.157 rows=14,518 loops=1)

  • Sort Key: prop_0.string_value
  • Sort Method: quicksort Memory: 1796kB
2. 14.767 1,255,520.076 ↓ 6.8 14,518 1

Gather (cost=5,404.31..531,101.30 rows=2,129 width=32) (actual time=133,667.455..1,255,520.076 rows=14,518 loops=1)

  • Workers Planned: 5
  • Workers Launched: 0
3. 933,844.333 1,255,505.309 ↓ 34.1 14,518 1

Nested Loop Left Join (cost=4,404.31..529,888.40 rows=426 width=32) (actual time=133,667.454..1,255,505.309 rows=14,518 loops=1)

4. 2,523.093 321,596.652 ↓ 34.1 14,518 1

Hash Semi Join (cost=4,403.61..426,409.40 rows=426 width=8) (actual time=133,667.369..321,596.652 rows=14,518 loops=1)

  • Hash Cond: (node.id = parent.child_node_id)
5. 185,406.504 185,406.504 ↓ 10.7 7,054,705 1

Parallel Seq Scan on alf_node node (cost=0.00..419,921.86 rows=660,011 width=8) (actual time=0.022..185,406.504 rows=7,054,705 loops=1)

  • 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[])))
  • Rows Removed by Filter: 8101705
6. 15.512 133,667.055 ↓ 1.5 14,518 1

Hash (cost=4,281.40..4,281.40 rows=9,777 width=8) (actual time=133,667.055..133,667.055 rows=14,518 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 696kB
7. 133,651.543 133,651.543 ↓ 1.5 14,518 1

Index Only Scan using idx_alf_cass_pri on alf_child_assoc parent (cost=0.56..4,281.40 rows=9,777 width=8) (actual time=1,583.089..133,651.543 rows=14,518 loops=1)

  • Index Cond: (parent_node_id = '324428'::bigint)
  • Heap Fetches: 4739
8. 64.324 64.324 ↑ 114.0 1 14,518

Index Scan using alf_node_properties_pkey on alf_node_properties prop_0 (cost=0.70..241.77 rows=114 width=32) (actual time=64.103..64.324 rows=1 loops=14,518)

  • Index Cond: ((node_id = node.id) AND ('26'::bigint = qname_id))