explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1K57

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 27,384.773 ↓ 0.0 0 1

Insert on syn_observation_observed_item_id_ref (cost=373,228.03..373,609.44 rows=8,750 width=80) (actual time=27,384.772..27,384.773 rows=0 loops=1)

2. 96.668 27,384.769 ↓ 0.0 0 1

Hash Anti Join (cost=373,228.03..373,609.44 rows=8,750 width=80) (actual time=27,384.768..27,384.769 rows=0 loops=1)

  • Hash Cond: (("*VALUES*".column1 = b.alias) AND ("*VALUES*".column2 = b.value) AND ("*VALUES*".column3 = b.composite_key_id))
3. 15.996 15.996 ↑ 1.0 10,000 1

Values Scan on "*VALUES*" (cost=0.00..125.00 rows=10,000 width=68) (actual time=0.007..15.996 rows=10,000 loops=1)

4. 14,817.089 27,272.105 ↑ 1.0 10,129,256 1

Hash (cost=195,961.92..195,961.92 rows=10,129,492 width=35) (actual time=27,272.104..27,272.105 rows=10,129,256 loops=1)

  • Buckets: 16777216 Batches: 1 Memory Usage: 842947kB
5. 12,455.016 12,455.016 ↑ 1.0 10,129,256 1

Seq Scan on syn_observation_observed_item_id_ref b (cost=0.00..195,961.92 rows=10,129,492 width=35) (actual time=0.031..12,455.016 rows=10,129,256 loops=1)

Planning time : 21.880 ms
Execution time : 27,396.694 ms