explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N4US

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Delete on audit_evs_all aea (cost=1.10..242,991.26 rows=8,424 width=38) (actual rows= loops=)

  • Delete on audit_evs_all_20200809 aea_1
  • Delete on audit_evs_all_20200810 aea_2
  • Delete on audit_evs_all_20200811 aea_3
  • Delete on audit_evs_all_20200812 aea_4
  • Delete on audit_evs_all_20200813 aea_5
  • Delete on audit_evs_all_20200814 aea_6
  • Delete on audit_evs_all_20200815 aea_7
  • Delete on audit_evs_all_20200816 aea_8
  • Delete on audit_evs_all_20200817 aea_9
  • Delete on audit_evs_all_20200818 aea_10
  • Delete on audit_evs_all_20200819 aea_11
  • Delete on audit_evs_all_20200820 aea_12
  • Delete on audit_evs_all_20200821 aea_13
  • Delete on audit_evs_all_20200822 aea_14
  • Delete on audit_evs_all_20200823 aea_15
  • Delete on audit_evs_all_20200824 aea_16
  • Delete on audit_evs_all_20200825 aea_17
  • Delete on audit_evs_all_20200826 aea_18
  • Delete on audit_evs_all_20200827 aea_19
  • Delete on audit_evs_all_20200828 aea_20
  • Delete on audit_evs_all_20200829 aea_21
  • Delete on audit_evs_all_20200830 aea_22
  • Delete on audit_evs_all_20200831 aea_23
  • Delete on audit_evs_all_20200901 aea_24
  • Delete on audit_evs_all_20200902 aea_25
  • Delete on audit_evs_all_20200903 aea_26
  • Delete on audit_evs_all_20200904 aea_27
  • Delete on audit_evs_all_20200905 aea_28
  • Delete on audit_evs_all_20200906 aea_29
  • Delete on audit_evs_all_20200907 aea_30
  • Delete on audit_evs_all_20200908 aea_31
  • Delete on audit_evs_all_20200909 aea_32
  • Delete on audit_evs_all_20200910 aea_33
  • Delete on audit_evs_all_20200911 aea_34
  • Delete on audit_evs_all_20200912 aea_35
  • Delete on audit_evs_all_20200913 aea_36
  • Delete on audit_evs_all_20200914 aea_37
  • Delete on audit_evs_all_20200915 aea_38
  • Delete on audit_evs_all_20200916 aea_39
  • Delete on audit_evs_all_default aea_40
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.10..5,956.50 rows=2 width=38) (actual rows= loops=)

  • Join Filter: (aea_1.audit_ev_id = aea2.audit_ev_id)
3. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_pkey on audit_evs_all_20200809 aea_1 (cost=0.12..3.14 rows=1 width=14) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs.ev_id = aea_41.ev_id)
  • Filter: (((aea_41.ev_id IS NOT NULL) AND (evs.ev_id IS NULL)) OR (aea_41.ev_id IS NULL))
7. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_41.ev_id
10. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_41 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

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

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_42 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

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

Hash Join (cost=102.85..6,055.61 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_1.audit_ev_id = aea_2.audit_ev_id)
13. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_1 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_1.ev_id = aea_43.ev_id)
  • Filter: (((aea_43.ev_id IS NOT NULL) AND (evs_1.ev_id IS NULL)) OR (aea_43.ev_id IS NULL))
16. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_1 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_43.ev_id
19. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_43 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

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

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_44 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

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

Hash (cost=78.61..78.61 rows=1,861 width=14) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200810 aea_2 (cost=0.00..78.61 rows=1,861 width=14) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Hash Join (cost=187.60..6,140.36 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_2.audit_ev_id = aea_3.audit_ev_id)
24. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_2 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_2.ev_id = aea_45.ev_id)
  • Filter: (((aea_45.ev_id IS NOT NULL) AND (evs_2.ev_id IS NULL)) OR (aea_45.ev_id IS NULL))
27. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_2 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_45.ev_id
30. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_45 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

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

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_46 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
32. 0.000 0.000 ↓ 0.0

Hash (cost=140.72..140.72 rows=3,672 width=14) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200811 aea_3 (cost=0.00..140.72 rows=3,672 width=14) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Hash Join (cost=260.20..6,212.96 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_3.audit_ev_id = aea_4.audit_ev_id)
35. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_3 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_3.ev_id = aea_47.ev_id)
  • Filter: (((aea_47.ev_id IS NOT NULL) AND (evs_3.ev_id IS NULL)) OR (aea_47.ev_id IS NULL))
38. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_3 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_47.ev_id
41. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_47 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
42. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_48 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
43. 0.000 0.000 ↓ 0.0

Hash (cost=201.32..201.32 rows=4,632 width=14) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200812 aea_4 (cost=0.00..201.32 rows=4,632 width=14) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Hash Join (cost=186.95..6,139.71 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_4.audit_ev_id = aea_5.audit_ev_id)
46. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_4 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_4.ev_id = aea_49.ev_id)
  • Filter: (((aea_49.ev_id IS NOT NULL) AND (evs_4.ev_id IS NULL)) OR (aea_49.ev_id IS NULL))
49. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_4 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_49.ev_id
52. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_49 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
53. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_50 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
54. 0.000 0.000 ↓ 0.0

Hash (cost=140.43..140.43 rows=3,643 width=14) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200813 aea_5 (cost=0.00..140.43 rows=3,643 width=14) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Hash Join (cost=257.06..6,209.82 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_5.audit_ev_id = aea_6.audit_ev_id)
57. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_5 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_5.ev_id = aea_51.ev_id)
  • Filter: (((aea_51.ev_id IS NOT NULL) AND (evs_5.ev_id IS NULL)) OR (aea_51.ev_id IS NULL))
60. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_5 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_51.ev_id
63. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_51 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
64. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_52 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
65. 0.000 0.000 ↓ 0.0

Hash (cost=199.37..199.37 rows=4,537 width=14) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200814 aea_6 (cost=0.00..199.37 rows=4,537 width=14) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Hash Join (cost=75.64..6,028.40 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_6.audit_ev_id = aea_7.audit_ev_id)
68. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_6 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_6.ev_id = aea_53.ev_id)
  • Filter: (((aea_53.ev_id IS NOT NULL) AND (evs_6.ev_id IS NULL)) OR (aea_53.ev_id IS NULL))
71. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_6 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_53.ev_id
74. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_53 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
75. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_54 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
76. 0.000 0.000 ↓ 0.0

Hash (cost=54.85..54.85 rows=1,585 width=14) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200815 aea_7 (cost=0.00..54.85 rows=1,585 width=14) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.10..5,956.50 rows=2 width=38) (actual rows= loops=)

  • Join Filter: (aea_8.audit_ev_id = aea2_7.audit_ev_id)
79. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200816_pkey on audit_evs_all_20200816 aea_8 (cost=0.12..3.14 rows=1 width=14) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_7 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_7.ev_id = aea_55.ev_id)
  • Filter: (((aea_55.ev_id IS NOT NULL) AND (evs_7.ev_id IS NULL)) OR (aea_55.ev_id IS NULL))
83. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_7 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_55.ev_id
86. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_55 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
87. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_56 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
88. 0.000 0.000 ↓ 0.0

Hash Join (cost=109.66..6,062.41 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_8.audit_ev_id = aea_9.audit_ev_id)
89. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_8 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_8.ev_id = aea_57.ev_id)
  • Filter: (((aea_57.ev_id IS NOT NULL) AND (evs_8.ev_id IS NULL)) OR (aea_57.ev_id IS NULL))
92. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_8 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_57.ev_id
95. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_57 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
96. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_58 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
97. 0.000 0.000 ↓ 0.0

Hash (cost=83.30..83.30 rows=2,030 width=14) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200817 aea_9 (cost=0.00..83.30 rows=2,030 width=14) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Hash Join (cost=168.45..6,121.21 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_9.audit_ev_id = aea_10.audit_ev_id)
100. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_9 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_9.ev_id = aea_59.ev_id)
  • Filter: (((aea_59.ev_id IS NOT NULL) AND (evs_9.ev_id IS NULL)) OR (aea_59.ev_id IS NULL))
103. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_9 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_59.ev_id
106. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_59 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
107. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_60 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
108. 0.000 0.000 ↓ 0.0

Hash (cost=127.21..127.21 rows=3,221 width=14) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200818 aea_10 (cost=0.00..127.21 rows=3,221 width=14) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Hash Join (cost=266.99..6,219.75 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_10.audit_ev_id = aea_11.audit_ev_id)
111. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_10 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_10.ev_id = aea_61.ev_id)
  • Filter: (((aea_61.ev_id IS NOT NULL) AND (evs_10.ev_id IS NULL)) OR (aea_61.ev_id IS NULL))
114. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_10 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

115. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

116. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_61.ev_id
117. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_61 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
118. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_62 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
119. 0.000 0.000 ↓ 0.0

Hash (cost=206.56..206.56 rows=4,756 width=14) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200819 aea_11 (cost=0.00..206.56 rows=4,756 width=14) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Hash Join (cost=190.25..6,143.01 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_11.audit_ev_id = aea_12.audit_ev_id)
122. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_11 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_11.ev_id = aea_63.ev_id)
  • Filter: (((aea_63.ev_id IS NOT NULL) AND (evs_11.ev_id IS NULL)) OR (aea_63.ev_id IS NULL))
125. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_11 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_63.ev_id
128. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_63 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
129. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_64 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
130. 0.000 0.000 ↓ 0.0

Hash (cost=143.01..143.01 rows=3,701 width=14) (actual rows= loops=)

131. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200820 aea_12 (cost=0.00..143.01 rows=3,701 width=14) (actual rows= loops=)

132. 0.000 0.000 ↓ 0.0

Hash Join (cost=162.89..6,115.65 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_12.audit_ev_id = aea_13.audit_ev_id)
133. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_12 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

135. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_12.ev_id = aea_65.ev_id)
  • Filter: (((aea_65.ev_id IS NOT NULL) AND (evs_12.ev_id IS NULL)) OR (aea_65.ev_id IS NULL))
136. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_12 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

137. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_65.ev_id
139. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_65 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
140. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_66 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
141. 0.000 0.000 ↓ 0.0

Hash (cost=125.85..125.85 rows=2,885 width=14) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200821 aea_13 (cost=0.00..125.85 rows=2,885 width=14) (actual rows= loops=)

143. 0.000 0.000 ↓ 0.0

Hash Join (cost=26.19..5,978.94 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_13.audit_ev_id = aea_14.audit_ev_id)
144. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_13 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

145. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

146. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_13.ev_id = aea_67.ev_id)
  • Filter: (((aea_67.ev_id IS NOT NULL) AND (evs_13.ev_id IS NULL)) OR (aea_67.ev_id IS NULL))
147. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_13 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

148. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

149. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_67.ev_id
150. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_67 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
151. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_68 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
152. 0.000 0.000 ↓ 0.0

Hash (cost=18.98..18.98 rows=498 width=14) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200822 aea_14 (cost=0.00..18.98 rows=498 width=14) (actual rows= loops=)

154. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.10..5,956.50 rows=2 width=38) (actual rows= loops=)

  • Join Filter: (aea_15.audit_ev_id = aea2_14.audit_ev_id)
155. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200823_pkey on audit_evs_all_20200823 aea_15 (cost=0.12..3.14 rows=1 width=14) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_14 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

158. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_14.ev_id = aea_69.ev_id)
  • Filter: (((aea_69.ev_id IS NOT NULL) AND (evs_14.ev_id IS NULL)) OR (aea_69.ev_id IS NULL))
159. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_14 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_69.ev_id
162. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_69 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
163. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_70 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
164. 0.000 0.000 ↓ 0.0

Hash Join (cost=70.91..6,023.66 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_15.audit_ev_id = aea_16.audit_ev_id)
165. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_15 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

166. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

167. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_15.ev_id = aea_71.ev_id)
  • Filter: (((aea_71.ev_id IS NOT NULL) AND (evs_15.ev_id IS NULL)) OR (aea_71.ev_id IS NULL))
168. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_15 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_71.ev_id
171. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_71 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
172. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_72 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
173. 0.000 0.000 ↓ 0.0

Hash (cost=53.30..53.30 rows=1,330 width=14) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200824 aea_16 (cost=0.00..53.30 rows=1,330 width=14) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

Hash Join (cost=72.76..6,025.52 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_16.audit_ev_id = aea_17.audit_ev_id)
176. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_16 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

177. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_16.ev_id = aea_73.ev_id)
  • Filter: (((aea_73.ev_id IS NOT NULL) AND (evs_16.ev_id IS NULL)) OR (aea_73.ev_id IS NULL))
179. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_16 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

181. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_73.ev_id
182. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_73 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
183. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_74 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
184. 0.000 0.000 ↓ 0.0

Hash (cost=54.68..54.68 rows=1,368 width=14) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200825 aea_17 (cost=0.00..54.68 rows=1,368 width=14) (actual rows= loops=)

186. 0.000 0.000 ↓ 0.0

Hash Join (cost=127.21..6,079.97 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_17.audit_ev_id = aea_18.audit_ev_id)
187. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_17 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

188. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

189. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_17.ev_id = aea_75.ev_id)
  • Filter: (((aea_75.ev_id IS NOT NULL) AND (evs_17.ev_id IS NULL)) OR (aea_75.ev_id IS NULL))
190. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_17 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

191. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_75.ev_id
193. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_75 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
194. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_76 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
195. 0.000 0.000 ↓ 0.0

Hash (cost=97.77..97.77 rows=2,277 width=14) (actual rows= loops=)

196. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200826 aea_18 (cost=0.00..97.77 rows=2,277 width=14) (actual rows= loops=)

197. 0.000 0.000 ↓ 0.0

Hash Join (cost=96.90..6,049.66 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_18.audit_ev_id = aea_19.audit_ev_id)
198. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_18 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

199. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

200. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_18.ev_id = aea_77.ev_id)
  • Filter: (((aea_77.ev_id IS NOT NULL) AND (evs_18.ev_id IS NULL)) OR (aea_77.ev_id IS NULL))
201. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_18 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

202. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

203. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_77.ev_id
204. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_77 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
205. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_78 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
206. 0.000 0.000 ↓ 0.0

Hash (cost=72.63..72.63 rows=1,863 width=14) (actual rows= loops=)

207. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200827 aea_19 (cost=0.00..72.63 rows=1,863 width=14) (actual rows= loops=)

208. 0.000 0.000 ↓ 0.0

Hash Join (cost=23.33..5,976.09 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_19.audit_ev_id = aea_20.audit_ev_id)
209. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_19 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

210. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

211. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_19.ev_id = aea_79.ev_id)
  • Filter: (((aea_79.ev_id IS NOT NULL) AND (evs_19.ev_id IS NULL)) OR (aea_79.ev_id IS NULL))
212. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_19 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

213. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

214. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_79.ev_id
215. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_79 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
216. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_80 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
217. 0.000 0.000 ↓ 0.0

Hash (cost=16.60..16.60 rows=460 width=14) (actual rows= loops=)

218. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200828 aea_20 (cost=0.00..16.60 rows=460 width=14) (actual rows= loops=)

219. 0.000 0.000 ↓ 0.0

Hash Join (cost=19.58..5,972.33 rows=300 width=38) (actual rows= loops=)

  • Hash Cond: (aea2_20.audit_ev_id = aea_21.audit_ev_id)
220. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_20 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

221. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)

222. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=0.98..91,048.45 rows=4,594 width=8) (actual rows= loops=)

  • Merge Cond: (evs_20.ev_id = aea_81.ev_id)
  • Filter: (((aea_81.ev_id IS NOT NULL) AND (evs_20.ev_id IS NULL)) OR (aea_81.ev_id IS NULL))
223. 0.000 0.000 ↓ 0.0

Index Only Scan using evs_pk on evs evs_20 (cost=0.42..12,486.58 rows=187,262 width=8) (actual rows= loops=)

224. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..66,608.32 rows=918,832 width=16) (actual rows= loops=)

225. 0.000 0.000 ↓ 0.0

Merge Append (cost=0.56..64,311.24 rows=918,832 width=16) (actual rows= loops=)

  • Sort Key: aea_81.ev_id
226. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200809_ev_id_person_id_delivery_status_orde_idx on audit_evs_all_20200809 aea_81 (cost=0.12..3.14 rows=1 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
227. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_default_ev_id_insert_order_idx1 on audit_evs_all_default aea_82 (cost=0.42..55,119.77 rows=918,831 width=16) (actual rows= loops=)

  • Filter: (when_created <= '2020-08-09 12:15:21.635-07'::timestamp with time zone)
228. 0.000 0.000 ↓ 0.0

Hash (cost=13.82..13.82 rows=382 width=14) (actual rows= loops=)

229. 0.000 0.000 ↓ 0.0

Seq Scan on audit_evs_all_20200829 aea_21 (cost=0.00..13.82 rows=382 width=14) (actual rows= loops=)

230. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.10..5,956.50 rows=2 width=38) (actual rows= loops=)

  • Join Filter: (aea_22.audit_ev_id = aea2_21.audit_ev_id)
231. 0.000 0.000 ↓ 0.0

Index Scan using audit_evs_all_20200830_pkey on audit_evs_all_20200830 aea_22 (cost=0.12..3.14 rows=1 width=14) (actual rows= loops=)

232. 0.000 0.000 ↓ 0.0

Subquery Scan on aea2_21 (cost=0.98..5,949.61 rows=300 width=40) (actual rows= loops=)

233. 0.000 0.000 ↓ 0.0

Limit (cost=0.98..5,946.61 rows=300 width=8) (actual rows= loops=)