explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bqmo : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 93,417.779 ↑ 1.0 3 1

Limit (cost=7,728,215.82..7,728,215.83 rows=3 width=22) (actual time=93,417.778..93,417.779 rows=3 loops=1)

2. 0.037 93,417.777 ↑ 16.3 3 1

Sort (cost=7,728,215.82..7,728,215.94 rows=49 width=22) (actual time=93,417.776..93,417.777 rows=3 loops=1)

  • Sort Key: progressive_customerservice_mart_published_number.published_number
  • Sort Method: top-N heapsort Memory: 25kB
3. 1,931.099 93,417.740 ↑ 1.0 47 1

HashAggregate (cost=7,728,214.70..7,728,215.19 rows=49 width=22) (actual time=93,417.731..93,417.740 rows=47 loops=1)

  • Group Key: progressive_customerservice_mart_published_number.published_number, progressive_customerservice_mart_published_number.published_number
4. 636.398 91,486.641 ↓ 1.1 5,799,536 1

Gather (cost=1,012.70..7,700,764.22 rows=5,490,095 width=22) (actual time=163.670..91,486.641 rows=5,799,536 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
5. 3,957.146 90,850.243 ↑ 1.1 2,899,768 2

Hash Join (cost=12.70..7,150,754.72 rows=3,229,468 width=22) (actual time=115.728..90,850.243 rows=2,899,768 loops=2)

  • Hash Cond: (progressive_customerservice_mart_call_fact.published_number_key = progressive_customerservice_mart_published_number.published_number_key)
6. 16,640.827 86,892.901 ↑ 1.2 36,509,023 2

Append (cost=0.00..6,612,969.54 rows=42,642,171 width=4) (actual time=0.635..86,892.901 rows=36,509,023 loops=2)

  • -> Parallel Index Only Scan using progressive_customerservice_mart_cal_published_number_key_idx30 on progressive_customerservice_mart_call_fact_p2019_05 (cost=0.43..92933.04 rows=3045219 width=4) (actual time=4.425..5461.526 rows=28501
  • -> Parallel Index Only Scan using progressive_customerservice_mart_cal_published_number_key_idx32 on progressive_customerservice_mart_call_fact_p2019_07 (cost=0.43..94532.98 rows=3509586 width=4) (actual time=14.285..7883.075 rows=2977
7. 0.001 0.001 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact (cost=0.00..0.00 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=2)

8. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2016_11 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

9. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2016_12 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

10. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2017_01 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

11. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2017_02 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

12. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2017_03 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

13. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2017_04 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

14. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2017_05 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

15. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2017_06 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

16. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2017_07 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

17. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2017_08 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

18. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2017_09 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

19. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2017_10 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

20. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2017_11 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

21. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2017_12 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

22. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2018_01 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

23. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2018_02 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

24. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2018_03 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

25. 34.823 34.823 ↑ 1.2 33,660 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2018_04 (cost=0.00..3,602.00 rows=39,600 width=4) (actual time=0.601..34.823 rows=33,660 loops=2)

26. 64.497 64.497 ↑ 1.2 42,754 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2018_05 (cost=0.00..4,574.99 rows=50,299 width=4) (actual time=0.624..64.497 rows=42,754 loops=2)

27. 11.380 11.380 ↑ 1.2 1,564 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2018_06 (cost=0.00..322.39 rows=1,839 width=4) (actual time=0.860..11.380 rows=1,564 loops=2)

28. 377.061 377.061 ↑ 1.2 128,069 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2018_07 (cost=0.00..24,959.69 rows=150,669 width=4) (actual time=0.928..377.061 rows=128,069 loops=2)

29. 2,016.967 2,016.967 ↑ 1.2 816,777 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2018_08 (cost=0.00..167,116.42 rows=960,842 width=4) (actual time=2.276..2,016.967 rows=816,777 loops=2)

30. 363.272 363.272 ↑ 1.2 134,258 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2018_09 (cost=0.00..28,081.51 rows=157,951 width=4) (actual time=0.886..363.272 rows=134,258 loops=2)

31. 5,316.523 5,316.523 ↑ 1.2 2,071,240 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2018_10 (cost=0.00..440,270.20 rows=2,423,320 width=4) (actual time=0.825..5,316.523 rows=2,071,240 loops=2)

32. 5,861.131 5,861.131 ↑ 1.2 2,496,003 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2018_11 (cost=0.00..525,603.39 rows=2,937,139 width=4) (actual time=1.022..5,861.131 rows=2,496,003 loops=2)

33. 5,444.557 5,444.557 ↑ 1.2 2,421,804 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2018_12 (cost=0.00..509,041.04 rows=2,849,404 width=4) (actual time=0.749..5,444.557 rows=2,421,804 loops=2)

34. 6,190.618 6,190.618 ↑ 1.2 2,704,627 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2019_01 (cost=0.00..564,062.69 rows=3,180,969 width=4) (actual time=0.598..6,190.618 rows=2,704,627 loops=2)

35. 5,357.963 5,357.963 ↑ 1.2 2,493,913 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2019_02 (cost=0.00..521,359.59 rows=2,934,659 width=4) (actual time=0.779..5,357.963 rows=2,493,913 loops=2)

36. 6,483.427 6,483.427 ↑ 1.2 2,800,632 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2019_03 (cost=0.00..585,346.42 rows=3,293,742 width=4) (actual time=1.054..6,483.427 rows=2,800,632 loops=2)

37. 6,836.084 6,836.084 ↑ 1.2 2,769,801 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2019_04 (cost=0.00..577,980.84 rows=3,258,484 width=4) (actual time=0.672..6,836.084 rows=2,769,801 loops=2)

  • Heap Fetches: 104
38. 6,571.133 6,571.133 ↑ 1.2 2,757,512 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2019_06 (cost=0.00..576,314.45 rows=3,244,945 width=4) (actual time=0.958..6,571.133 rows=2,757,512 loops=2)

  • Heap Fetches: 35
39. 6,466.657 6,466.657 ↑ 1.2 2,970,926 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2019_08 (cost=0.00..624,792.59 rows=3,496,259 width=4) (actual time=1.331..6,466.657 rows=2,970,926 loops=2)

40. 6,063.039 6,063.039 ↑ 1.2 2,785,066 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2019_09 (cost=0.00..586,369.65 rows=3,276,965 width=4) (actual time=0.893..6,063.039 rows=2,785,066 loops=2)

41. 6,026.916 6,026.916 ↑ 1.2 2,857,160 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2019_10 (cost=0.00..599,231.35 rows=3,361,535 width=4) (actual time=0.727..6,026.916 rows=2,857,160 loops=2)

42. 766.025 766.025 ↑ 1.2 395,850 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2019_11 (cost=0.00..85,973.89 rows=465,689 width=4) (actual time=0.809..766.025 rows=395,850 loops=2)

43. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2019_12 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

44. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2020_01 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

45. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2020_02 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

46. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2020_03 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

47. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2020_04 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

48. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2020_05 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

49. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2020_06 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

50. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2020_07 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

51. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2020_08 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

52. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2020_09 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

53. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2020_10 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

54. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2020_11 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

55. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2020_12 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

56. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2021_01 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

57. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2021_02 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

58. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2021_03 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

59. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2021_04 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

60. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2021_05 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

61. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2021_06 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

62. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2021_07 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

63. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2021_08 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

64. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2021_09 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

65. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2021_10 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

66. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2021_11 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

67. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2021_12 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

68. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2022_01 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

69. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2022_02 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

70. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2022_03 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

71. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2022_04 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

72. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on progressive_customerservice_mart_call_fact_p2022_05 (cost=0.00..10.65 rows=65 width=4) (actual time=0.000..0.000 rows=0 loops=2)

73. 0.017 0.196 ↓ 1.0 50 2

Hash (cost=12.09..12.09 rows=49 width=15) (actual time=0.196..0.196 rows=50 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
74. 0.179 0.179 ↓ 1.0 50 2

Seq Scan on progressive_customerservice_mart_published_number (cost=0.00..12.09 rows=49 width=15) (actual time=0.039..0.179 rows=50 loops=2)

  • Filter: ((published_number IS NOT NULL) AND (published_number ~~ '%36%'::text))
  • Rows Removed by Filter: 605
Planning time : 929.429 ms
Execution time : 93,459.543 ms