explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 11Hh

Settings
# exclusive inclusive rows x rows loops node
1. 4,669.347 671,716.953 ↓ 9,065.0 9,065 1

Nested Loop (cost=19.12..292.22 rows=1 width=290) (actual time=1.342..671,716.953 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_33.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
2. 4,700.054 650,757.801 ↓ 9,065.0 9,065 1

Nested Loop (cost=18.56..283.62 rows=1 width=602) (actual time=1.320..650,757.801 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_32.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
3. 4,671.881 629,613.837 ↓ 9,065.0 9,065 1

Nested Loop (cost=18.00..275.03 rows=1 width=584) (actual time=1.284..629,613.837 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_31.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
4. 4,688.933 612,033.396 ↓ 9,065.0 9,065 1

Nested Loop (cost=17.44..266.43 rows=1 width=566) (actual time=1.273..612,033.396 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_30.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
5. 4,655.692 591,145.308 ↓ 9,065.0 9,065 1

Nested Loop (cost=16.88..257.84 rows=1 width=548) (actual time=1.233..591,145.308 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_29.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
6. 4,543.995 570,589.606 ↓ 9,065.0 9,065 1

Nested Loop (cost=16.31..249.24 rows=1 width=530) (actual time=1.205..570,589.606 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_28.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
7. 4,503.893 553,309.286 ↓ 9,065.0 9,065 1

Nested Loop (cost=15.75..240.65 rows=1 width=512) (actual time=1.161..553,309.286 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_27.geo_value)::text)
  • Rows Removed by Join Filter: 41142215
8. 4,698.323 535,706.468 ↓ 9,065.0 9,065 1

Nested Loop (cost=15.19..232.05 rows=1 width=494) (actual time=1.127..535,706.468 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_26.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
9. 4,704.127 514,799.925 ↓ 9,065.0 9,065 1

Nested Loop (cost=14.62..223.46 rows=1 width=476) (actual time=1.087..514,799.925 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_25.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
10. 4,682.262 494,594.648 ↓ 9,065.0 9,065 1

Nested Loop (cost=14.06..214.86 rows=1 width=458) (actual time=1.059..494,594.648 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_24.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
11. 4,709.285 473,278.111 ↓ 9,065.0 9,065 1

Nested Loop (cost=13.50..206.27 rows=1 width=440) (actual time=1.030..473,278.111 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_23.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
12. 4,908.610 452,115.851 ↓ 9,065.0 9,065 1

Nested Loop (cost=12.94..197.67 rows=1 width=422) (actual time=1.000..452,115.851 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_22.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
13. 4,749.910 431,669.831 ↓ 9,065.0 9,065 1

Nested Loop (cost=12.38..189.08 rows=1 width=404) (actual time=0.959..431,669.831 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_21.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
14. 4,675.185 410,675.441 ↓ 9,065.0 9,065 1

Nested Loop (cost=11.81..180.48 rows=1 width=386) (actual time=0.929..410,675.441 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_20.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
15. 4,671.006 389,447.566 ↓ 9,065.0 9,065 1

Nested Loop (cost=11.25..171.89 rows=1 width=368) (actual time=0.900..389,447.566 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_19.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
16. 4,681.215 368,949.070 ↓ 9,065.0 9,065 1

Nested Loop (cost=10.69..163.29 rows=1 width=350) (actual time=0.857..368,949.070 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_18.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
17. 4,664.768 348,123.090 ↓ 9,065.0 9,065 1

Nested Loop (cost=10.12..154.70 rows=1 width=332) (actual time=0.825..348,123.090 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_17.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
18. 4,706.029 327,857.457 ↓ 9,065.0 9,065 1

Nested Loop (cost=9.56..146.10 rows=1 width=314) (actual time=0.791..327,857.457 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_16.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
19. 4,635.695 306,453.698 ↓ 9,065.0 9,065 1

Nested Loop (cost=9.00..137.51 rows=1 width=296) (actual time=0.753..306,453.698 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_15.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
20. 4,864.180 287,667.538 ↓ 9,065.0 9,065 1

Nested Loop (cost=8.44..128.91 rows=1 width=278) (actual time=0.728..287,667.538 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_14.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
21. 4,660.591 266,948.673 ↓ 9,065.0 9,065 1

Nested Loop (cost=7.88..120.32 rows=1 width=260) (actual time=0.693..266,948.673 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_13.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
22. 4,670.167 245,889.497 ↓ 9,065.0 9,065 1

Nested Loop (cost=7.31..111.72 rows=1 width=242) (actual time=0.660..245,889.497 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_12.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
23. 4,685.905 225,346.515 ↓ 9,065.0 9,065 1

Nested Loop (cost=6.75..103.13 rows=1 width=224) (actual time=0.634..225,346.515 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_11.geo_value)::text)
  • Rows Removed by Join Filter: 41167007
24. 4,694.698 203,736.255 ↓ 9,065.0 9,065 1

Nested Loop (cost=6.19..94.53 rows=1 width=206) (actual time=0.601..203,736.255 rows=9,065 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_10.geo_value)::text)
  • Rows Removed by Join Filter: 41207131
25. 4,715.901 181,987.753 ↓ 9,076.0 9,076 1

Nested Loop (cost=5.62..85.94 rows=1 width=188) (actual time=0.571..181,987.753 rows=9,076 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_9.geo_value)::text)
  • Rows Removed by Join Filter: 41207178
26. 4,693.776 160,208.972 ↓ 9,076.0 9,076 1

Nested Loop (cost=5.06..77.34 rows=1 width=170) (actual time=0.535..160,208.972 rows=9,076 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_8.geo_value)::text)
  • Rows Removed by Join Filter: 41207178
27. 4,710.587 139,123.940 ↓ 9,076.0 9,076 1

Nested Loop (cost=4.50..68.75 rows=1 width=152) (actual time=0.387..139,123.940 rows=9,076 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_7.geo_value)::text)
  • Rows Removed by Join Filter: 41207178
28. 4,582.085 118,276.225 ↓ 9,076.0 9,076 1

Nested Loop (cost=3.94..60.15 rows=1 width=134) (actual time=0.337..118,276.225 rows=9,076 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_6.geo_value)::text)
  • Rows Removed by Join Filter: 41218654
29. 4,501.327 100,065.060 ↓ 9,080.0 9,080 1

Nested Loop (cost=3.38..51.56 rows=1 width=116) (actual time=0.300..100,065.060 rows=9,080 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_5.geo_value)::text)
  • Rows Removed by Join Filter: 41218660
30. 4,650.536 82,697.373 ↓ 9,080.0 9,080 1

Nested Loop (cost=2.81..42.96 rows=1 width=98) (actual time=0.264..82,697.373 rows=9,080 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_4.geo_value)::text)
  • Rows Removed by Join Filter: 41218660
31. 4,669.024 61,839.037 ↓ 9,080.0 9,080 1

Nested Loop (cost=2.25..34.37 rows=1 width=80) (actual time=0.224..61,839.037 rows=9,080 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_3.geo_value)::text)
  • Rows Removed by Join Filter: 41218660
32. 4,688.449 40,916.813 ↓ 9,080.0 9,080 1

Nested Loop (cost=1.69..25.77 rows=1 width=62) (actual time=0.178..40,916.813 rows=9,080 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_2.geo_value)::text)
  • Rows Removed by Join Filter: 41218660
33. 4,649.618 20,719.724 ↓ 9,080.0 9,080 1

Nested Loop (cost=1.12..17.18 rows=1 width=44) (actual time=0.135..20,719.724 rows=9,080 loops=1)

  • Join Filter: ((huawei_lte_cell_dly.geo_value)::text = (huawei_lte_cell_dly_1.geo_value)::text)
  • Rows Removed by Join Filter: 41218660
34. 16.666 16.666 ↓ 9,080.0 9,080 1

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly (cost=0.56..8.58 rows=1 width=26) (actual time=0.082..16.666 rows=9,080 loops=1)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 575))
35. 16,053.440 16,053.440 ↓ 4,540.0 4,540 9,080

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_1 (cost=0.56..8.58 rows=1 width=18) (actual time=0.014..1.768 rows=4,540 loops=9,080)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 450))
36. 15,508.640 15,508.640 ↓ 4,540.0 4,540 9,080

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_2 (cost=0.56..8.58 rows=1 width=18) (actual time=0.011..1.708 rows=4,540 loops=9,080)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 573))
37. 16,253.200 16,253.200 ↓ 4,540.0 4,540 9,080

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_3 (cost=0.56..8.58 rows=1 width=18) (actual time=0.011..1.790 rows=4,540 loops=9,080)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 569))
38. 16,207.800 16,207.800 ↓ 4,540.0 4,540 9,080

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_4 (cost=0.56..8.58 rows=1 width=18) (actual time=0.015..1.785 rows=4,540 loops=9,080)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 452))
39. 12,866.360 12,866.360 ↓ 4,540.0 4,540 9,080

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_5 (cost=0.56..8.58 rows=1 width=18) (actual time=0.013..1.417 rows=4,540 loops=9,080)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 453))
40. 13,629.080 13,629.080 ↓ 4,540.0 4,540 9,080

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_6 (cost=0.56..8.58 rows=1 width=18) (actual time=0.011..1.501 rows=4,540 loops=9,080)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 456))
41. 16,137.128 16,137.128 ↓ 4,541.0 4,541 9,076

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_7 (cost=0.56..8.58 rows=1 width=18) (actual time=0.011..1.778 rows=4,541 loops=9,076)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 582))
42. 16,391.256 16,391.256 ↓ 4,541.0 4,541 9,076

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_8 (cost=0.56..8.58 rows=1 width=18) (actual time=0.011..1.806 rows=4,541 loops=9,076)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 585))
43. 17,062.880 17,062.880 ↓ 4,541.0 4,541 9,076

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_9 (cost=0.56..8.58 rows=1 width=18) (actual time=0.014..1.880 rows=4,541 loops=9,076)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 587))
44. 17,053.804 17,053.804 ↓ 4,541.0 4,541 9,076

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_10 (cost=0.56..8.58 rows=1 width=18) (actual time=0.011..1.879 rows=4,541 loops=9,076)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 586))
45. 16,924.355 16,924.355 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_11 (cost=0.56..8.58 rows=1 width=18) (actual time=0.014..1.867 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 455))
46. 15,872.815 15,872.815 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_12 (cost=0.56..8.58 rows=1 width=18) (actual time=0.011..1.751 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 571))
47. 16,398.585 16,398.585 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_13 (cost=0.56..8.58 rows=1 width=18) (actual time=0.015..1.809 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 574))
48. 15,854.685 15,854.685 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_14 (cost=0.56..8.58 rows=1 width=18) (actual time=0.011..1.749 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 562))
49. 14,150.465 14,150.465 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_15 (cost=0.56..8.58 rows=1 width=18) (actual time=0.011..1.561 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 589))
50. 16,697.730 16,697.730 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_16 (cost=0.56..8.58 rows=1 width=18) (actual time=0.012..1.842 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 423))
51. 15,600.865 15,600.865 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_17 (cost=0.56..8.58 rows=1 width=18) (actual time=0.016..1.721 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 584))
52. 16,144.765 16,144.765 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_18 (cost=0.56..8.58 rows=1 width=18) (actual time=0.015..1.781 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 426))
53. 15,827.490 15,827.490 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_19 (cost=0.56..8.58 rows=1 width=18) (actual time=0.021..1.746 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 597))
54. 16,552.690 16,552.690 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_20 (cost=0.56..8.58 rows=1 width=18) (actual time=0.011..1.826 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 577))
55. 16,244.480 16,244.480 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_21 (cost=0.56..8.58 rows=1 width=18) (actual time=0.017..1.792 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 570))
56. 15,537.410 15,537.410 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_22 (cost=0.56..8.58 rows=1 width=18) (actual time=0.012..1.714 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 580))
57. 16,452.975 16,452.975 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_23 (cost=0.56..8.58 rows=1 width=18) (actual time=0.016..1.815 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 572))
58. 16,634.275 16,634.275 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_24 (cost=0.56..8.58 rows=1 width=18) (actual time=0.011..1.835 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 583))
59. 15,501.150 15,501.150 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_25 (cost=0.56..8.58 rows=1 width=18) (actual time=0.012..1.710 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 581))
60. 16,208.220 16,208.220 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_26 (cost=0.56..8.58 rows=1 width=18) (actual time=0.012..1.788 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 599))
61. 13,098.925 13,098.925 ↓ 4,540.0 4,540 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_27 (cost=0.56..8.58 rows=1 width=18) (actual time=0.015..1.445 rows=4,540 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 457))
62. 12,736.325 12,736.325 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_28 (cost=0.56..8.58 rows=1 width=18) (actual time=0.012..1.405 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 564))
63. 15,900.010 15,900.010 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_29 (cost=0.56..8.58 rows=1 width=18) (actual time=0.014..1.754 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 566))
64. 16,199.155 16,199.155 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_30 (cost=0.56..8.58 rows=1 width=18) (actual time=0.015..1.787 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 425))
65. 12,908.560 12,908.560 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_31 (cost=0.56..8.58 rows=1 width=18) (actual time=0.014..1.424 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 453))
66. 16,443.910 16,443.910 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_32 (cost=0.56..8.58 rows=1 width=18) (actual time=0.016..1.814 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 598))
67. 16,289.805 16,289.805 ↓ 4,542.0 4,542 9,065

Index Scan using huawei_lte_cell_dly_pkey on huawei_lte_cell_dly huawei_lte_cell_dly_33 (cost=0.56..8.58 rows=1 width=18) (actual time=0.011..1.797 rows=4,542 loops=9,065)

  • Index Cond: ((date_time = '2019-06-08 00:00:00'::timestamp without time zone) AND (formula_code = 567))
Planning time : 425.869 ms
Execution time : 671,723.051 ms