explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DBBQ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.734 139.881 ↑ 1.0 20,000 1

Limit (cost=0.42..10,053.09 rows=20,000 width=242) (actual time=0.020..139.881 rows=20,000 loops=1)

2. 7.719 139.147 ↑ 273.8 20,000 1

Nested Loop (cost=0.42..2,751,947.09 rows=5,475,057 width=242) (actual time=0.019..139.147 rows=20,000 loops=1)

3. 4.181 13.417 ↑ 46.6 118,011 1

Append (cost=0.00..239,675.86 rows=5,494,657 width=198) (actual time=0.007..13.417 rows=118,011 loops=1)

4. 1.773 1.773 ↑ 1.0 21,285 1

Seq Scan on raws_00 r (cost=0.00..823.37 rows=21,337 width=198) (actual time=0.006..1.773 rows=21,285 loops=1)

5. 1.733 1.733 ↓ 1.0 21,598 1

Seq Scan on raws_01 r_1 (cost=0.00..834.90 rows=21,590 width=198) (actual time=0.004..1.733 rows=21,598 loops=1)

6. 1.668 1.668 ↑ 1.0 21,619 1

Seq Scan on raws_02 r_2 (cost=0.00..835.65 rows=21,665 width=198) (actual time=0.003..1.668 rows=21,619 loops=1)

7. 1.641 1.641 ↑ 1.0 21,458 1

Seq Scan on raws_03 r_3 (cost=0.00..828.96 rows=21,496 width=198) (actual time=0.003..1.641 rows=21,458 loops=1)

8. 1.629 1.629 ↑ 1.0 21,540 1

Seq Scan on raws_04 r_4 (cost=0.00..832.65 rows=21,565 width=198) (actual time=0.004..1.629 rows=21,540 loops=1)

9. 0.792 0.792 ↑ 2.1 10,511 1

Seq Scan on raws_05 r_5 (cost=0.00..832.78 rows=21,578 width=198) (actual time=0.003..0.792 rows=10,511 loops=1)

10. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_06 r_6 (cost=0.00..823.12 rows=21,312 width=198) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_07 r_7 (cost=0.00..826.14 rows=21,414 width=198) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_08 r_8 (cost=0.00..830.77 rows=21,477 width=199) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_09 r_9 (cost=0.00..820.42 rows=21,242 width=198) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_0a r_10 (cost=0.00..824.41 rows=21,341 width=198) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_0b r_11 (cost=0.00..831.38 rows=21,538 width=198) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_0c r_12 (cost=0.00..826.03 rows=21,403 width=198) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_0d r_13 (cost=0.00..827.51 rows=21,451 width=198) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_0e r_14 (cost=0.00..825.98 rows=21,398 width=198) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_0f r_15 (cost=0.00..820.66 rows=21,266 width=199) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_10 r_16 (cost=0.00..835.15 rows=21,615 width=198) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_11 r_17 (cost=0.00..828.60 rows=21,460 width=198) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_12 r_18 (cost=0.00..823.25 rows=21,325 width=198) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_13 r_19 (cost=0.00..832.88 rows=21,588 width=198) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_14 r_20 (cost=0.00..830.91 rows=21,491 width=198) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_15 r_21 (cost=0.00..840.83 rows=21,783 width=198) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_16 r_22 (cost=0.00..836.32 rows=21,632 width=199) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_17 r_23 (cost=0.00..819.17 rows=21,217 width=198) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_18 r_24 (cost=0.00..819.30 rows=21,230 width=198) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_19 r_25 (cost=0.00..830.02 rows=21,502 width=198) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_1a r_26 (cost=0.00..820.52 rows=21,252 width=198) (never executed)

31. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_1b r_27 (cost=0.00..827.20 rows=21,420 width=198) (never executed)

32. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_1c r_28 (cost=0.00..828.62 rows=21,462 width=198) (never executed)

33. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_1d r_29 (cost=0.00..818.82 rows=21,182 width=199) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_1e r_30 (cost=0.00..829.64 rows=21,464 width=199) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_1f r_31 (cost=0.00..827.21 rows=21,421 width=198) (never executed)

36. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_20 r_32 (cost=0.00..831.23 rows=21,523 width=198) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_21 r_33 (cost=0.00..835.44 rows=21,644 width=198) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_22 r_34 (cost=0.00..832.99 rows=21,599 width=198) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_23 r_35 (cost=0.00..827.10 rows=21,410 width=198) (never executed)

40. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_24 r_36 (cost=0.00..824.56 rows=21,356 width=198) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_25 r_37 (cost=0.00..834.17 rows=21,617 width=198) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_26 r_38 (cost=0.00..830.82 rows=21,482 width=199) (never executed)

43. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_27 r_39 (cost=0.00..835.21 rows=21,621 width=198) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_28 r_40 (cost=0.00..822.98 rows=21,298 width=198) (never executed)

45. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_29 r_41 (cost=0.00..825.71 rows=21,371 width=198) (never executed)

46. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_2a r_42 (cost=0.00..823.17 rows=21,317 width=198) (never executed)

47. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_2b r_43 (cost=0.00..828.52 rows=21,452 width=198) (never executed)

48. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_2c r_44 (cost=0.00..832.51 rows=21,551 width=198) (never executed)

49. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_2d r_45 (cost=0.00..835.05 rows=21,605 width=198) (never executed)

50. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_2e r_46 (cost=0.00..823.31 rows=21,331 width=198) (never executed)

51. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_2f r_47 (cost=0.00..830.12 rows=21,512 width=198) (never executed)

52. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_30 r_48 (cost=0.00..829.67 rows=21,467 width=199) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_31 r_49 (cost=0.00..818.99 rows=21,199 width=199) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_32 r_50 (cost=0.00..832.67 rows=21,567 width=198) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_33 r_51 (cost=0.00..839.35 rows=21,735 width=199) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_34 r_52 (cost=0.00..829.95 rows=21,495 width=199) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_35 r_53 (cost=0.00..828.94 rows=21,494 width=198) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_36 r_54 (cost=0.00..823.02 rows=21,302 width=198) (never executed)

59. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_37 r_55 (cost=0.00..823.34 rows=21,334 width=198) (never executed)

60. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_38 r_56 (cost=0.00..830.00 rows=21,500 width=198) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_39 r_57 (cost=0.00..832.45 rows=21,545 width=199) (never executed)

62. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_3a r_58 (cost=0.00..824.23 rows=21,323 width=199) (never executed)

63. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_3b r_59 (cost=0.00..837.92 rows=21,692 width=199) (never executed)

64. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_3c r_60 (cost=0.00..820.44 rows=21,244 width=198) (never executed)

65. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_3d r_61 (cost=0.00..828.42 rows=21,442 width=199) (never executed)

66. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_3e r_62 (cost=0.00..829.74 rows=21,474 width=198) (never executed)

67. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_3f r_63 (cost=0.00..824.45 rows=21,345 width=198) (never executed)

68. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_40 r_64 (cost=0.00..822.88 rows=21,288 width=198) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_41 r_65 (cost=0.00..826.91 rows=21,391 width=199) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_42 r_66 (cost=0.00..833.93 rows=21,593 width=198) (never executed)

71. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_43 r_67 (cost=0.00..835.42 rows=21,642 width=199) (never executed)

72. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_44 r_68 (cost=0.00..816.63 rows=21,163 width=198) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_45 r_69 (cost=0.00..834.01 rows=21,601 width=199) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_46 r_70 (cost=0.00..817.55 rows=21,155 width=199) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_47 r_71 (cost=0.00..823.36 rows=21,336 width=198) (never executed)

76. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_48 r_72 (cost=0.00..823.32 rows=21,332 width=198) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_49 r_73 (cost=0.00..820.42 rows=21,242 width=199) (never executed)

78. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_4a r_74 (cost=0.00..836.51 rows=21,651 width=198) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_4b r_75 (cost=0.00..836.37 rows=21,637 width=199) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_4c r_76 (cost=0.00..825.85 rows=21,385 width=198) (never executed)

81. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_4d r_77 (cost=0.00..825.90 rows=21,390 width=198) (never executed)

82. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_4e r_78 (cost=0.00..833.81 rows=21,581 width=198) (never executed)

83. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_4f r_79 (cost=0.00..835.21 rows=21,621 width=199) (never executed)

84. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_50 r_80 (cost=0.00..834.03 rows=21,603 width=198) (never executed)

85. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_51 r_81 (cost=0.00..824.56 rows=21,356 width=198) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_52 r_82 (cost=0.00..827.12 rows=21,412 width=198) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_53 r_83 (cost=0.00..817.73 rows=21,173 width=198) (never executed)

88. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_54 r_84 (cost=0.00..833.63 rows=21,563 width=198) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_55 r_85 (cost=0.00..821.67 rows=21,267 width=198) (never executed)

90. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_56 r_86 (cost=0.00..829.85 rows=21,485 width=198) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_57 r_87 (cost=0.00..829.82 rows=21,482 width=198) (never executed)

92. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_58 r_88 (cost=0.00..831.10 rows=21,510 width=198) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_59 r_89 (cost=0.00..831.26 rows=21,526 width=198) (never executed)

94. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_5a r_90 (cost=0.00..824.25 rows=21,325 width=199) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_5b r_91 (cost=0.00..831.31 rows=21,531 width=198) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_5c r_92 (cost=0.00..826.86 rows=21,386 width=199) (never executed)

97. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_5d r_93 (cost=0.00..832.35 rows=21,535 width=199) (never executed)

98. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_5e r_94 (cost=0.00..830.06 rows=21,506 width=198) (never executed)

99. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_5f r_95 (cost=0.00..826.00 rows=21,400 width=198) (never executed)

100. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_60 r_96 (cost=0.00..832.71 rows=21,571 width=199) (never executed)

101. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_61 r_97 (cost=0.00..829.82 rows=21,482 width=198) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_62 r_98 (cost=0.00..837.78 rows=21,678 width=198) (never executed)

103. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_63 r_99 (cost=0.00..832.68 rows=21,568 width=198) (never executed)

104. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_64 r_100 (cost=0.00..821.81 rows=21,281 width=199) (never executed)

105. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_65 r_101 (cost=0.00..820.59 rows=21,259 width=198) (never executed)

106. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_66 r_102 (cost=0.00..821.57 rows=21,257 width=199) (never executed)

107. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_67 r_103 (cost=0.00..840.84 rows=21,784 width=198) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_68 r_104 (cost=0.00..827.22 rows=21,422 width=198) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_69 r_105 (cost=0.00..828.70 rows=21,470 width=198) (never executed)

110. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_6a r_106 (cost=0.00..830.89 rows=21,489 width=198) (never executed)

111. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_6b r_107 (cost=0.00..828.65 rows=21,465 width=198) (never executed)

112. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_6c r_108 (cost=0.00..827.04 rows=21,404 width=199) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_6d r_109 (cost=0.00..822.97 rows=21,297 width=199) (never executed)

114. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_6e r_110 (cost=0.00..833.93 rows=21,593 width=198) (never executed)

115. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_6f r_111 (cost=0.00..836.53 rows=21,653 width=198) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_70 r_112 (cost=0.00..828.73 rows=21,473 width=198) (never executed)

117. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_71 r_113 (cost=0.00..835.16 rows=21,616 width=199) (never executed)

118. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_72 r_114 (cost=0.00..824.53 rows=21,353 width=198) (never executed)

119. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_73 r_115 (cost=0.00..828.25 rows=21,425 width=199) (never executed)

120. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_74 r_116 (cost=0.00..833.78 rows=21,578 width=199) (never executed)

121. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_75 r_117 (cost=0.00..826.11 rows=21,411 width=198) (never executed)

122. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_76 r_118 (cost=0.00..836.72 rows=21,672 width=198) (never executed)

123. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_77 r_119 (cost=0.00..828.77 rows=21,477 width=198) (never executed)

124. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_78 r_120 (cost=0.00..838.05 rows=21,705 width=199) (never executed)

125. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_79 r_121 (cost=0.00..823.12 rows=21,312 width=198) (never executed)

126. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_7a r_122 (cost=0.00..833.99 rows=21,599 width=198) (never executed)

127. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_7b r_123 (cost=0.00..824.45 rows=21,345 width=199) (never executed)

128. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_7c r_124 (cost=0.00..840.81 rows=21,781 width=198) (never executed)

129. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_7d r_125 (cost=0.00..828.32 rows=21,432 width=198) (never executed)

130. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_7e r_126 (cost=0.00..835.66 rows=21,666 width=198) (never executed)

131. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_7f r_127 (cost=0.00..815.18 rows=21,118 width=199) (never executed)

132. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_80 r_128 (cost=0.00..828.45 rows=21,445 width=199) (never executed)

133. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_81 r_129 (cost=0.00..832.46 rows=21,546 width=198) (never executed)

134. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_82 r_130 (cost=0.00..827.29 rows=21,429 width=198) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_83 r_131 (cost=0.00..835.31 rows=21,631 width=198) (never executed)

136. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_84 r_132 (cost=0.00..828.81 rows=21,481 width=198) (never executed)

137. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_85 r_133 (cost=0.00..825.77 rows=21,377 width=198) (never executed)

138. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_86 r_134 (cost=0.00..825.98 rows=21,398 width=198) (never executed)

139. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_87 r_135 (cost=0.00..825.32 rows=21,332 width=199) (never executed)

140. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_88 r_136 (cost=0.00..828.58 rows=21,458 width=198) (never executed)

141. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_89 r_137 (cost=0.00..824.29 rows=21,329 width=199) (never executed)

142. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_8a r_138 (cost=0.00..832.58 rows=21,558 width=198) (never executed)

143. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_8b r_139 (cost=0.00..832.66 rows=21,566 width=198) (never executed)

144. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_8c r_140 (cost=0.00..820.49 rows=21,249 width=198) (never executed)

145. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_8d r_141 (cost=0.00..822.15 rows=21,315 width=198) (never executed)

146. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_8e r_142 (cost=0.00..828.34 rows=21,434 width=198) (never executed)

147. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_8f r_143 (cost=0.00..824.45 rows=21,345 width=198) (never executed)

148. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_90 r_144 (cost=0.00..820.32 rows=21,232 width=198) (never executed)

149. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_91 r_145 (cost=0.00..833.85 rows=21,585 width=198) (never executed)

150. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_92 r_146 (cost=0.00..835.52 rows=21,652 width=198) (never executed)

151. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_93 r_147 (cost=0.00..828.59 rows=21,459 width=198) (never executed)

152. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_94 r_148 (cost=0.00..839.32 rows=21,732 width=198) (never executed)

153. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_95 r_149 (cost=0.00..831.46 rows=21,546 width=198) (never executed)

154. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_96 r_150 (cost=0.00..832.22 rows=21,522 width=199) (never executed)

155. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_97 r_151 (cost=0.00..835.17 rows=21,617 width=198) (never executed)

156. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_98 r_152 (cost=0.00..831.21 rows=21,521 width=199) (never executed)

157. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_99 r_153 (cost=0.00..836.46 rows=21,646 width=199) (never executed)

158. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_9a r_154 (cost=0.00..828.54 rows=21,454 width=198) (never executed)

159. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_9b r_155 (cost=0.00..831.68 rows=21,568 width=198) (never executed)

160. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_9c r_156 (cost=0.00..831.22 rows=21,522 width=199) (never executed)

161. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_9d r_157 (cost=0.00..837.04 rows=21,704 width=198) (never executed)

162. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_9e r_158 (cost=0.00..826.16 rows=21,416 width=198) (never executed)

163. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_9f r_159 (cost=0.00..828.82 rows=21,482 width=198) (never executed)

164. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a0 r_160 (cost=0.00..827.09 rows=21,409 width=198) (never executed)

165. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a1 r_161 (cost=0.00..835.32 rows=21,632 width=198) (never executed)

166. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a2 r_162 (cost=0.00..821.92 rows=21,292 width=198) (never executed)

167. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a3 r_163 (cost=0.00..831.17 rows=21,517 width=198) (never executed)

168. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a4 r_164 (cost=0.00..836.65 rows=21,665 width=198) (never executed)

169. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a5 r_165 (cost=0.00..818.03 rows=21,203 width=198) (never executed)

170. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a6 r_166 (cost=0.00..833.93 rows=21,593 width=198) (never executed)

171. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a7 r_167 (cost=0.00..829.88 rows=21,488 width=199) (never executed)

172. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a8 r_168 (cost=0.00..832.43 rows=21,543 width=199) (never executed)

173. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a9 r_169 (cost=0.00..825.94 rows=21,394 width=198) (never executed)

174. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_aa r_170 (cost=0.00..826.00 rows=21,400 width=198) (never executed)

175. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ab r_171 (cost=0.00..835.40 rows=21,640 width=198) (never executed)

176. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ac r_172 (cost=0.00..827.13 rows=21,413 width=199) (never executed)

177. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ad r_173 (cost=0.00..833.97 rows=21,597 width=198) (never executed)

178. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ae r_174 (cost=0.00..823.19 rows=21,319 width=198) (never executed)

179. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_af r_175 (cost=0.00..832.68 rows=21,568 width=198) (never executed)

180. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b0 r_176 (cost=0.00..825.81 rows=21,381 width=198) (never executed)

181. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b1 r_177 (cost=0.00..828.27 rows=21,427 width=199) (never executed)

182. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b2 r_178 (cost=0.00..833.87 rows=21,587 width=199) (never executed)

183. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b3 r_179 (cost=0.00..840.57 rows=21,757 width=199) (never executed)

184. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b4 r_180 (cost=0.00..834.04 rows=21,604 width=198) (never executed)

185. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b5 r_181 (cost=0.00..828.62 rows=21,462 width=198) (never executed)

186. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b6 r_182 (cost=0.00..821.70 rows=21,270 width=199) (never executed)

187. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b7 r_183 (cost=0.00..828.40 rows=21,440 width=199) (never executed)

188. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b8 r_184 (cost=0.00..832.76 rows=21,576 width=198) (never executed)

189. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b9 r_185 (cost=0.00..832.42 rows=21,542 width=199) (never executed)

190. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ba r_186 (cost=0.00..825.88 rows=21,388 width=198) (never executed)

191. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_bb r_187 (cost=0.00..829.96 rows=21,496 width=198) (never executed)

192. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_bc r_188 (cost=0.00..819.24 rows=21,224 width=198) (never executed)

193. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_bd r_189 (cost=0.00..826.96 rows=21,396 width=199) (never executed)

194. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_be r_190 (cost=0.00..816.92 rows=21,192 width=198) (never executed)

195. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_bf r_191 (cost=0.00..823.39 rows=21,339 width=198) (never executed)

196. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c0 r_192 (cost=0.00..829.95 rows=21,495 width=198) (never executed)

197. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c1 r_193 (cost=0.00..828.33 rows=21,433 width=199) (never executed)

198. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c2 r_194 (cost=0.00..831.10 rows=21,510 width=198) (never executed)

199. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c3 r_195 (cost=0.00..827.13 rows=21,413 width=198) (never executed)

200. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c4 r_196 (cost=0.00..830.08 rows=21,508 width=198) (never executed)

201. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c5 r_197 (cost=0.00..825.99 rows=21,399 width=198) (never executed)

202. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c6 r_198 (cost=0.00..827.24 rows=21,424 width=198) (never executed)

203. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c7 r_199 (cost=0.00..831.50 rows=21,550 width=198) (never executed)

204. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c8 r_200 (cost=0.00..830.82 rows=21,482 width=199) (never executed)

205. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c9 r_201 (cost=0.00..836.60 rows=21,660 width=198) (never executed)

206. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ca r_202 (cost=0.00..829.69 rows=21,469 width=199) (never executed)

207. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_cb r_203 (cost=0.00..836.19 rows=21,619 width=199) (never executed)

208. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_cc r_204 (cost=0.00..838.04 rows=21,704 width=198) (never executed)

209. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_cd r_205 (cost=0.00..831.25 rows=21,525 width=198) (never executed)

210. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ce r_206 (cost=0.00..828.18 rows=21,418 width=198) (never executed)

211. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_cf r_207 (cost=0.00..816.84 rows=21,184 width=198) (never executed)

212. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d0 r_208 (cost=0.00..832.17 rows=21,517 width=198) (never executed)

213. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d1 r_209 (cost=0.00..828.70 rows=21,470 width=198) (never executed)

214. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d2 r_210 (cost=0.00..832.46 rows=21,546 width=198) (never executed)

215. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d3 r_211 (cost=0.00..821.68 rows=21,268 width=199) (never executed)

216. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d4 r_212 (cost=0.00..834.99 rows=21,599 width=199) (never executed)

217. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d5 r_213 (cost=0.00..829.43 rows=21,443 width=199) (never executed)

218. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d6 r_214 (cost=0.00..823.22 rows=21,322 width=198) (never executed)

219. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d7 r_215 (cost=0.00..830.15 rows=21,515 width=198) (never executed)

220. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d8 r_216 (cost=0.00..827.04 rows=21,404 width=198) (never executed)

221. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d9 r_217 (cost=0.00..825.68 rows=21,368 width=199) (never executed)

222. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_da r_218 (cost=0.00..829.64 rows=21,464 width=199) (never executed)

223. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_db r_219 (cost=0.00..822.93 rows=21,293 width=199) (never executed)

224. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_dc r_220 (cost=0.00..843.41 rows=21,841 width=198) (never executed)

225. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_dd r_221 (cost=0.00..824.54 rows=21,354 width=199) (never executed)

226. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_de r_222 (cost=0.00..824.26 rows=21,326 width=199) (never executed)

227. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_df r_223 (cost=0.00..835.39 rows=21,639 width=198) (never executed)

228. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e0 r_224 (cost=0.00..820.56 rows=21,256 width=198) (never executed)

229. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e1 r_225 (cost=0.00..830.04 rows=21,504 width=198) (never executed)

230. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e2 r_226 (cost=0.00..827.17 rows=21,417 width=198) (never executed)

231. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e3 r_227 (cost=0.00..825.83 rows=21,383 width=198) (never executed)

232. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e4 r_228 (cost=0.00..820.45 rows=21,245 width=198) (never executed)

233. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e5 r_229 (cost=0.00..828.27 rows=21,427 width=199) (never executed)

234. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e6 r_230 (cost=0.00..826.13 rows=21,413 width=198) (never executed)

235. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e7 r_231 (cost=0.00..825.96 rows=21,396 width=198) (never executed)

236. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e8 r_232 (cost=0.00..830.12 rows=21,512 width=198) (never executed)

237. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e9 r_233 (cost=0.00..832.38 rows=21,538 width=198) (never executed)

238. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ea r_234 (cost=0.00..824.20 rows=21,320 width=198) (never executed)

239. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_eb r_235 (cost=0.00..836.63 rows=21,663 width=198) (never executed)

240. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ec r_236 (cost=0.00..838.03 rows=21,703 width=198) (never executed)

241. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ed r_237 (cost=0.00..832.47 rows=21,547 width=199) (never executed)

242. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ee r_238 (cost=0.00..825.63 rows=21,363 width=198) (never executed)

243. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ef r_239 (cost=0.00..825.87 rows=21,387 width=199) (never executed)

244. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f0 r_240 (cost=0.00..836.38 rows=21,638 width=199) (never executed)

245. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f1 r_241 (cost=0.00..832.72 rows=21,572 width=198) (never executed)

246. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f2 r_242 (cost=0.00..831.16 rows=21,516 width=199) (never executed)

247. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f3 r_243 (cost=0.00..821.84 rows=21,284 width=198) (never executed)

248. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f4 r_244 (cost=0.00..829.86 rows=21,486 width=198) (never executed)

249. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f5 r_245 (cost=0.00..833.87 rows=21,587 width=198) (never executed)

250. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f6 r_246 (cost=0.00..827.15 rows=21,415 width=198) (never executed)

251. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f7 r_247 (cost=0.00..820.15 rows=21,215 width=199) (never executed)

252. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f8 r_248 (cost=0.00..827.11 rows=21,411 width=198) (never executed)

253. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f9 r_249 (cost=0.00..824.36 rows=21,336 width=199) (never executed)

254. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_fa r_250 (cost=0.00..827.33 rows=21,433 width=198) (never executed)

255. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_fb r_251 (cost=0.00..825.70 rows=21,370 width=199) (never executed)

256. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_fc r_252 (cost=0.00..833.80 rows=21,580 width=199) (never executed)

257. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_fd r_253 (cost=0.00..823.56 rows=21,356 width=198) (never executed)

258. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_fe r_254 (cost=0.00..834.13 rows=21,613 width=198) (never executed)

259. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ff r_255 (cost=0.00..834.36 rows=21,636 width=198) (never executed)

260. 118.011 118.011 ↓ 0.0 0 118,011

Index Scan using fast_search_domains_b3_raw_id_idx on fast_search_domains_b3 e (cost=0.42..0.45 rows=1 width=44) (actual time=0.001..0.001 rows=0 loops=118,011)

  • Index Cond: (raw_id = r.id)
  • Filter: (domain = '\xb33960790a6de22ca95a61c6d1310b3487304529cb0af6f3e9b80d2e5ddf76b8'::bytea)
  • Rows Removed by Filter: 0
Planning time : 3.046 ms
Execution time : 140.524 ms