explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g3ZrB

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.986 4,677.700 ↓ 0.0 0 1

Delete on audit_evs_all aea (cost=6,808.08..2,283,466.10 rows=5,422 width=38) (actual time=4,677.534..4,677.700 rows=0 loops=1)

  • 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.131 1,102.109 ↑ 10.3 29 1

Nested Loop (cost=6,808.08..57,631.46 rows=300 width=38) (actual time=425.572..1,102.109 rows=29 loops=1)

3. 0.169 597.378 ↑ 1.0 300 1

Subquery Scan on aea2 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=425.524..597.378 rows=300 loops=1)

4. 0.086 597.209 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=425.495..597.209 rows=300 loops=1)

5. 48.124 597.123 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=425.491..597.123 rows=300 loops=1)

  • Hash Cond: (aea_41.ev_id = evs.ev_id)
  • Filter: (((aea_41.ev_id IS NOT NULL) AND (evs.ev_id IS NULL)) OR (aea_41.ev_id IS NULL))
  • Rows Removed by Filter: 131,531
6. 19.991 130.451 ↑ 12.9 253,485 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.054..130.451 rows=253,485 loops=1)

7. 107.156 107.156 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_41 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.052..107.156 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
8. 3.304 3.304 ↑ 430.2 7,025 1

Seq Scan on audit_evs_all_default aea_42 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.059..3.304 rows=7,025 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
9. 44.236 418.548 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=418.547..418.548 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
10. 374.312 374.312 ↑ 1.0 105,596 1

Seq Scan on evs (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=18.303..374.312 rows=105,596 loops=1)

11. 504.600 504.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200809_pkey on audit_evs_all_20200809 aea_1 (cost=0.42..3.30 rows=1 width=14) (actual time=1.681..1.682 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2.audit_ev_id)
12. 0.192 255.419 ↓ 0.0 0 1

Nested Loop (cost=6,808.08..57,641.96 rows=300 width=38) (actual time=255.415..255.419 rows=0 loops=1)

13. 0.123 204.527 ↑ 1.0 300 1

Subquery Scan on aea2_1 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=48.394..204.527 rows=300 loops=1)

14. 0.042 204.404 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=48.383..204.404 rows=300 loops=1)

15. 46.453 204.362 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=48.381..204.362 rows=300 loops=1)

  • Hash Cond: (aea_43.ev_id = evs_1.ev_id)
  • Filter: (((aea_43.ev_id IS NOT NULL) AND (evs_1.ev_id IS NULL)) OR (aea_43.ev_id IS NULL))
  • Rows Removed by Filter: 131,113
16. 22.294 116.025 ↑ 13.0 251,219 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.016..116.025 rows=251,219 loops=1)

17. 91.428 91.428 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_43 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.015..91.428 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
18. 2.303 2.303 ↑ 635.0 4,759 1

Seq Scan on audit_evs_all_default aea_44 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.015..2.303 rows=4,759 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
19. 21.245 41.884 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=41.883..41.884 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
20. 20.639 20.639 ↑ 1.0 105,596 1

Seq Scan on evs evs_1 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.013..20.639 rows=105,596 loops=1)

21. 50.700 50.700 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200810_pkey on audit_evs_all_20200810 aea_2 (cost=0.42..3.34 rows=1 width=14) (actual time=0.169..0.169 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_1.audit_ev_id)
22. 0.000 199.219 ↓ 0.0 0 1

Nested Loop (cost=6,808.08..57,641.96 rows=300 width=38) (actual time=199.215..199.219 rows=0 loops=1)

23. 0.101 198.633 ↑ 1.0 300 1

Subquery Scan on aea2_2 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=48.650..198.633 rows=300 loops=1)

24. 0.034 198.532 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=48.640..198.532 rows=300 loops=1)

25. 45.829 198.498 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=48.637..198.498 rows=300 loops=1)

  • Hash Cond: (aea_45.ev_id = evs_2.ev_id)
  • Filter: (((aea_45.ev_id IS NOT NULL) AND (evs_2.ev_id IS NULL)) OR (aea_45.ev_id IS NULL))
  • Rows Removed by Filter: 130,233
26. 18.940 110.494 ↑ 13.0 250,511 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.017..110.494 rows=250,511 loops=1)

27. 89.651 89.651 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_45 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.016..89.651 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
28. 1.903 1.903 ↑ 746.0 4,051 1

Seq Scan on audit_evs_all_default aea_46 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.016..1.903 rows=4,051 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
29. 21.252 42.175 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=42.175..42.175 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
30. 20.923 20.923 ↑ 1.0 105,596 1

Seq Scan on evs evs_2 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.012..20.923 rows=105,596 loops=1)

31. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200811_pkey on audit_evs_all_20200811 aea_3 (cost=0.42..3.34 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_2.audit_ev_id)
32. 0.015 199.542 ↓ 0.0 0 1

Nested Loop (cost=6,808.08..57,631.46 rows=300 width=38) (actual time=199.537..199.542 rows=0 loops=1)

33. 0.108 198.927 ↑ 1.0 300 1

Subquery Scan on aea2_3 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=47.966..198.927 rows=300 loops=1)

34. 0.034 198.819 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=47.954..198.819 rows=300 loops=1)

35. 45.611 198.785 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=47.952..198.785 rows=300 loops=1)

  • Hash Cond: (aea_47.ev_id = evs_3.ev_id)
  • Filter: (((aea_47.ev_id IS NOT NULL) AND (evs_3.ev_id IS NULL)) OR (aea_47.ev_id IS NULL))
  • Rows Removed by Filter: 130,200
36. 18.990 111.587 ↑ 13.0 250,679 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.016..111.587 rows=250,679 loops=1)

37. 90.434 90.434 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_47 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.015..90.434 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
38. 2.163 2.163 ↑ 716.3 4,219 1

Seq Scan on audit_evs_all_default aea_48 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.016..2.163 rows=4,219 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
39. 20.938 41.587 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=41.587..41.587 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
40. 20.649 20.649 ↑ 1.0 105,596 1

Seq Scan on evs evs_3 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.011..20.649 rows=105,596 loops=1)

41. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200812_pkey on audit_evs_all_20200812 aea_4 (cost=0.42..3.30 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_3.audit_ev_id)
42. 0.000 196.609 ↓ 0.0 0 1

Nested Loop (cost=6,808.08..57,626.21 rows=300 width=38) (actual time=196.603..196.609 rows=0 loops=1)

43. 0.101 196.046 ↑ 1.0 300 1

Subquery Scan on aea2_4 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=49.696..196.046 rows=300 loops=1)

44. 0.037 195.945 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=49.685..195.945 rows=300 loops=1)

45. 44.539 195.908 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=49.682..195.908 rows=300 loops=1)

  • Hash Cond: (aea_49.ev_id = evs_4.ev_id)
  • Filter: (((aea_49.ev_id IS NOT NULL) AND (evs_4.ev_id IS NULL)) OR (aea_49.ev_id IS NULL))
  • Rows Removed by Filter: 129,220
46. 18.695 108.068 ↑ 13.2 247,247 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.030..108.068 rows=247,247 loops=1)

47. 89.002 89.002 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_49 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.029..89.002 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
48. 0.371 0.371 ↑ 3,840.1 787 1

Seq Scan on audit_evs_all_default aea_50 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.022..0.371 rows=787 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
49. 21.432 43.301 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=43.301..43.301 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
50. 21.869 21.869 ↑ 1.0 105,596 1

Seq Scan on evs evs_4 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.012..21.869 rows=105,596 loops=1)

51. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200813_pkey on audit_evs_all_20200813 aea_5 (cost=0.42..3.29 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_4.audit_ev_id)
52. 0.000 195.998 ↓ 0.0 0 1

Nested Loop (cost=6,808.08..57,632.96 rows=300 width=38) (actual time=195.993..195.998 rows=0 loops=1)

53. 0.100 195.418 ↑ 1.0 300 1

Subquery Scan on aea2_5 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=47.417..195.418 rows=300 loops=1)

54. 0.033 195.318 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=47.407..195.318 rows=300 loops=1)

55. 44.471 195.285 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=47.406..195.285 rows=300 loops=1)

  • Hash Cond: (aea_51.ev_id = evs_5.ev_id)
  • Filter: (((aea_51.ev_id IS NOT NULL) AND (evs_5.ev_id IS NULL)) OR (aea_51.ev_id IS NULL))
  • Rows Removed by Filter: 129,335
56. 19.550 109.709 ↑ 13.2 247,219 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.012..109.709 rows=247,219 loops=1)

57. 89.812 89.812 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_51 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.012..89.812 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
58. 0.347 0.347 ↑ 3,981.8 759 1

Seq Scan on audit_evs_all_default aea_52 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.026..0.347 rows=759 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
59. 20.613 41.105 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=41.104..41.105 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
60. 20.492 20.492 ↑ 1.0 105,596 1

Seq Scan on evs evs_5 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.010..20.492 rows=105,596 loops=1)

61. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200814_pkey on audit_evs_all_20200814 aea_6 (cost=0.42..3.31 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_5.audit_ev_id)
62. 0.071 208.549 ↓ 0.0 0 1

Nested Loop (cost=6,808.07..57,589.46 rows=300 width=38) (actual time=208.544..208.549 rows=0 loops=1)

63. 0.106 207.878 ↑ 1.0 300 1

Subquery Scan on aea2_6 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=50.419..207.878 rows=300 loops=1)

64. 0.054 207.772 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=50.408..207.772 rows=300 loops=1)

65. 47.617 207.718 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=50.405..207.718 rows=300 loops=1)

  • Hash Cond: (aea_53.ev_id = evs_6.ev_id)
  • Filter: (((aea_53.ev_id IS NOT NULL) AND (evs_6.ev_id IS NULL)) OR (aea_53.ev_id IS NULL))
  • Rows Removed by Filter: 129,612
66. 20.410 116.365 ↑ 13.2 247,748 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.011..116.365 rows=247,748 loops=1)

67. 95.303 95.303 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_53 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.011..95.303 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
68. 0.652 0.652 ↑ 2,346.4 1,288 1

Seq Scan on audit_evs_all_default aea_54 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.018..0.652 rows=1,288 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
69. 22.077 43.736 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=43.736..43.736 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
70. 21.659 21.659 ↑ 1.0 105,596 1

Seq Scan on evs evs_6 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.011..21.659 rows=105,596 loops=1)

71. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200815_pkey on audit_evs_all_20200815 aea_7 (cost=0.42..3.16 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_6.audit_ev_id)
72. 0.025 211.089 ↓ 0.0 0 1

Nested Loop (cost=6,808.07..57,565.46 rows=300 width=38) (actual time=211.084..211.089 rows=0 loops=1)

73. 0.098 210.464 ↑ 1.0 300 1

Subquery Scan on aea2_7 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=53.327..210.464 rows=300 loops=1)

74. 0.039 210.366 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=53.317..210.366 rows=300 loops=1)

75. 48.110 210.327 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=53.315..210.327 rows=300 loops=1)

  • Hash Cond: (aea_55.ev_id = evs_7.ev_id)
  • Filter: (((aea_55.ev_id IS NOT NULL) AND (evs_7.ev_id IS NULL)) OR (aea_55.ev_id IS NULL))
  • Rows Removed by Filter: 129,849
76. 19.630 116.093 ↑ 13.2 248,233 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.016..116.093 rows=248,233 loops=1)

77. 95.694 95.694 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_55 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.015..95.694 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
78. 0.769 0.769 ↑ 1,704.5 1,773 1

Seq Scan on audit_evs_all_default aea_56 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.017..0.769 rows=1,773 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
79. 23.463 46.124 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=46.124..46.124 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
80. 22.661 22.661 ↑ 1.0 105,596 1

Seq Scan on evs evs_7 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.018..22.661 rows=105,596 loops=1)

81. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200816_pkey on audit_evs_all_20200816 aea_8 (cost=0.42..3.08 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_7.audit_ev_id)
82. 0.000 197.561 ↓ 0.0 0 1

Nested Loop (cost=6,808.08..57,609.71 rows=300 width=38) (actual time=197.557..197.561 rows=0 loops=1)

83. 0.100 196.978 ↑ 1.0 300 1

Subquery Scan on aea2_8 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=49.499..196.978 rows=300 loops=1)

84. 0.032 196.878 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=49.486..196.878 rows=300 loops=1)

85. 44.353 196.846 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=49.484..196.846 rows=300 loops=1)

  • Hash Cond: (aea_57.ev_id = evs_8.ev_id)
  • Filter: (((aea_57.ev_id IS NOT NULL) AND (evs_8.ev_id IS NULL)) OR (aea_57.ev_id IS NULL))
  • Rows Removed by Filter: 129,372
86. 18.749 109.378 ↑ 13.1 248,683 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.020..109.378 rows=248,683 loops=1)

87. 89.672 89.672 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_57 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.020..89.672 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
88. 0.957 0.957 ↑ 1,359.5 2,223 1

Seq Scan on audit_evs_all_default aea_58 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.034..0.957 rows=2,223 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
89. 21.615 43.115 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=43.114..43.115 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
90. 21.500 21.500 ↑ 1.0 105,596 1

Seq Scan on evs evs_8 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.011..21.500 rows=105,596 loops=1)

91. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200817_pkey on audit_evs_all_20200817 aea_9 (cost=0.42..3.23 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_8.audit_ev_id)
92. 0.000 200.050 ↓ 0.0 0 1

Nested Loop (cost=6,808.08..57,614.21 rows=300 width=38) (actual time=200.046..200.050 rows=0 loops=1)

93. 0.106 199.459 ↑ 1.0 300 1

Subquery Scan on aea2_9 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=48.323..199.459 rows=300 loops=1)

94. 0.034 199.353 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=48.311..199.353 rows=300 loops=1)

95. 45.496 199.319 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=48.309..199.319 rows=300 loops=1)

  • Hash Cond: (aea_59.ev_id = evs_9.ev_id)
  • Filter: (((aea_59.ev_id IS NOT NULL) AND (evs_9.ev_id IS NULL)) OR (aea_59.ev_id IS NULL))
  • Rows Removed by Filter: 131,673
96. 19.439 111.937 ↑ 12.9 253,478 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.013..111.937 rows=253,478 loops=1)

97. 89.496 89.496 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_59 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.012..89.496 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
98. 3.002 3.002 ↑ 430.6 7,018 1

Seq Scan on audit_evs_all_default aea_60 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.027..3.002 rows=7,018 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
99. 20.916 41.886 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=41.885..41.886 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
100. 20.970 20.970 ↑ 1.0 105,596 1

Seq Scan on evs evs_9 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.011..20.970 rows=105,596 loops=1)

101. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200818_pkey on audit_evs_all_20200818 aea_10 (cost=0.42..3.25 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_9.audit_ev_id)
102. 0.015 196.545 ↓ 0.0 0 1

Nested Loop (cost=6,808.08..57,637.46 rows=300 width=38) (actual time=196.540..196.545 rows=0 loops=1)

103. 0.123 195.930 ↑ 1.0 300 1

Subquery Scan on aea2_10 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=48.201..195.930 rows=300 loops=1)

104. 0.036 195.807 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=48.183..195.807 rows=300 loops=1)

105. 44.512 195.771 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=48.181..195.771 rows=300 loops=1)

  • Hash Cond: (aea_61.ev_id = evs_10.ev_id)
  • Filter: (((aea_61.ev_id IS NOT NULL) AND (evs_10.ev_id IS NULL)) OR (aea_61.ev_id IS NULL))
  • Rows Removed by Filter: 130,148
106. 18.733 109.354 ↑ 13.1 249,218 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.018..109.354 rows=249,218 loops=1)

107. 89.186 89.186 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_61 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.017..89.186 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
108. 1.435 1.435 ↑ 1,095.8 2,758 1

Seq Scan on audit_evs_all_default aea_62 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.016..1.435 rows=2,758 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
109. 21.055 41.905 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=41.905..41.905 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
110. 20.850 20.850 ↑ 1.0 105,596 1

Seq Scan on evs evs_10 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.011..20.850 rows=105,596 loops=1)

111. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200819_pkey on audit_evs_all_20200819 aea_11 (cost=0.42..3.32 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_10.audit_ev_id)
112. 0.037 199.477 ↓ 0.0 0 1

Nested Loop (cost=6,808.08..57,624.71 rows=300 width=38) (actual time=199.472..199.477 rows=0 loops=1)

113. 0.114 198.840 ↑ 1.0 300 1

Subquery Scan on aea2_11 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=49.150..198.840 rows=300 loops=1)

114. 0.039 198.726 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=49.139..198.726 rows=300 loops=1)

115. 45.410 198.687 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=49.136..198.687 rows=300 loops=1)

  • Hash Cond: (aea_63.ev_id = evs_11.ev_id)
  • Filter: (((aea_63.ev_id IS NOT NULL) AND (evs_11.ev_id IS NULL)) OR (aea_63.ev_id IS NULL))
  • Rows Removed by Filter: 129,845
116. 18.846 110.543 ↑ 13.1 249,368 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.019..110.543 rows=249,368 loops=1)

117. 90.489 90.489 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_63 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.018..90.489 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
118. 1.208 1.208 ↑ 1,039.3 2,908 1

Seq Scan on audit_evs_all_default aea_64 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.016..1.208 rows=2,908 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
119. 21.558 42.734 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=42.733..42.734 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
120. 21.176 21.176 ↑ 1.0 105,596 1

Seq Scan on evs evs_11 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.018..21.176 rows=105,596 loops=1)

121. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200820_pkey on audit_evs_all_20200820 aea_12 (cost=0.42..3.28 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_11.audit_ev_id)
122. 0.018 208.401 ↓ 0.0 0 1

Nested Loop (cost=6,808.08..57,638.96 rows=300 width=38) (actual time=208.396..208.401 rows=0 loops=1)

123. 0.102 207.783 ↑ 1.0 300 1

Subquery Scan on aea2_12 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=57.856..207.783 rows=300 loops=1)

124. 0.038 207.681 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=57.847..207.681 rows=300 loops=1)

125. 46.041 207.643 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=57.845..207.643 rows=300 loops=1)

  • Hash Cond: (aea_65.ev_id = evs_12.ev_id)
  • Filter: (((aea_65.ev_id IS NOT NULL) AND (evs_12.ev_id IS NULL)) OR (aea_65.ev_id IS NULL))
  • Rows Removed by Filter: 129,000
126. 18.814 110.288 ↑ 13.2 246,928 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.021..110.288 rows=246,928 loops=1)

127. 91.263 91.263 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_65 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.021..91.263 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
128. 0.211 0.211 ↑ 6,457.6 468 1

Seq Scan on audit_evs_all_default aea_66 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.017..0.211 rows=468 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
129. 25.895 51.314 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=51.313..51.314 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
130. 25.419 25.419 ↑ 1.0 105,596 1

Seq Scan on evs evs_12 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.011..25.419 rows=105,596 loops=1)

131. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200821_pkey on audit_evs_all_20200821 aea_13 (cost=0.42..3.33 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_12.audit_ev_id)
132. 0.039 204.270 ↓ 0.0 0 1

Nested Loop (cost=6,808.08..57,634.46 rows=300 width=38) (actual time=204.265..204.270 rows=0 loops=1)

133. 0.099 203.631 ↑ 1.0 300 1

Subquery Scan on aea2_13 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=49.736..203.631 rows=300 loops=1)

134. 0.034 203.532 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=49.723..203.532 rows=300 loops=1)

135. 47.746 203.498 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=49.721..203.498 rows=300 loops=1)

  • Hash Cond: (aea_67.ev_id = evs_13.ev_id)
  • Filter: (((aea_67.ev_id IS NOT NULL) AND (evs_13.ev_id IS NULL)) OR (aea_67.ev_id IS NULL))
  • Rows Removed by Filter: 129,000
136. 19.122 112.608 ↑ 13.2 246,928 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.020..112.608 rows=246,928 loops=1)

137. 93.310 93.310 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_67 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.020..93.310 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
138. 0.176 0.176 ↑ 6,457.6 468 1

Seq Scan on audit_evs_all_default aea_68 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.031..0.176 rows=468 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
139. 22.084 43.144 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=43.143..43.144 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
140. 21.060 21.060 ↑ 1.0 105,596 1

Seq Scan on evs evs_13 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.012..21.060 rows=105,596 loops=1)

141. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200822_pkey on audit_evs_all_20200822 aea_14 (cost=0.42..3.31 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_13.audit_ev_id)
142. 0.113 204.411 ↓ 0.0 0 1

Nested Loop (cost=6,808.08..57,664.46 rows=300 width=38) (actual time=204.407..204.411 rows=0 loops=1)

143. 0.112 203.698 ↑ 1.0 300 1

Subquery Scan on aea2_14 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=51.530..203.698 rows=300 loops=1)

144. 0.038 203.586 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=51.517..203.586 rows=300 loops=1)

145. 46.897 203.548 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=51.515..203.548 rows=300 loops=1)

  • Hash Cond: (aea_69.ev_id = evs_14.ev_id)
  • Filter: (((aea_69.ev_id IS NOT NULL) AND (evs_14.ev_id IS NULL)) OR (aea_69.ev_id IS NULL))
  • Rows Removed by Filter: 129,000
146. 19.344 111.624 ↑ 13.2 246,928 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.017..111.624 rows=246,928 loops=1)

147. 92.098 92.098 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_69 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.017..92.098 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
148. 0.182 0.182 ↑ 6,457.6 468 1

Seq Scan on audit_evs_all_default aea_70 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.020..0.182 rows=468 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
149. 22.813 45.027 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=45.026..45.027 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
150. 22.214 22.214 ↑ 1.0 105,596 1

Seq Scan on evs evs_14 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.013..22.214 rows=105,596 loops=1)

151. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200823_pkey on audit_evs_all_20200823 aea_15 (cost=0.43..3.42 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_14.audit_ev_id)
152. 0.005 201.742 ↓ 0.0 0 1

Nested Loop (cost=6,808.08..57,659.21 rows=300 width=38) (actual time=201.737..201.742 rows=0 loops=1)

153. 0.100 201.137 ↑ 1.0 300 1

Subquery Scan on aea2_15 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=52.681..201.137 rows=300 loops=1)

154. 0.034 201.037 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=52.668..201.037 rows=300 loops=1)

155. 44.555 201.003 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=52.667..201.003 rows=300 loops=1)

  • Hash Cond: (aea_71.ev_id = evs_15.ev_id)
  • Filter: (((aea_71.ev_id IS NOT NULL) AND (evs_15.ev_id IS NULL)) OR (aea_71.ev_id IS NULL))
  • Rows Removed by Filter: 129,000
156. 20.013 110.577 ↑ 13.2 246,928 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.034..110.577 rows=246,928 loops=1)

157. 90.405 90.405 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_71 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.034..90.405 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
158. 0.159 0.159 ↑ 6,457.6 468 1

Seq Scan on audit_evs_all_default aea_72 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.017..0.159 rows=468 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
159. 23.058 45.871 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=45.870..45.871 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
160. 22.813 22.813 ↑ 1.0 105,596 1

Seq Scan on evs evs_15 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.011..22.813 rows=105,596 loops=1)

161. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200824_pkey on audit_evs_all_20200824 aea_16 (cost=0.42..3.40 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_15.audit_ev_id)
162. 0.031 201.406 ↓ 0.0 0 1

Nested Loop (cost=6,808.08..57,643.46 rows=300 width=38) (actual time=201.401..201.406 rows=0 loops=1)

163. 0.109 200.775 ↑ 1.0 300 1

Subquery Scan on aea2_16 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=49.523..200.775 rows=300 loops=1)

164. 0.044 200.666 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=49.506..200.666 rows=300 loops=1)

165. 44.868 200.622 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=49.502..200.622 rows=300 loops=1)

  • Hash Cond: (aea_73.ev_id = evs_16.ev_id)
  • Filter: (((aea_73.ev_id IS NOT NULL) AND (evs_16.ev_id IS NULL)) OR (aea_73.ev_id IS NULL))
  • Rows Removed by Filter: 129,000
166. 20.701 112.653 ↑ 13.2 246,928 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.026..112.653 rows=246,928 loops=1)

167. 91.764 91.764 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_73 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.026..91.764 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
168. 0.188 0.188 ↑ 6,457.6 468 1

Seq Scan on audit_evs_all_default aea_74 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.021..0.188 rows=468 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
169. 21.750 43.101 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=43.100..43.101 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
170. 21.351 21.351 ↑ 1.0 105,596 1

Seq Scan on evs evs_16 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.011..21.351 rows=105,596 loops=1)

171. 0.600 0.600 ↓ 0.0 0 300

Index Scan using audit_evs_all_20200825_pkey on audit_evs_all_20200825 aea_17 (cost=0.42..3.35 rows=1 width=14) (actual time=0.002..0.002 rows=0 loops=300)

  • Index Cond: (audit_ev_id = aea2_16.audit_ev_id)
172. 0.063 0.082 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.078..0.082 rows=0 loops=1)

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

Subquery Scan on aea2_17 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

174. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

175. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_75.ev_id = evs_17.ev_id)
  • Filter: (((aea_75.ev_id IS NOT NULL) AND (evs_17.ev_id IS NULL)) OR (aea_75.ev_id IS NULL))
176. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

177. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_75 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
178. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_76 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
179. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

180. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_17 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

181. 0.001 0.019 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.019..0.019 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
182. 0.018 0.018 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200826_pkey on audit_evs_all_20200826 aea_18 (cost=0.12..3.14 rows=1 width=14) (actual time=0.018..0.018 rows=0 loops=1)

183. 0.020 0.029 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.026..0.029 rows=0 loops=1)

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

Subquery Scan on aea2_18 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

185. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

186. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_77.ev_id = evs_18.ev_id)
  • Filter: (((aea_77.ev_id IS NOT NULL) AND (evs_18.ev_id IS NULL)) OR (aea_77.ev_id IS NULL))
187. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

188. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_77 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
189. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_78 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
190. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

191. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_18 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

192. 0.001 0.009 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.009..0.009 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
193. 0.008 0.008 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200827_pkey on audit_evs_all_20200827 aea_19 (cost=0.12..3.14 rows=1 width=14) (actual time=0.008..0.008 rows=0 loops=1)

194. 0.017 0.027 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.024..0.027 rows=0 loops=1)

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

Subquery Scan on aea2_19 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

196. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

197. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_79.ev_id = evs_19.ev_id)
  • Filter: (((aea_79.ev_id IS NOT NULL) AND (evs_19.ev_id IS NULL)) OR (aea_79.ev_id IS NULL))
198. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

199. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_79 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
200. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_80 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
201. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

202. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_19 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

203. 0.001 0.010 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.009..0.010 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
204. 0.009 0.009 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200828_pkey on audit_evs_all_20200828 aea_20 (cost=0.12..3.14 rows=1 width=14) (actual time=0.008..0.009 rows=0 loops=1)

205. 0.018 0.028 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.024..0.028 rows=0 loops=1)

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

Subquery Scan on aea2_20 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

207. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

208. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_81.ev_id = evs_20.ev_id)
  • Filter: (((aea_81.ev_id IS NOT NULL) AND (evs_20.ev_id IS NULL)) OR (aea_81.ev_id IS NULL))
209. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

210. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_81 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
211. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_82 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
212. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

213. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_20 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

214. 0.001 0.010 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.009..0.010 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
215. 0.009 0.009 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200829_pkey on audit_evs_all_20200829 aea_21 (cost=0.12..3.14 rows=1 width=14) (actual time=0.009..0.009 rows=0 loops=1)

216. 0.023 0.040 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.037..0.040 rows=0 loops=1)

  • Hash Cond: (aea2_21.audit_ev_id = aea_22.audit_ev_id)
217. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_21 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

218. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

219. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_83.ev_id = evs_21.ev_id)
  • Filter: (((aea_83.ev_id IS NOT NULL) AND (evs_21.ev_id IS NULL)) OR (aea_83.ev_id IS NULL))
220. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

221. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_83 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
222. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_84 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
223. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

224. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_21 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

225. 0.001 0.017 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.016..0.017 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
226. 0.016 0.016 ↓ 0.0 0 1

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 time=0.016..0.016 rows=0 loops=1)

227. 0.017 0.028 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.025..0.028 rows=0 loops=1)

  • Hash Cond: (aea2_22.audit_ev_id = aea_23.audit_ev_id)
228. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_22 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

229. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

230. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_85.ev_id = evs_22.ev_id)
  • Filter: (((aea_85.ev_id IS NOT NULL) AND (evs_22.ev_id IS NULL)) OR (aea_85.ev_id IS NULL))
231. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

232. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_85 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
233. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_86 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
234. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

235. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_22 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

236. 0.000 0.011 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.011..0.011 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
237. 0.011 0.011 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200831_pkey on audit_evs_all_20200831 aea_23 (cost=0.12..3.14 rows=1 width=14) (actual time=0.010..0.011 rows=0 loops=1)

238. 0.018 0.027 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.025..0.027 rows=0 loops=1)

  • Hash Cond: (aea2_23.audit_ev_id = aea_24.audit_ev_id)
239. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_23 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

240. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

241. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_87.ev_id = evs_23.ev_id)
  • Filter: (((aea_87.ev_id IS NOT NULL) AND (evs_23.ev_id IS NULL)) OR (aea_87.ev_id IS NULL))
242. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

243. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_87 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
244. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_88 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
245. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

246. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_23 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

247. 0.001 0.009 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.008..0.009 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
248. 0.008 0.008 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200901_pkey on audit_evs_all_20200901 aea_24 (cost=0.12..3.14 rows=1 width=14) (actual time=0.008..0.008 rows=0 loops=1)

249. 0.020 0.028 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.026..0.028 rows=0 loops=1)

  • Hash Cond: (aea2_24.audit_ev_id = aea_25.audit_ev_id)
250. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_24 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

251. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

252. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_89.ev_id = evs_24.ev_id)
  • Filter: (((aea_89.ev_id IS NOT NULL) AND (evs_24.ev_id IS NULL)) OR (aea_89.ev_id IS NULL))
253. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

254. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_89 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
255. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_90 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
256. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

257. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_24 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

258. 0.001 0.008 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.007..0.008 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
259. 0.007 0.007 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200902_pkey on audit_evs_all_20200902 aea_25 (cost=0.12..3.14 rows=1 width=14) (actual time=0.007..0.007 rows=0 loops=1)

260. 0.024 0.036 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.033..0.036 rows=0 loops=1)

  • Hash Cond: (aea2_25.audit_ev_id = aea_26.audit_ev_id)
261. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_25 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

262. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

263. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_91.ev_id = evs_25.ev_id)
  • Filter: (((aea_91.ev_id IS NOT NULL) AND (evs_25.ev_id IS NULL)) OR (aea_91.ev_id IS NULL))
264. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

265. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_91 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
266. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_92 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
267. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

268. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_25 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

269. 0.002 0.012 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.011..0.012 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
270. 0.010 0.010 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200903_pkey on audit_evs_all_20200903 aea_26 (cost=0.12..3.14 rows=1 width=14) (actual time=0.010..0.010 rows=0 loops=1)

271. 0.018 0.026 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.024..0.026 rows=0 loops=1)

  • Hash Cond: (aea2_26.audit_ev_id = aea_27.audit_ev_id)
272. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_26 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

273. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

274. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_93.ev_id = evs_26.ev_id)
  • Filter: (((aea_93.ev_id IS NOT NULL) AND (evs_26.ev_id IS NULL)) OR (aea_93.ev_id IS NULL))
275. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

276. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_93 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
277. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_94 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
278. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

279. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_26 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

280. 0.000 0.008 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.008..0.008 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
281. 0.008 0.008 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200904_pkey on audit_evs_all_20200904 aea_27 (cost=0.12..3.14 rows=1 width=14) (actual time=0.008..0.008 rows=0 loops=1)

282. 0.017 0.029 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.026..0.029 rows=0 loops=1)

  • Hash Cond: (aea2_27.audit_ev_id = aea_28.audit_ev_id)
283. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_27 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

284. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

285. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_95.ev_id = evs_27.ev_id)
  • Filter: (((aea_95.ev_id IS NOT NULL) AND (evs_27.ev_id IS NULL)) OR (aea_95.ev_id IS NULL))
286. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

287. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_95 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
288. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_96 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
289. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

290. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_27 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

291. 0.000 0.012 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.012..0.012 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
292. 0.012 0.012 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200905_pkey on audit_evs_all_20200905 aea_28 (cost=0.12..3.14 rows=1 width=14) (actual time=0.011..0.012 rows=0 loops=1)

293. 0.029 0.041 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.039..0.041 rows=0 loops=1)

  • Hash Cond: (aea2_28.audit_ev_id = aea_29.audit_ev_id)
294. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_28 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

295. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

296. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_97.ev_id = evs_28.ev_id)
  • Filter: (((aea_97.ev_id IS NOT NULL) AND (evs_28.ev_id IS NULL)) OR (aea_97.ev_id IS NULL))
297. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

298. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_97 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
299. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_98 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
300. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

301. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_28 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

302. 0.001 0.012 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.011..0.012 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
303. 0.011 0.011 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200906_pkey on audit_evs_all_20200906 aea_29 (cost=0.12..3.14 rows=1 width=14) (actual time=0.011..0.011 rows=0 loops=1)

304. 0.020 0.029 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.027..0.029 rows=0 loops=1)

  • Hash Cond: (aea2_29.audit_ev_id = aea_30.audit_ev_id)
305. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_29 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

306. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

307. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_99.ev_id = evs_29.ev_id)
  • Filter: (((aea_99.ev_id IS NOT NULL) AND (evs_29.ev_id IS NULL)) OR (aea_99.ev_id IS NULL))
308. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

309. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_99 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
310. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_100 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
311. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

312. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_29 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

313. 0.000 0.009 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.009..0.009 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
314. 0.009 0.009 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200907_pkey on audit_evs_all_20200907 aea_30 (cost=0.12..3.14 rows=1 width=14) (actual time=0.008..0.009 rows=0 loops=1)

315. 0.017 0.025 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.023..0.025 rows=0 loops=1)

  • Hash Cond: (aea2_30.audit_ev_id = aea_31.audit_ev_id)
316. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_30 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

317. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

318. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_101.ev_id = evs_30.ev_id)
  • Filter: (((aea_101.ev_id IS NOT NULL) AND (evs_30.ev_id IS NULL)) OR (aea_101.ev_id IS NULL))
319. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

320. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_101 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
321. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_102 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
322. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

323. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_30 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

324. 0.000 0.008 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.008..0.008 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
325. 0.008 0.008 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200908_pkey on audit_evs_all_20200908 aea_31 (cost=0.12..3.14 rows=1 width=14) (actual time=0.008..0.008 rows=0 loops=1)

326. 0.019 0.028 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.026..0.028 rows=0 loops=1)

  • Hash Cond: (aea2_31.audit_ev_id = aea_32.audit_ev_id)
327. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_31 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

328. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

329. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_103.ev_id = evs_31.ev_id)
  • Filter: (((aea_103.ev_id IS NOT NULL) AND (evs_31.ev_id IS NULL)) OR (aea_103.ev_id IS NULL))
330. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

331. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_103 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
332. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_104 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
333. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

334. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_31 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

335. 0.001 0.009 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.008..0.009 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
336. 0.008 0.008 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200909_pkey on audit_evs_all_20200909 aea_32 (cost=0.12..3.14 rows=1 width=14) (actual time=0.008..0.008 rows=0 loops=1)

337. 0.025 0.048 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.045..0.048 rows=0 loops=1)

  • Hash Cond: (aea2_32.audit_ev_id = aea_33.audit_ev_id)
338. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_32 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

339. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

340. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_105.ev_id = evs_32.ev_id)
  • Filter: (((aea_105.ev_id IS NOT NULL) AND (evs_32.ev_id IS NULL)) OR (aea_105.ev_id IS NULL))
341. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

342. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_105 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
343. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_106 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
344. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

345. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_32 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

346. 0.001 0.023 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.022..0.023 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
347. 0.022 0.022 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200910_pkey on audit_evs_all_20200910 aea_33 (cost=0.12..3.14 rows=1 width=14) (actual time=0.022..0.022 rows=0 loops=1)

348. 0.026 0.035 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.032..0.035 rows=0 loops=1)

  • Hash Cond: (aea2_33.audit_ev_id = aea_34.audit_ev_id)
349. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_33 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

350. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

351. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_107.ev_id = evs_33.ev_id)
  • Filter: (((aea_107.ev_id IS NOT NULL) AND (evs_33.ev_id IS NULL)) OR (aea_107.ev_id IS NULL))
352. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

353. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_107 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
354. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_108 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
355. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

356. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_33 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

357. 0.001 0.009 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.008..0.009 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
358. 0.008 0.008 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200911_pkey on audit_evs_all_20200911 aea_34 (cost=0.12..3.14 rows=1 width=14) (actual time=0.008..0.008 rows=0 loops=1)

359. 0.018 0.026 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.024..0.026 rows=0 loops=1)

  • Hash Cond: (aea2_34.audit_ev_id = aea_35.audit_ev_id)
360. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_34 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

361. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

362. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_109.ev_id = evs_34.ev_id)
  • Filter: (((aea_109.ev_id IS NOT NULL) AND (evs_34.ev_id IS NULL)) OR (aea_109.ev_id IS NULL))
363. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

364. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_109 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
365. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_110 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
366. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

367. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_34 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

368. 0.000 0.008 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.008..0.008 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
369. 0.008 0.008 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200912_pkey on audit_evs_all_20200912 aea_35 (cost=0.12..3.14 rows=1 width=14) (actual time=0.007..0.008 rows=0 loops=1)

370. 0.022 0.031 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.029..0.031 rows=0 loops=1)

  • Hash Cond: (aea2_35.audit_ev_id = aea_36.audit_ev_id)
371. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_35 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

372. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

373. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_111.ev_id = evs_35.ev_id)
  • Filter: (((aea_111.ev_id IS NOT NULL) AND (evs_35.ev_id IS NULL)) OR (aea_111.ev_id IS NULL))
374. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

375. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_111 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
376. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_112 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
377. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

378. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_35 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

379. 0.000 0.009 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.009..0.009 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
380. 0.009 0.009 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200913_pkey on audit_evs_all_20200913 aea_36 (cost=0.12..3.14 rows=1 width=14) (actual time=0.008..0.009 rows=0 loops=1)

381. 0.020 0.035 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.033..0.035 rows=0 loops=1)

  • Hash Cond: (aea2_36.audit_ev_id = aea_37.audit_ev_id)
382. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_36 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

383. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

384. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_113.ev_id = evs_36.ev_id)
  • Filter: (((aea_113.ev_id IS NOT NULL) AND (evs_36.ev_id IS NULL)) OR (aea_113.ev_id IS NULL))
385. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

386. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_113 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
387. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_114 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
388. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

389. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_36 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

390. 0.001 0.015 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.014..0.015 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
391. 0.014 0.014 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200914_pkey on audit_evs_all_20200914 aea_37 (cost=0.12..3.14 rows=1 width=14) (actual time=0.014..0.014 rows=0 loops=1)

392. 0.016 0.027 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.025..0.027 rows=0 loops=1)

  • Hash Cond: (aea2_37.audit_ev_id = aea_38.audit_ev_id)
393. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_37 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

394. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

395. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_115.ev_id = evs_37.ev_id)
  • Filter: (((aea_115.ev_id IS NOT NULL) AND (evs_37.ev_id IS NULL)) OR (aea_115.ev_id IS NULL))
396. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

397. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_115 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
398. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_116 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
399. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

400. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_37 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

401. 0.001 0.011 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.010..0.011 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
402. 0.010 0.010 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200915_pkey on audit_evs_all_20200915 aea_38 (cost=0.12..3.14 rows=1 width=14) (actual time=0.010..0.010 rows=0 loops=1)

403. 0.018 0.028 ↓ 0.0 0 1

Hash Join (cost=6,810.81..56,641.24 rows=1 width=38) (actual time=0.026..0.028 rows=0 loops=1)

  • Hash Cond: (aea2_38.audit_ev_id = aea_39.audit_ev_id)
404. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aea2_38 (cost=6,807.66..56,636.96 rows=300 width=40) (never executed)

405. 0.000 0.000 ↓ 0.0 0

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (never executed)

406. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (never executed)

  • Hash Cond: (aea_117.ev_id = evs_38.ev_id)
  • Filter: (((aea_117.ev_id IS NOT NULL) AND (evs_38.ev_id IS NULL)) OR (aea_117.ev_id IS NULL))
407. 0.000 0.000 ↓ 0.0 0

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (never executed)

408. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_20200809 aea_117 (cost=0.00..13,744.55 rows=245,458 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
409. 0.000 0.000 ↓ 0.0 0

Seq Scan on audit_evs_all_default aea_118 (cost=0.00..164,190.62 rows=3,022,165 width=16) (never executed)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
410. 0.000 0.000 ↓ 0.0 0

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (never executed)

411. 0.000 0.000 ↓ 0.0 0

Seq Scan on evs evs_38 (cost=0.00..5,059.18 rows=106,518 width=8) (never executed)

412. 0.001 0.010 ↓ 0.0 0 1

Hash (cost=3.14..3.14 rows=1 width=14) (actual time=0.009..0.010 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
413. 0.009 0.009 ↓ 0.0 0 1

Index Scan using audit_evs_all_20200916_pkey on audit_evs_all_20200916 aea_39 (cost=0.12..3.14 rows=1 width=14) (actual time=0.009..0.009 rows=0 loops=1)

414. 0.301 292.584 ↑ 1.1 271 1

Nested Loop (cost=6,808.09..57,671.21 rows=300 width=38) (actual time=218.951..292.584 rows=271 loops=1)

415. 0.118 197.183 ↑ 1.0 300 1

Subquery Scan on aea2_39 (cost=6,807.66..56,636.96 rows=300 width=40) (actual time=50.532..197.183 rows=300 loops=1)

416. 0.045 197.065 ↑ 1.0 300 1

Limit (cost=6,807.66..56,633.96 rows=300 width=8) (actual time=50.520..197.065 rows=300 loops=1)

417. 44.076 197.020 ↑ 4.7 300 1

Hash Left Join (cost=6,807.66..241,987.80 rows=1,416 width=8) (actual time=50.518..197.020 rows=300 loops=1)

  • Hash Cond: (aea_119.ev_id = evs_39.ev_id)
  • Filter: (((aea_119.ev_id IS NOT NULL) AND (evs_39.ev_id IS NULL)) OR (aea_119.ev_id IS NULL))
  • Rows Removed by Filter: 129,000
418. 18.542 108.865 ↑ 13.2 246,928 1

Append (cost=0.00..194,273.29 rows=3,267,623 width=16) (actual time=0.025..108.865 rows=246,928 loops=1)

419. 90.111 90.111 ↓ 1.0 246,460 1

Seq Scan on audit_evs_all_20200809 aea_119 (cost=0.00..13,744.55 rows=245,458 width=16) (actual time=0.024..90.111 rows=246,460 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
  • Rows Removed by Filter: 30,784
420. 0.212 0.212 ↑ 6,457.6 468 1

Seq Scan on audit_evs_all_default aea_120 (cost=0.00..164,190.62 rows=3,022,165 width=16) (actual time=0.017..0.212 rows=468 loops=1)

  • Filter: (when_created <= '2020-08-09 19:15:21.635+00'::timestamp with time zone)
421. 22.210 44.079 ↑ 1.0 105,596 1

Hash (cost=5,059.18..5,059.18 rows=106,518 width=8) (actual time=44.078..44.079 rows=105,596 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,100kB
422. 21.869 21.869 ↑ 1.0 105,596 1

Seq Scan on evs evs_39 (cost=0.00..5,059.18 rows=106,518 width=8) (actual time=0.012..21.869 rows=105,596 loops=1)

423. 95.100 95.100 ↑ 1.0 1 300

Index Scan using audit_evs_all_default_pkey on audit_evs_all_default aea_40 (cost=0.43..3.44 rows=1 width=14) (actual time=0.317..0.317 rows=1 loops=300)

  • Index Cond: (audit_ev_id = aea2_39.audit_ev_id)
Planning time : 2,372.723 ms
Execution time : 10,960.838 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
audit_evs_all_arc_tr on audit_evs_all_20200809 1,961.883 ms 29 67.651 ms
audit_evs_all_arc_tr on audit_evs_all_default 4,286.462 ms 271 15.817 ms