explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1pjA : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.058 217,265.444 ↑ 1.0 100 1

Limit (cost=17,100,907.93..17,100,908.18 rows=100 width=2,172) (actual time=217,265.376..217,265.444 rows=100 loops=1)

2. 100,813.070 217,265.386 ↑ 943,267.9 100 1

Sort (cost=17,100,907.93..17,336,724.90 rows=94,326,786 width=2,172) (actual time=217,265.372..217,265.386 rows=100 loops=1)

  • Sort Key: url_log_entry_01012018.log_time DESC
  • Sort Method: top-N heapsort Memory: 236kB
3. 6,245.741 116,452.316 ↑ 1.0 94,214,092 1

Append (cost=0.43..12,552,538.14 rows=94,326,786 width=2,172) (actual time=1.661..116,452.316 rows=94,214,092 loops=1)

4. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01012018_log_time on url_log_entry_01012018 (cost=0.43..4.45 rows=1 width=500) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
5. 0.065 0.065 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01022018_log_time on url_log_entry_01022018 (cost=0.43..4.45 rows=1 width=501) (actual time=0.065..0.065 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
6. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01032018_log_time on url_log_entry_01032018 (cost=0.43..4.45 rows=1 width=508) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
7. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01042018_log_time on url_log_entry_01042018 (cost=0.44..4.46 rows=1 width=508) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
8. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01052018_log_time on url_log_entry_01052018 (cost=0.43..4.45 rows=1 width=515) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
9. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01062018_log_time on url_log_entry_01062018 (cost=0.43..4.45 rows=1 width=492) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
10. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01072018_log_time on url_log_entry_01072018 (cost=0.43..4.45 rows=1 width=496) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
11. 0.019 0.019 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01082018_log_time on url_log_entry_01082018 (cost=0.43..4.45 rows=1 width=515) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
12. 0.024 0.024 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01112018_log_time on url_log_entry_01112018 (cost=0.56..4.58 rows=1 width=507) (actual time=0.023..0.024 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
13. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01112018_1_log_time on url_log_entry_01112018_1 (cost=0.44..4.46 rows=1 width=506) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
14. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01122018_log_time on url_log_entry_01122018 (cost=0.43..4.45 rows=1 width=520) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
15. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01132018_log_time on url_log_entry_01132018 (cost=0.43..4.45 rows=1 width=495) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
16. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01142018_log_time on url_log_entry_01142018 (cost=0.43..4.45 rows=1 width=511) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
17. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01152018_log_time on url_log_entry_01152018 (cost=0.43..4.45 rows=1 width=503) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
18. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01162018_log_time on url_log_entry_01162018 (cost=0.44..4.46 rows=1 width=507) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
19. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01172018_log_time on url_log_entry_01172018 (cost=0.44..4.46 rows=1 width=509) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
20. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01182018_log_time on url_log_entry_01182018 (cost=0.44..4.46 rows=1 width=511) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
21. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01192018_log_time on url_log_entry_01192018 (cost=0.44..4.46 rows=1 width=512) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
22. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01202018_log_time on url_log_entry_01202018 (cost=0.43..4.45 rows=1 width=492) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
23. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01212018_log_time on url_log_entry_01212018 (cost=0.43..4.45 rows=1 width=496) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
24. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01222018_log_time on url_log_entry_01222018 (cost=0.44..4.46 rows=1 width=515) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
25. 0.018 0.018 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01232018_log_time on url_log_entry_01232018 (cost=0.44..4.46 rows=1 width=512) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
26. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01242018_log_time on url_log_entry_01242018 (cost=0.44..4.46 rows=1 width=507) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
27. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01252018_log_time on url_log_entry_01252018 (cost=0.44..4.46 rows=1 width=512) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
28. 0.018 0.018 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01262018_log_time on url_log_entry_01262018 (cost=0.44..4.46 rows=1 width=514) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
29. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01272018_log_time on url_log_entry_01272018 (cost=0.43..4.45 rows=1 width=487) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
30. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01292018_log_time on url_log_entry_01292018 (cost=0.44..4.46 rows=1 width=509) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
31. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01302018_log_time on url_log_entry_01302018 (cost=0.44..4.46 rows=1 width=518) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
32. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_01312018_log_time on url_log_entry_01312018 (cost=0.44..4.46 rows=1 width=512) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
33. 0.023 0.023 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02012018_log_time on url_log_entry_02012018 (cost=0.44..4.46 rows=1 width=509) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
34. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02022018_log_time on url_log_entry_02022018 (cost=0.44..4.46 rows=1 width=507) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
35. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02052018_log_time on url_log_entry_02052018 (cost=0.56..4.58 rows=1 width=507) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
36. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02062018_log_time on url_log_entry_02062018 (cost=0.43..4.45 rows=1 width=513) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
37. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02072018_log_time on url_log_entry_02072018 (cost=0.44..4.46 rows=1 width=511) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
38. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02082018_log_time on url_log_entry_02082018 (cost=0.43..4.45 rows=1 width=528) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
39. 0.019 0.019 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02092018_log_time on url_log_entry_02092018 (cost=0.44..4.46 rows=1 width=539) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
40. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02102018_log_time on url_log_entry_02102018 (cost=0.43..4.45 rows=1 width=499) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
41. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02112018_log_time on url_log_entry_02112018 (cost=0.43..4.45 rows=1 width=505) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
42. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02122018_log_time on url_log_entry_02122018 (cost=0.43..4.45 rows=1 width=521) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
43. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02132018_log_time on url_log_entry_02132018 (cost=0.44..4.46 rows=1 width=523) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
44. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02142018_log_time on url_log_entry_02142018 (cost=0.44..4.46 rows=1 width=521) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
45. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02152018_log_time on url_log_entry_02152018 (cost=0.44..4.46 rows=1 width=527) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
46. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02162018_log_time on url_log_entry_02162018 (cost=0.44..4.46 rows=1 width=537) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
47. 0.019 0.019 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02172018_log_time on url_log_entry_02172018 (cost=0.43..4.45 rows=1 width=503) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
48. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02182018_log_time on url_log_entry_02182018 (cost=0.43..4.45 rows=1 width=507) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
49. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02192018_log_time on url_log_entry_02192018 (cost=0.43..4.45 rows=1 width=520) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
50. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02202018_log_time on url_log_entry_02202018 (cost=0.44..4.46 rows=1 width=523) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
51. 0.019 0.019 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02212018_log_time on url_log_entry_02212018 (cost=0.44..4.46 rows=1 width=520) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
52. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02222018_log_time on url_log_entry_02222018 (cost=0.44..4.46 rows=1 width=517) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
53. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02232018_log_time on url_log_entry_02232018 (cost=0.44..4.46 rows=1 width=430) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
54. 0.025 0.025 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02242018_log_time on url_log_entry_02242018 (cost=0.43..4.45 rows=1 width=508) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
55. 0.019 0.019 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02252018_log_time on url_log_entry_02252018 (cost=0.43..4.45 rows=1 width=510) (actual time=0.018..0.019 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
56. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02262018_log_time on url_log_entry_02262018 (cost=0.44..4.46 rows=1 width=522) (actual time=0.013..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
57. 0.020 0.020 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02272018_log_time on url_log_entry_02272018 (cost=0.43..4.45 rows=1 width=524) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
58. 0.018 0.018 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02282018_log_time on url_log_entry_02282018 (cost=0.44..4.46 rows=1 width=523) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
59. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03012018_log_time on url_log_entry_03012018 (cost=0.44..4.46 rows=1 width=514) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
60. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03022018_log_time on url_log_entry_03022018 (cost=0.44..4.46 rows=1 width=518) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
61. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03032018_log_time on url_log_entry_03032018 (cost=0.43..4.45 rows=1 width=506) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
62. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03042018_log_time on url_log_entry_03042018 (cost=0.43..4.45 rows=1 width=513) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
63. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03052018_log_time on url_log_entry_03052018 (cost=0.43..4.45 rows=1 width=514) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
64. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03062018_log_time on url_log_entry_03062018 (cost=0.44..4.46 rows=1 width=518) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
65. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03072018_log_time on url_log_entry_03072018 (cost=0.44..4.46 rows=1 width=514) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
66. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03082018_log_time on url_log_entry_03082018 (cost=0.44..4.46 rows=1 width=516) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
67. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03092018_log_time on url_log_entry_03092018 (cost=0.43..4.45 rows=1 width=517) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
68. 0.021 0.021 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03102018_log_time on url_log_entry_03102018 (cost=0.44..4.46 rows=1 width=517) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
69. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03112018_log_time on url_log_entry_03112018 (cost=0.43..4.45 rows=1 width=507) (actual time=0.013..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
70. 0.010 0.010 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03122018_log_time on url_log_entry_03122018 (cost=0.43..4.45 rows=1 width=507) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
71. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03132018_log_time on url_log_entry_03132018 (cost=0.44..4.46 rows=1 width=514) (actual time=0.014..0.015 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
72. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03142018_log_time on url_log_entry_03142018 (cost=0.44..4.46 rows=1 width=516) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
73. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03162018_log_time on url_log_entry_03162018 (cost=0.56..4.58 rows=1 width=517) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
74. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03162018_1_log_time on url_log_entry_03162018_1 (cost=0.43..4.45 rows=1 width=507) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
75. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03172018_log_time on url_log_entry_03172018 (cost=0.44..4.46 rows=1 width=516) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
76. 0.020 0.020 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03182018_log_time on url_log_entry_03182018 (cost=0.43..4.45 rows=1 width=510) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
77. 0.011 0.011 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03192018_log_time on url_log_entry_03192018 (cost=0.43..4.45 rows=1 width=504) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
78. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03202018_log_time on url_log_entry_03202018 (cost=0.44..4.46 rows=1 width=514) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
79. 0.017 0.017 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03212018_log_time on url_log_entry_03212018 (cost=0.44..4.46 rows=1 width=514) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
80. 0.001 0.012 ↓ 0.0 0 1

Subquery Scan on *SELECT* 77 (cost=0.00..10.32 rows=7 width=2,172) (actual time=0.012..0.012 rows=0 loops=1)

81. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on url_log_entry_01152019 (cost=0.00..10.25 rows=7 width=3,470) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
82. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02022019_log_time on url_log_entry_02022019 (cost=0.44..4.46 rows=1 width=845) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
83. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02022019_1_log_time on url_log_entry_02022019_1 (cost=0.43..4.45 rows=1 width=840) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
84. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02042019_log_time on url_log_entry_02042019 (cost=0.44..4.46 rows=1 width=846) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
85. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02052019_log_time on url_log_entry_02052019 (cost=0.44..4.46 rows=1 width=839) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
86. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02072019_log_time on url_log_entry_02072019 (cost=0.44..4.46 rows=1 width=839) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
87. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02092019_log_time on url_log_entry_02092019 (cost=0.56..4.58 rows=1 width=842) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
88. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02092019_1_log_time on url_log_entry_02092019_1 (cost=0.43..4.45 rows=1 width=845) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
89. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02112019_log_time on url_log_entry_02112019 (cost=0.44..4.46 rows=1 width=848) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
90. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02122019_log_time on url_log_entry_02122019 (cost=0.44..4.46 rows=1 width=842) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
91. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02132019_log_time on url_log_entry_02132019 (cost=0.44..4.46 rows=1 width=848) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
92. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02142019_log_time on url_log_entry_02142019 (cost=0.44..4.46 rows=1 width=839) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
93. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02162019_log_time on url_log_entry_02162019 (cost=0.44..4.46 rows=1 width=841) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
94. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02202019_log_time on url_log_entry_02202019 (cost=0.43..4.45 rows=1 width=843) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
95. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02212019_log_time on url_log_entry_02212019 (cost=0.44..4.46 rows=1 width=842) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
96. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02222019_log_time on url_log_entry_02222019 (cost=0.44..4.46 rows=1 width=841) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
97. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02232019_log_time on url_log_entry_02232019 (cost=0.44..4.46 rows=1 width=845) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
98. 0.019 0.019 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02242019_log_time on url_log_entry_02242019 (cost=0.43..4.45 rows=1 width=849) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
99. 0.016 0.016 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02252019_log_time on url_log_entry_02252019 (cost=0.43..4.45 rows=1 width=849) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
100. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02262019_log_time on url_log_entry_02262019 (cost=0.44..4.46 rows=1 width=750) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
101. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02272019_log_time on url_log_entry_02272019 (cost=0.44..4.46 rows=1 width=748) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
102. 0.020 0.020 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_02282019_log_time on url_log_entry_02282019 (cost=0.44..4.46 rows=1 width=754) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
103. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03012019_log_time on url_log_entry_03012019 (cost=0.44..4.46 rows=1 width=751) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
104. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03022019_log_time on url_log_entry_03022019 (cost=0.44..4.46 rows=1 width=844) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
105. 0.014 0.014 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03032019_log_time on url_log_entry_03032019 (cost=0.43..4.45 rows=1 width=845) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
106. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03042019_log_time on url_log_entry_03042019 (cost=0.43..4.45 rows=1 width=749) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
107. 0.013 0.013 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03052019_log_time on url_log_entry_03052019 (cost=0.44..4.46 rows=1 width=844) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
108. 0.015 0.015 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03062019_log_time on url_log_entry_03062019 (cost=0.44..4.46 rows=1 width=748) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
109. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ix_url_log_entry_03072019_log_time on url_log_entry_03072019 (cost=0.44..4.46 rows=1 width=841) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
110. 2,203.948 2,203.948 ↓ 1.0 2,083,373 1

Seq Scan on url_log_entry_09262019 (cost=0.00..251,202.12 rows=2,080,650 width=846) (actual time=0.010..2,203.948 rows=2,083,373 loops=1)

  • Filter: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
111. 59,141.655 59,141.655 ↑ 1.0 50,616,608 1

Seq Scan on url_log_entry_09272019 (cost=0.00..5,993,571.36 rows=50,770,269 width=840) (actual time=0.023..59,141.655 rows=50,616,608 loops=1)

  • Filter: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
112. 78.225 78.225 ↓ 1.0 72,515 1

Seq Scan on url_log_entry_09272019_1 (cost=0.00..8,591.51 rows=72,441 width=836) (actual time=0.011..78.225 rows=72,515 loops=1)

  • Filter: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)
113. 48,781.107 48,781.107 ↓ 1.0 41,441,596 1

Seq Scan on url_log_entry_current (cost=0.00..4,883,797.44 rows=41,403,315 width=838) (actual time=0.013..48,781.107 rows=41,441,596 loops=1)

  • Filter: (log_time >= '2019-09-01 02:15:00'::timestamp without time zone)