explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0mcW

Settings
# exclusive inclusive rows x rows loops node
1. 446,958.345 482,594.337 ↓ 0.0 0 1

Update on stored_objects so (cost=13.31..3,354,149.28 rows=13,381,424 width=614) (actual time=482,594.337..482,594.337 rows=0 loops=1)

2. 3,980.557 35,635.992 ↑ 1.0 12,801,351 1

Hash Anti Join (cost=13.31..3,354,149.28 rows=13,381,424 width=614) (actual time=1.200..35,635.992 rows=12,801,351 loops=1)

  • Hash Cond: ((so.cid = rt.cid) AND (so.reference_id = rt.id))
3. 31,655.430 31,655.430 ↑ 1.0 12,801,351 1

Index Scan using idx_stored_objects_reftable_not_deleted on stored_objects so (cost=0.56..3,083,162.50 rows=13,381,450 width=584) (actual time=1.187..31,655.430 rows=12,801,351 loops=1)

  • Index Cond: ((reference_table)::text = 'public.integration_results'::text)
  • Filter: (deleted_on IS NULL)
4. 0.002 0.005 ↓ 0.0 0 1

Hash (cost=11.10..11.10 rows=110 width=14) (actual time=0.004..0.005 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
5. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on integration_results rt (cost=0.00..11.10 rows=110 width=14) (actual time=0.003..0.003 rows=0 loops=1)

Planning time : 0.214 ms
Execution time : 482,594.385 ms