explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C9iT

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=366,355.82..613,282.12 rows=718,776 width=233) (actual rows= loops=)

  • Hash Cond: (childnode.store_id = childstore.id)
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=366,354.68..603,397.81 rows=718,776 width=219) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..5.59 rows=1 width=75) (actual rows= loops=)

  • Join Filter: (parentnode.store_id = parentstore.id)
4. 0.000 0.000 ↓ 0.0

Index Scan using alf_node_pkey1 on alf_node parentnode (cost=0.43..4.45 rows=1 width=61) (actual rows= loops=)

  • Index Cond: (id = '84186'::bigint)
5. 0.000 0.000 ↓ 0.0

Seq Scan on alf_store parentstore (cost=0.00..1.06 rows=6 width=30) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=366,354.25..596,204.47 rows=718,776 width=152) (actual rows= loops=)

  • Hash Cond: (assoc.child_node_id = childnode.id)
7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on alf_child_assoc assoc (cost=17,865.07..149,441.77 rows=718,776 width=99) (actual rows= loops=)

  • Recheck Cond: (parent_node_id = '84186'::bigint)
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_alf_cass_pri (cost=0.00..17,685.38 rows=718,776 width=0) (actual rows= loops=)

  • Index Cond: (parent_node_id = '84186'::bigint)
9. 0.000 0.000 ↓ 0.0

Hash (cost=215,564.19..215,564.19 rows=5,719,119 width=61) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on alf_node childnode (cost=0.00..215,564.19 rows=5,719,119 width=61) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=1.06..1.06 rows=6 width=30) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on alf_store childstore (cost=0.00..1.06 rows=6 width=30) (actual rows= loops=)