explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X2Js2

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.011 ↓ 0.0 0 1

Nested Loop Left Join (cost=349,111.91..371,315.24 rows=214 width=219) (actual time=0.010..0.011 rows=0 loops=1)

  • Filter: ((c.* IS NULL) OR (yo.composite_key_id <> c.composite_key_id))
2. 0.003 0.008 ↓ 0.0 0 1

Hash Join (cost=349,110.92..371,078.11 rows=214 width=115) (actual time=0.007..0.008 rows=0 loops=1)

  • Hash Cond: ((yo.key = a.alias) AND (yo.val = a.value))
3. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on composite_key_components yo (cost=0.00..18.10 rows=810 width=72) (actual time=0.004..0.005 rows=0 loops=1)

4. 0.000 0.000 ↓ 0.0 0

Hash (cost=196,723.57..196,723.57 rows=10,159,157 width=43) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Seq Scan on syn_observation_observed_item_id_ref a (cost=0.00..196,723.57 rows=10,159,157 width=43) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.10 rows=1 width=160) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Index Scan using nk_mapping_syn_observation_unq_idx on nk_mapping_syn_observation b (cost=0.56..0.65 rows=1 width=72) (never executed)

  • Index Cond: (a.composite_key_id = composite_key_id)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using nk_mapping_syn_compound_pkey on nk_mapping_syn_compound c (cost=0.43..0.45 rows=1 width=88) (never executed)

  • Index Cond: (id = b.observed_item_id_mapping_id)