explain.depesz.com

PostgreSQL's explain analyze made readable

Result: piMk : test_hits

Settings
# exclusive inclusive rows x rows loops node
1. 38,561.718 368,651.475 ↑ 1.0 1 1

Aggregate (cost=3,751,389.79..3,751,389.80 rows=1 width=8) (actual time=368,651.475..368,651.475 rows=1 loops=1)

2. 64,268.524 330,089.757 ↑ 1.0 92,379,245 1

Append (cost=0.00..3,520,440.83 rows=92,379,584 width=8) (actual time=7.110..330,089.757 rows=92,379,245 loops=1)

3. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on f_traffic_hits_property_page_view (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

4. 6,621.595 6,621.595 ↑ 1.0 1,058,452 1

Seq Scan on f_traffic_hits_property_page_view_201709 (cost=0.00..39,376.52 rows=1,058,452 width=8) (actual time=7.106..6,621.595 rows=1,058,452 loops=1)

5. 8,213.769 8,213.769 ↓ 1.0 1,124,852 1

Seq Scan on f_traffic_hits_property_page_view_201710 (cost=0.00..41,814.42 rows=1,124,842 width=8) (actual time=15.944..8,213.769 rows=1,124,852 loops=1)

6. 6,531.499 6,531.499 ↑ 1.0 1,073,595 1

Seq Scan on f_traffic_hits_property_page_view_201711 (cost=0.00..39,910.95 rows=1,073,595 width=8) (actual time=9.102..6,531.499 rows=1,073,595 loops=1)

7. 7,175.062 7,175.062 ↑ 1.0 1,022,320 1

Seq Scan on f_traffic_hits_property_page_view_201712 (cost=0.00..38,026.20 rows=1,022,320 width=8) (actual time=6.926..7,175.062 rows=1,022,320 loops=1)

8. 12,635.113 12,635.113 ↓ 1.0 1,455,175 1

Seq Scan on f_traffic_hits_property_page_view_201801 (cost=0.00..54,114.44 rows=1,455,144 width=8) (actual time=14.613..12,635.113 rows=1,455,175 loops=1)

9. 7,068.411 7,068.411 ↑ 1.0 1,230,797 1

Seq Scan on f_traffic_hits_property_page_view_201802 (cost=0.00..45,734.08 rows=1,230,808 width=8) (actual time=21.968..7,068.411 rows=1,230,797 loops=1)

10. 4,949.377 4,949.377 ↓ 1.0 1,375,008 1

Seq Scan on f_traffic_hits_property_page_view_201803 (cost=0.00..51,108.99 rows=1,374,999 width=8) (actual time=18.468..4,949.377 rows=1,375,008 loops=1)

11. 7,330.327 7,330.327 ↓ 1.0 1,752,949 1

Seq Scan on f_traffic_hits_property_page_view_201805 (cost=0.00..65,174.44 rows=1,752,844 width=8) (actual time=1.818..7,330.327 rows=1,752,949 loops=1)

12. 3,971.687 3,971.687 ↑ 1.0 1,466,017 1

Seq Scan on f_traffic_hits_property_page_view_201804 (cost=0.00..54,483.43 rows=1,466,043 width=8) (actual time=3.293..3,971.687 rows=1,466,017 loops=1)

13. 4,274.974 4,274.974 ↑ 1.0 1,915,172 1

Seq Scan on f_traffic_hits_property_page_view_201806 (cost=0.00..71,193.65 rows=1,915,265 width=8) (actual time=0.987..4,274.974 rows=1,915,172 loops=1)

14. 10,932.700 10,932.700 ↓ 1.0 2,868,610 1

Seq Scan on f_traffic_hits_property_page_view_201807 (cost=0.00..106,588.70 rows=2,868,570 width=8) (actual time=2.361..10,932.700 rows=2,868,610 loops=1)

15. 12,572.437 12,572.437 ↓ 1.0 3,272,450 1

Seq Scan on f_traffic_hits_property_page_view_201808 (cost=0.00..121,598.89 rows=3,272,389 width=8) (actual time=3.619..12,572.437 rows=3,272,450 loops=1)

16. 28,048.199 28,048.199 ↑ 1.0 3,415,634 1

Seq Scan on f_traffic_hits_property_page_view_201809 (cost=0.00..210,666.34 rows=3,415,634 width=8) (actual time=4.985..28,048.199 rows=3,415,634 loops=1)

17. 17,989.585 17,989.585 ↓ 1.0 4,522,683 1

Seq Scan on f_traffic_hits_property_page_view_201810 (cost=0.00..168,120.76 rows=4,521,876 width=8) (actual time=5.344..17,989.585 rows=4,522,683 loops=1)

18. 10,234.943 10,234.943 ↓ 1.0 3,032,816 1

Seq Scan on f_traffic_hits_property_page_view_201811 (cost=0.00..112,839.09 rows=3,032,609 width=8) (actual time=0.906..10,234.943 rows=3,032,816 loops=1)

19. 10,576.171 10,576.171 ↑ 1.0 4,276,633 1

Seq Scan on f_traffic_hits_property_page_view_201812 (cost=0.00..159,196.01 rows=4,277,101 width=8) (actual time=6.942..10,576.171 rows=4,276,633 loops=1)

20. 14,044.273 14,044.273 ↑ 1.0 7,896,299 1

Seq Scan on f_traffic_hits_property_page_view_201901 (cost=0.00..294,054.85 rows=7,896,385 width=8) (actual time=1.020..14,044.273 rows=7,896,299 loops=1)

21. 9,348.556 9,348.556 ↑ 1.0 6,812,106 1

Seq Scan on f_traffic_hits_property_page_view_201902 (cost=0.00..253,641.03 rows=6,813,003 width=8) (actual time=1.014..9,348.556 rows=6,812,106 loops=1)

22. 6,310.362 6,310.362 ↑ 1.0 2,978,032 1

Seq Scan on f_traffic_hits_property_page_view_201903 (cost=0.00..110,840.56 rows=2,978,356 width=8) (actual time=0.742..6,310.362 rows=2,978,032 loops=1)

23. 4,046.969 4,046.969 ↑ 1.0 2,243,372 1

Seq Scan on f_traffic_hits_property_page_view_201904 (cost=0.00..83,502.14 rows=2,243,514 width=8) (actual time=1.043..4,046.969 rows=2,243,372 loops=1)

24. 5,488.221 5,488.221 ↑ 1.0 2,818,013 1

Seq Scan on f_traffic_hits_property_page_view_201905 (cost=0.00..104,944.01 rows=2,818,301 width=8) (actual time=1.203..5,488.221 rows=2,818,013 loops=1)

25. 5,299.938 5,299.938 ↑ 1.0 2,941,663 1

Seq Scan on f_traffic_hits_property_page_view_201906 (cost=0.00..109,546.68 rows=2,941,668 width=8) (actual time=0.926..5,299.938 rows=2,941,663 loops=1)

26. 6,495.132 6,495.132 ↓ 1.0 3,693,771 1

Seq Scan on f_traffic_hits_property_page_view_201907 (cost=0.00..137,489.19 rows=3,693,419 width=8) (actual time=0.944..6,495.132 rows=3,693,771 loops=1)

27. 6,555.024 6,555.024 ↓ 1.0 3,605,891 1

Seq Scan on f_traffic_hits_property_page_view_201908 (cost=0.00..134,303.18 rows=3,605,518 width=8) (actual time=1.054..6,555.024 rows=3,605,891 loops=1)

28. 5,143.367 5,143.367 ↑ 1.0 2,786,417 1

Seq Scan on f_traffic_hits_property_page_view_201909 (cost=0.00..103,719.83 rows=2,786,783 width=8) (actual time=0.850..5,143.367 rows=2,786,417 loops=1)

29. 4,994.939 4,994.939 ↓ 1.0 2,713,379 1

Seq Scan on f_traffic_hits_property_page_view_201910 (cost=0.00..100,936.03 rows=2,713,303 width=8) (actual time=0.929..4,994.939 rows=2,713,379 loops=1)

30. 5,636.649 5,636.649 ↓ 1.0 3,102,445 1

Seq Scan on f_traffic_hits_property_page_view_201911 (cost=0.00..115,334.78 rows=3,102,378 width=8) (actual time=0.931..5,636.649 rows=3,102,445 loops=1)

31. 5,179.437 5,179.437 ↓ 1.0 3,070,387 1

Seq Scan on f_traffic_hits_property_page_view_201912 (cost=0.00..114,104.16 rows=3,070,316 width=8) (actual time=0.978..5,179.437 rows=3,070,387 loops=1)

32. 7,877.929 7,877.929 ↑ 1.0 3,511,653 1

Seq Scan on f_traffic_hits_property_page_view_202001 (cost=0.00..130,579.61 rows=3,511,761 width=8) (actual time=0.870..7,877.929 rows=3,511,653 loops=1)

33. 6,329.089 6,329.089 ↓ 1.0 2,945,048 1

Seq Scan on f_traffic_hits_property_page_view_202002 (cost=0.00..109,529.02 rows=2,944,902 width=8) (actual time=1.933..6,329.089 rows=2,945,048 loops=1)

34. 3,793.107 3,793.107 ↓ 1.0 1,711,006 1

Seq Scan on f_traffic_hits_property_page_view_202003 (cost=0.00..63,632.83 rows=1,710,883 width=8) (actual time=0.927..3,793.107 rows=1,711,006 loops=1)

35. 2,278.311 2,278.311 ↑ 1.0 1,043,047 1

Seq Scan on f_traffic_hits_property_page_view_202004 (cost=0.00..38,792.47 rows=1,043,047 width=8) (actual time=1.217..2,278.311 rows=1,043,047 loops=1)

36. 2,762.670 2,762.670 ↑ 1.0 1,226,106 1

Seq Scan on f_traffic_hits_property_page_view_202005 (cost=0.00..45,601.10 rows=1,226,110 width=8) (actual time=0.898..2,762.670 rows=1,226,106 loops=1)

37. 3,040.437 3,040.437 ↓ 1.0 1,344,688 1

Seq Scan on f_traffic_hits_property_page_view_202006 (cost=0.00..50,032.86 rows=1,344,686 width=8) (actual time=0.971..3,040.437 rows=1,344,688 loops=1)

38. 2,070.972 2,070.972 ↑ 1.0 1,072,759 1

Seq Scan on f_traffic_hits_property_page_view_202007 (cost=0.00..39,909.59 rows=1,072,759 width=8) (actual time=1.079..2,070.972 rows=1,072,759 loops=1)

Planning time : 1,089.347 ms
Execution time : 368,651.659 ms