explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WtJs : Optimization for: Optimization for: Optimization for: Optimization for: plan #g3ZrB; plan #Q7Oa; plan #FrV3; plan #cdqsn

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 0.032 ↓ 0.0 0 1

Delete on audit_evs_all aea (cost=0.67..68.83 rows=3 width=38) (actual time=0.029..0.032 rows=0 loops=1)

  • Delete on audit_evs_all_20200724 aea_1
  • Delete on audit_evs_all_20200725 aea_2
  • Delete on audit_evs_all_default aea_3
2. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=0.67..22.94 rows=1 width=38) (actual time=0.009..0.010 rows=0 loops=1)

  • Join Filter: (aea_1.audit_ev_id = aea2.audit_ev_id)
3. 0.009 0.009 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200724_pkey on audit_evs_all_20200724 aea_1 (cost=0.12..3.14 rows=1 width=14) (actual time=0.008..0.009 rows=0 loops=1)

  • Index Cond: (when_created <= '2020-07-25 12:15:21.635-07'::timestamp with time zone)
4. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2 (cost=0.54..19.79 rows=1 width=40) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.54..19.78 rows=1 width=8) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.54..19.78 rows=1 width=8) (never executed)

  • Filter: (((aea_4.ev_id IS NOT NULL) AND (evs.ev_id IS NULL)) OR (aea_4.ev_id IS NULL))
7. 0.000 0.000 ↓ 0.0 0

Append (cost=0.12..9.44 rows=3 width=16) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Index Scan using audit_evs_all_20200724_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200724 aea_4 (cost=0.12..3.14 rows=1 width=16) (never executed)

  • Filter: (when_created <= '2020-07-25 12:15:21.635-07'::timestamp with time zone)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using audit_evs_all_20200725_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200725 aea_5 (cost=0.12..3.14 rows=1 width=16) (never executed)

  • Filter: (when_created <= '2020-07-25 12:15:21.635-07'::timestamp with time zone)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using audit_evs_all_default_ev_id_person_id_delivery_status_order_idx on audit_evs_all_default aea_6 (cost=0.12..3.14 rows=1 width=16) (never executed)

  • Filter: (when_created <= '2020-07-25 12:15:21.635-07'::timestamp with time zone)
11. 0.000 0.000 ↓ 0.0 0

Index Only Scan using evs_ev_id_message_panel_id_idx on evs (cost=0.42..3.44 rows=1 width=8) (never executed)

  • Index Cond: (ev_id = aea_4.ev_id)
  • Heap Fetches: 0
12. 0.001 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.67..22.94 rows=1 width=38) (actual time=0.007..0.008 rows=0 loops=1)

  • Join Filter: (aea_2.audit_ev_id = aea2_1.audit_ev_id)
13. 0.007 0.007 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200725_pkey on audit_evs_all_20200725 aea_2 (cost=0.12..3.14 rows=1 width=14) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (when_created <= '2020-07-25 12:15:21.635-07'::timestamp with time zone)
14. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_1 (cost=0.54..19.79 rows=1 width=40) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.54..19.78 rows=1 width=8) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.54..19.78 rows=1 width=8) (never executed)

  • Filter: (((aea_7.ev_id IS NOT NULL) AND (evs_1.ev_id IS NULL)) OR (aea_7.ev_id IS NULL))
17. 0.000 0.000 ↓ 0.0 0

Append (cost=0.12..9.44 rows=3 width=16) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Index Scan using audit_evs_all_20200724_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200724 aea_7 (cost=0.12..3.14 rows=1 width=16) (never executed)

  • Filter: (when_created <= '2020-07-25 12:15:21.635-07'::timestamp with time zone)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using audit_evs_all_20200725_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200725 aea_8 (cost=0.12..3.14 rows=1 width=16) (never executed)

  • Filter: (when_created <= '2020-07-25 12:15:21.635-07'::timestamp with time zone)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using audit_evs_all_default_ev_id_person_id_delivery_status_order_idx on audit_evs_all_default aea_9 (cost=0.12..3.14 rows=1 width=16) (never executed)

  • Filter: (when_created <= '2020-07-25 12:15:21.635-07'::timestamp with time zone)
21. 0.000 0.000 ↓ 0.0 0

Index Only Scan using evs_ev_id_message_panel_id_idx on evs evs_1 (cost=0.42..3.44 rows=1 width=8) (never executed)

  • Index Cond: (ev_id = aea_7.ev_id)
  • Heap Fetches: 0
22. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=0.67..22.94 rows=1 width=38) (actual time=0.009..0.010 rows=0 loops=1)

  • Join Filter: (aea_3.audit_ev_id = aea2_2.audit_ev_id)
23. 0.009 0.009 ↓ 0.0 0 1

Index Scan using audit_evs_all_default_pkey on audit_evs_all_default aea_3 (cost=0.12..3.14 rows=1 width=14) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (when_created <= '2020-07-25 12:15:21.635-07'::timestamp with time zone)
24. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_2 (cost=0.54..19.79 rows=1 width=40) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.54..19.78 rows=1 width=8) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.54..19.78 rows=1 width=8) (never executed)

  • Filter: (((aea_10.ev_id IS NOT NULL) AND (evs_2.ev_id IS NULL)) OR (aea_10.ev_id IS NULL))
27. 0.000 0.000 ↓ 0.0 0

Append (cost=0.12..9.44 rows=3 width=16) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Index Scan using audit_evs_all_20200724_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200724 aea_10 (cost=0.12..3.14 rows=1 width=16) (never executed)

  • Filter: (when_created <= '2020-07-25 12:15:21.635-07'::timestamp with time zone)
29. 0.000 0.000 ↓ 0.0 0

Index Scan using audit_evs_all_20200725_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200725 aea_11 (cost=0.12..3.14 rows=1 width=16) (never executed)

  • Filter: (when_created <= '2020-07-25 12:15:21.635-07'::timestamp with time zone)
30. 0.000 0.000 ↓ 0.0 0

Index Scan using audit_evs_all_default_ev_id_person_id_delivery_status_order_idx on audit_evs_all_default aea_12 (cost=0.12..3.14 rows=1 width=16) (never executed)

  • Filter: (when_created <= '2020-07-25 12:15:21.635-07'::timestamp with time zone)
31. 0.000 0.000 ↓ 0.0 0

Index Only Scan using evs_ev_id_message_panel_id_idx on evs evs_2 (cost=0.42..3.44 rows=1 width=8) (never executed)

  • Index Cond: (ev_id = aea_10.ev_id)
  • Heap Fetches: 0
Planning time : 1,118.001 ms
Execution time : 1.057 ms