explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L73h

Settings
# exclusive inclusive rows x rows loops node
1. 250.120 767,393.029 ↓ 4.1 14,428 1

Sort (cost=1,054,213.14..1,054,221.97 rows=3,531 width=33) (actual time=767,388.594..767,393.029 rows=14,428 loops=1)

  • Sort Key: prop_0.string_value
  • Sort Method: quicksort Memory: 1785kB
2. 41.664 767,142.909 ↓ 4.1 14,428 1

Nested Loop Left Join (cost=6,534.21..1,054,005.07 rows=3,531 width=33) (actual time=502.439..767,142.909 rows=14,428 loops=1)

3. 33.525 12,863.117 ↓ 4.1 14,428 1

Nested Loop (cost=6,533.51..143,572.55 rows=3,531 width=8) (actual time=502.347..12,863.117 rows=14,428 loops=1)

4. 43.544 536.936 ↑ 1.1 14,428 1

HashAggregate (cost=6,532.95..6,698.32 rows=16,537 width=8) (actual time=502.266..536.936 rows=14,428 loops=1)

  • Group Key: parent.child_node_id
5. 493.392 493.392 ↑ 1.1 14,428 1

Index Only Scan using idx_alf_cass_pri on alf_child_assoc parent (cost=0.56..6,491.61 rows=16,537 width=8) (actual time=0.084..493.392 rows=14,428 loops=1)

  • Index Cond: (parent_node_id = '324428'::bigint)
  • Heap Fetches: 4521
6. 12,292.656 12,292.656 ↑ 1.0 1 14,428

Index Scan using alf_node_pkey on alf_node node (cost=0.56..8.27 rows=1 width=8) (actual time=0.790..0.852 rows=1 loops=14,428)

  • 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[])))
7. 754,238.128 754,238.128 ↑ 119.0 1 14,428

Index Scan using alf_node_properties_pkey on alf_node_properties prop_0 (cost=0.70..256.65 rows=119 width=33) (actual time=52.162..52.276 rows=1 loops=14,428)

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