explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8DWA

Settings
# exclusive inclusive rows x rows loops node
1. 26.146 80,138.409 ↓ 0.0 0 1

Delete on inventory_machinesnapshotcommit child (cost=2,079,706.41..4,522,314.54 rows=1 width=12) (actual time=80,138.409..80,138.409 rows=0 loops=1)

2. 24,154.193 80,112.263 ↓ 441.0 441 1

Hash Anti Join (cost=2,079,706.41..4,522,314.54 rows=1 width=12) (actual time=64,972.539..80,112.263 rows=441 loops=1)

  • Hash Cond: (child.id = inventory_machinesnapshotcommit.parent_id)
3. 18,171.360 18,171.360 ↑ 1.0 18,635,150 1

Index Scan using idx_2 on inventory_machinesnapshotcommit child (cost=0.56..847,171.13 rows=18,807,001 width=10) (actual time=22.300..18,171.360 rows=18,635,150 loops=1)

  • Index Cond: (created_at <= '2018-10-31 23:59:59.773886+00'::timestamp with time zone)
4. 21,280.796 37,786.710 ↑ 1.0 48,399,470 1

Hash (cost=1,238,351.04..1,238,351.04 rows=48,401,504 width=10) (actual time=37,786.710..37,786.710 rows=48,399,470 loops=1)

  • Buckets: 131,072 Batches: 1,024 Memory Usage: 3,053kB
5. 16,505.914 16,505.914 ↑ 1.0 48,401,504 1

Seq Scan on inventory_machinesnapshotcommit (cost=0.00..1,238,351.04 rows=48,401,504 width=10) (actual time=0.028..16,505.914 rows=48,401,504 loops=1)

Planning time : 0.784 ms
Execution time : 80,138.539 ms