explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AWDU

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 46.451 1,993.032 ↓ 153.5 49,270 1

Gather (cost=9,836.99..411,020.34 rows=321 width=162) (actual time=300.921..1,993.032 rows=49,270 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Functions: 42
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 6.561 ms, Inlining 0.000 ms, Optimization 3.029 ms, Emission 45.301 ms, Total 54.891 ms
2. 989.799 1,946.581 ↓ 122.6 16,423 3 / 3

Parallel Hash Join (cost=8,836.99..409,988.24 rows=134 width=162) (actual time=1,386.417..1,946.581 rows=16,423 loops=3)

  • Hash Cond: ((guia_2019_04.pagamento_id = pagamento.id) AND (guia_2019_04.data_pagamento = pagamento.data_pagamento))
3. 305.304 948.273 ↑ 1.3 4,970,420 3 / 3

Parallel Append (cost=0.00..368,450.18 rows=6,228,776 width=112) (actual time=0.030..948.273 rows=4,970,420 loops=3)

4. 48.329 48.329 ↓ 2.4 1,102,530 1 / 3

Parallel Seq Scan on guia_2019_04 (cost=0.00..24,874.88 rows=459,388 width=113) (actual time=0.031..144.987 rows=1,102,530 loops=1)

5. 46.347 46.347 ↓ 2.4 1,038,375 1 / 3

Parallel Seq Scan on guia_2018_10 (cost=0.00..23,285.56 rows=432,656 width=110) (actual time=0.045..139.042 rows=1,038,375 loops=1)

6. 39.919 39.919 ↓ 2.4 969,345 1 / 3

Parallel Seq Scan on guia_2018_07 (cost=0.00..21,718.94 rows=403,894 width=114) (actual time=0.027..119.757 rows=969,345 loops=1)

7. 38.026 38.026 ↓ 2.4 957,775 1 / 3

Parallel Seq Scan on guia_2019_09 (cost=0.00..21,413.73 rows=399,073 width=109) (actual time=0.033..114.079 rows=957,775 loops=1)

8. 37.405 37.405 ↓ 2.4 947,440 1 / 3

Parallel Seq Scan on guia_2018_11 (cost=0.00..21,272.67 rows=394,767 width=111) (actual time=0.027..112.215 rows=947,440 loops=1)

9. 37.028 37.028 ↓ 2.4 937,625 1 / 3

Parallel Seq Scan on guia_2019_07 (cost=0.00..21,197.77 rows=390,677 width=111) (actual time=0.028..111.083 rows=937,625 loops=1)

10. 38.212 38.212 ↓ 2.4 921,180 1 / 3

Parallel Seq Scan on guia_2018_09 (cost=0.00..20,771.25 rows=383,825 width=115) (actual time=0.030..114.635 rows=921,180 loops=1)

11. 47.325 47.325 ↓ 2.4 916,630 1 / 3

Parallel Seq Scan on guia_2018_12 (cost=0.00..20,485.29 rows=381,929 width=110) (actual time=0.027..141.974 rows=916,630 loops=1)

12. 37.268 37.268 ↓ 2.4 902,005 1 / 3

Parallel Seq Scan on guia_2019_06 (cost=0.00..20,340.35 rows=375,835 width=110) (actual time=0.032..111.804 rows=902,005 loops=1)

13. 35.368 35.368 ↓ 2.4 889,460 1 / 3

Parallel Seq Scan on guia_2019_10 (cost=0.00..20,119.08 rows=370,608 width=116) (actual time=0.036..106.105 rows=889,460 loops=1)

14. 34.494 34.494 ↑ 1.3 290,983 3 / 3

Parallel Seq Scan on guia_2019_02 (cost=0.00..19,692.29 rows=363,729 width=111) (actual time=0.023..34.494 rows=290,983 loops=3)

15. 35.124 35.124 ↓ 2.4 862,160 1 / 3

Parallel Seq Scan on guia_2019_03 (cost=0.00..19,414.33 rows=359,233 width=111) (actual time=0.021..105.373 rows=862,160 loops=1)

16. 33.329 33.329 ↓ 2.4 835,705 1 / 3

Parallel Seq Scan on guia_2019_08 (cost=0.00..18,693.10 rows=348,210 width=109) (actual time=0.006..99.988 rows=835,705 loops=1)

17. 32.823 32.823 ↓ 2.4 803,075 1 / 3

Parallel Seq Scan on guia_2018_08 (cost=0.00..18,114.15 rows=334,615 width=115) (actual time=0.007..98.470 rows=803,075 loops=1)

18. 31.186 31.186 ↓ 2.4 787,540 1 / 3

Parallel Seq Scan on guia_2019_01 (cost=0.00..17,712.42 rows=328,142 width=110) (actual time=0.006..93.559 rows=787,540 loops=1)

19. 32.565 32.565 ↓ 2.4 728,065 1 / 3

Parallel Seq Scan on guia_2019_05 (cost=0.00..16,423.60 rows=303,360 width=109) (actual time=0.004..97.694 rows=728,065 loops=1)

20. 17.549 17.549 ↓ 2.4 290,810 1 / 3

Parallel Seq Scan on guia_2019_11 (cost=0.00..6,450.71 rows=121,171 width=115) (actual time=0.010..52.647 rows=290,810 loops=1)

21. 5.605 5.605 ↓ 1.7 45,825 1 / 3

Parallel Seq Scan on guia_2018_05 (cost=0.00..1,021.56 rows=26,956 width=118) (actual time=0.352..16.816 rows=45,825 loops=1)

22. 6.020 6.020 ↓ 1.7 45,630 1 / 3

Parallel Seq Scan on guia_2018_04 (cost=0.00..1,017.41 rows=26,841 width=104) (actual time=0.307..18.060 rows=45,630 loops=1)

23. 4.170 4.170 ↓ 1.7 28,470 1 / 3

Parallel Seq Scan on guia_2018_06 (cost=0.00..634.47 rows=16,747 width=118) (actual time=1.692..12.509 rows=28,470 loops=1)

24. 2.025 2.025 ↓ 1.7 13,195 1 / 3

Parallel Seq Scan on guia_2018_01 (cost=0.00..294.62 rows=7,762 width=118) (actual time=0.393..6.075 rows=13,195 loops=1)

25. 1.201 1.201 ↓ 1.7 6,565 1 / 3

Parallel Seq Scan on guia_2018_02 (cost=0.00..146.62 rows=3,862 width=118) (actual time=0.337..3.603 rows=6,565 loops=1)

26. 0.938 0.938 ↓ 1.7 5,590 1 / 3

Parallel Seq Scan on guia_2018_03 (cost=0.00..124.88 rows=3,288 width=104) (actual time=0.335..2.814 rows=5,590 loops=1)

27. 0.701 0.701 ↓ 1.7 3,250 1 / 3

Parallel Seq Scan on guia_2017_12 (cost=0.00..73.12 rows=1,912 width=118) (actual time=0.497..2.102 rows=3,250 loops=1)

28. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2005_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

29. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2005_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

30. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2005_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

31. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2005_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

32. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2005_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

33. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2005_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

34. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2005_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

35. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2005_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

36. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2005_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

37. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2005_10 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

38. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2005_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

39. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2005_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

40. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2006_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

41. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2006_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

42. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2006_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

43. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2006_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

44. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2006_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

45. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2006_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

46. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2006_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

47. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2006_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

48. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2006_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

49. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2006_10 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

50. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2006_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

51. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2006_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

52. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2007_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

53. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2007_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

54. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2007_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

55. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2007_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

56. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2007_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

57. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2007_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

58. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2007_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

59. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2007_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

60. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2007_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

61. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2007_10 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

62. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2007_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

63. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2007_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

64. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2008_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

65. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2008_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

66. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2008_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

67. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2008_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

68. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2008_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

69. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2008_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

70. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2008_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

71. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2008_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

72. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2008_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

73. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2008_10 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

74. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2008_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

75. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2008_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

76. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2009_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

77. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2009_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

78. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2009_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

79. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2009_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

80. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2009_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

81. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2009_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

82. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2009_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

83. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2009_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

84. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2009_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

85. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2009_10 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

86. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2009_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

87. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2009_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

88. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2010_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

89. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2010_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

90. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2010_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

91. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2010_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

92. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2010_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

93. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2010_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

94. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2010_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

95. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2010_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

96. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2010_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

97. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2010_10 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

98. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2010_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

99. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2010_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

100. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2011_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

101. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2011_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

102. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2011_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

103. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2011_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

104. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2011_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

105. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2011_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

106. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2011_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

107. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2011_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

108. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2011_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

109. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2011_10 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

110. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2011_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

111. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2011_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

112. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2012_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

113. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2012_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

114. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2012_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

115. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2012_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

116. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2012_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

117. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2012_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

118. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2012_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

119. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2012_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

120. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2012_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

121. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2012_10 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

122. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2012_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

123. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2012_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

124. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2013_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

125. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2013_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

126. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2013_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

127. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2013_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

128. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2013_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

129. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2013_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

130. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2013_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

131. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2013_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

132. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2013_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

133. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2013_10 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

134. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2013_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

135. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2013_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

136. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2014_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

137. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2014_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

138. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2014_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

139. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2014_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

140. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2014_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

141. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2014_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

142. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2014_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

143. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2014_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

144. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2014_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

145. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2014_10 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

146. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2014_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

147. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2014_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

148. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2015_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

149. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2015_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

150. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2015_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

151. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2015_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

152. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2015_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

153. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2015_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

154. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2015_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

155. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2015_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

156. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2015_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

157. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2015_10 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

158. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2015_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

159. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2015_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

160. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2016_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

161. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2016_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

162. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2016_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

163. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2016_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

164. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2016_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

165. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2016_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

166. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2016_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

167. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2016_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

168. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2016_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

169. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2016_10 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.001 rows=0 loops=1)

170. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2016_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

171. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2016_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

172. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2017_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

173. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2017_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

174. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2017_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

175. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2017_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

176. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2017_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

177. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2017_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

178. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2017_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

179. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2017_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

180. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2017_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

181. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2017_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

182. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2019_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

183. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2020_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

184. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2020_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

185. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2020_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

186. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2020_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

187. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2020_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

188. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2020_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

189. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2020_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

190. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2020_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

191. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2020_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

192. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2020_10 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

193. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2020_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

194. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2020_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

195. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2021_01 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

196. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2021_02 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

197. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2021_03 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

198. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2021_04 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

199. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2021_05 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

200. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2021_06 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

201. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2021_07 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

202. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2021_08 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

203. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2021_09 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

204. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2021_10 (cost=0.00..11.24 rows=124 width=345) (actual time=0.001..0.001 rows=0 loops=1)

205. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2021_11 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.001 rows=0 loops=1)

206. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on guia_2021_12 (cost=0.00..11.24 rows=124 width=345) (actual time=0.000..0.000 rows=0 loops=1)

207. 0.006 0.006 ↓ 1.7 65 1 / 3

Parallel Seq Scan on guia_2017_10 (cost=0.00..2.38 rows=38 width=118) (actual time=0.011..0.017 rows=65 loops=1)

208. 0.345 8.509 ↑ 2.6 1,192 3 / 3

Parallel Hash (cost=8,789.87..8,789.87 rows=3,141 width=51) (actual time=8.508..8.509 rows=1,192 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 384kB
209. 7.732 8.164 ↓ 1.1 3,575 1 / 3

Parallel Bitmap Heap Scan on pagamento (cost=367.55..8,789.87 rows=3,141 width=51) (actual time=16.316..24.492 rows=3,575 loops=1)

  • Recheck Cond: ((data_pagamento >= '2019-05-10'::date) AND (data_pagamento <= '2019-05-20'::date))
  • Filter: (convenio_id = 72)
  • Rows Removed by Filter: 11635
  • Heap Blocks: exact=5054
210. 0.432 0.432 ↑ 1.1 15,210 1 / 3

Bitmap Index Scan on pagamento_data_pagamento (cost=0.00..365.67 rows=17,324 width=0) (actual time=1.296..1.297 rows=15,210 loops=1)

  • Index Cond: ((data_pagamento >= '2019-05-10'::date) AND (data_pagamento <= '2019-05-20'::date))
Execution time : 1,997.368 ms