explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mcvV

Settings
# exclusive inclusive rows x rows loops node
1. 8.075 61,356.422 ↓ 0.0 0 1

Delete on inventory_machinesnapshotcommit child (cost=188.49..4,617,691.36 rows=1 width=12) (actual time=61,356.422..61,356.422 rows=0 loops=1)

2. 12,645.611 61,348.347 ↓ 461.0 461 1

Merge Anti Join (cost=188.49..4,617,691.36 rows=1 width=12) (actual time=956.925..61,348.347 rows=461 loops=1)

  • Merge Cond: (child.id = inventory_machinesnapshotcommit.parent_id)
3. 26,574.488 26,574.488 ↑ 1.0 20,461,763 1

Index Scan using inventory_machinesnapshotcommit_pkey on inventory_machinesnapshotcommit child (cost=0.56..2,179,298.05 rows=20,720,940 width=10) (actual time=0.017..26,574.488 rows=20,461,763 loops=1)

  • Filter: (created_at <= '2018-11-30 23:59:59.773886+00'::timestamp with time zone)
  • Rows Removed by Filter: 27939741
4. 22,128.248 22,128.248 ↑ 2.4 20,461,309 1

Index Scan using inventory_machinesnapshotcommit_6be37982 on inventory_machinesnapshotcommit (cost=0.56..2,058,377.80 rows=48,401,504 width=10) (actual time=0.009..22,128.248 rows=20,461,309 loops=1)

Planning time : 0.710 ms
Execution time : 61,356.571 ms