explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vo8M

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 2,717.832 ↓ 0.0 0 1

Insert on syn_observation_observed_item_id_ref (cost=0.56..56,414.75 rows=5,954 width=80) (actual time=2,717.831..2,717.832 rows=0 loops=1)

2. 35.064 2,717.828 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.56..56,414.75 rows=5,954 width=80) (actual time=2,717.827..2,717.828 rows=0 loops=1)

3. 12.764 12.764 ↓ 1.5 10,000 1

Seq Scan on input (cost=0.00..152.04 rows=6,804 width=72) (actual time=0.013..12.764 rows=10,000 loops=1)

4. 2,670.000 2,670.000 ↑ 1.0 1 10,000

Index Only Scan using syn_observation_observed_item__value_alias_composite_key_id_idx on syn_observation_observed_item_id_ref sub (cost=0.56..8.27 rows=1 width=35) (actual time=0.267..0.267 rows=1 loops=10,000)

  • Index Cond: ((value = input.value) AND (alias = input.alias) AND (composite_key_id = input.composite_key_id))
  • Heap Fetches: 10000
Planning time : 0.295 ms
Execution time : 2,717.886 ms