explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hoFR

Settings
# exclusive inclusive rows x rows loops node
1. 120.954 4,904.883 ↑ 915.5 575 1

Hash Left Join (cost=10,000,054,384.08..10,000,833,958.92 rows=526,419 width=16) (actual time=3,447.710..4,904.883 rows=575 loops=1)

  • Hash Cond: (b.observed_item_id_mapping_id = c.id)
  • Filter: ((c.* IS NULL) OR (yo.composite_key_id <> c.composite_key_id))
  • Rows Removed by Filter: 79435
2. 349.653 1,355.730 ↑ 6.6 80,010 1

Nested Loop Left Join (cost=10,000,000,000.56..10,000,778,193.55 rows=526,419 width=16) (actual time=0.043..1,355.730 rows=80,010 loops=1)

3. 213.736 446.007 ↑ 6.6 80,010 1

Nested Loop (cost=10,000,000,000.00..10,000,432,652.00 rows=526,419 width=16) (actual time=0.026..446.007 rows=80,010 loops=1)

4. 12.271 12.271 ↑ 1.0 10,000 1

Seq Scan on composite_key_components yo (cost=10,000,000,000.00..10,000,000,184.00 rows=10,000 width=35) (actual time=0.011..12.271 rows=10,000 loops=1)

5. 220.000 220.000 ↑ 6.6 8 10,000

Index Scan using syn_observation_observed_item_id_ref_value_idx on syn_observation_observed_item_id_ref a (cost=0.00..42.72 rows=53 width=35) (actual time=0.004..0.022 rows=8 loops=10,000)

  • Index Cond: (value = yo.val)
  • Rows Removed by Index Recheck: 0
  • Filter: (yo.key = alias)
6. 560.070 560.070 ↑ 1.0 1 80,010

Index Only Scan using nk_mapping_syn_observation_unq_idx on nk_mapping_syn_observation b (cost=0.56..0.65 rows=1 width=16) (actual time=0.005..0.007 rows=1 loops=80,010)

  • Index Cond: (composite_key_id = a.composite_key_id)
  • Heap Fetches: 80010
7. 1,678.138 3,428.199 ↑ 1.0 1,212,513 1

Hash (cost=39,227.11..39,227.11 rows=1,212,513 width=72) (actual time=3,428.198..3,428.199 rows=1,212,513 loops=1)

  • Buckets: 2097152 Batches: 1 Memory Usage: 126505kB
8. 1,750.061 1,750.061 ↑ 1.0 1,212,513 1

Index Scan using nk_mapping_syn_compound_pkey on nk_mapping_syn_compound c (cost=0.43..39,227.11 rows=1,212,513 width=72) (actual time=0.017..1,750.061 rows=1,212,513 loops=1)

Planning time : 0.634 ms
Execution time : 4,906.159 ms