explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BA2u : Optimization for: Optimization for: plan #DBBQ; plan #DfOA

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 8.211 2,131.500 ↑ 1.0 200,000 1

Limit (cost=39,927.64..62,693.85 rows=200,000 width=243) (actual time=174.883..2,131.500 rows=200,000 loops=1)

2. 1,239.377 2,123.289 ↑ 29.5 200,000 1

Hash Right Join (cost=39,927.64..710,692.33 rows=5,892,633 width=243) (actual time=174.882..2,123.289 rows=200,000 loops=1)

  • Hash Cond: (r.id = e.raw_id)
3. 210.093 709.140 ↑ 1.0 5,908,495 1

Append (cost=0.00..258,133.89 rows=5,913,726 width=199) (actual time=0.006..709.140 rows=5,908,495 loops=1)

4. 1.883 1.883 ↑ 1.0 22,932 1

Seq Scan on raws_00 r (cost=0.00..887.67 rows=22,967 width=199) (actual time=0.005..1.883 rows=22,932 loops=1)

5. 1.843 1.843 ↑ 1.0 23,148 1

Seq Scan on raws_01 r_1 (cost=0.00..895.59 rows=23,159 width=198) (actual time=0.004..1.843 rows=23,148 loops=1)

6. 1.840 1.840 ↑ 1.0 23,229 1

Seq Scan on raws_02 r_2 (cost=0.00..898.77 rows=23,277 width=198) (actual time=0.004..1.840 rows=23,229 loops=1)

7. 1.883 1.883 ↑ 1.0 23,109 1

Seq Scan on raws_03 r_3 (cost=0.00..893.31 rows=23,131 width=198) (actual time=0.004..1.883 rows=23,109 loops=1)

8. 1.940 1.940 ↑ 1.0 23,246 1

Seq Scan on raws_04 r_4 (cost=0.00..898.49 rows=23,249 width=199) (actual time=0.003..1.940 rows=23,246 loops=1)

9. 1.843 1.843 ↑ 1.0 23,175 1

Seq Scan on raws_05 r_5 (cost=0.00..897.33 rows=23,233 width=199) (actual time=0.003..1.843 rows=23,175 loops=1)

10. 1.829 1.829 ↑ 1.0 22,913 1

Seq Scan on raws_06 r_6 (cost=0.00..886.54 rows=22,954 width=198) (actual time=0.004..1.829 rows=22,913 loops=1)

11. 1.857 1.857 ↑ 1.0 23,049 1

Seq Scan on raws_07 r_7 (cost=0.00..890.49 rows=23,049 width=198) (actual time=0.003..1.857 rows=23,049 loops=1)

12. 1.871 1.871 ↓ 1.0 23,095 1

Seq Scan on raws_08 r_8 (cost=0.00..892.81 rows=23,081 width=199) (actual time=0.004..1.871 rows=23,095 loops=1)

13. 1.826 1.826 ↑ 1.0 22,799 1

Seq Scan on raws_09 r_9 (cost=0.00..882.13 rows=22,813 width=199) (actual time=0.004..1.826 rows=22,799 loops=1)

14. 1.804 1.804 ↑ 1.0 23,001 1

Seq Scan on raws_0a r_10 (cost=0.00..890.30 rows=23,030 width=199) (actual time=0.003..1.804 rows=23,001 loops=1)

15. 1.864 1.864 ↑ 1.0 23,112 1

Seq Scan on raws_0b r_11 (cost=0.00..894.53 rows=23,153 width=199) (actual time=0.003..1.864 rows=23,112 loops=1)

16. 1.904 1.904 ↑ 1.0 23,004 1

Seq Scan on raws_0c r_12 (cost=0.00..890.56 rows=23,056 width=199) (actual time=0.003..1.904 rows=23,004 loops=1)

17. 1.816 1.816 ↑ 1.0 23,041 1

Seq Scan on raws_0d r_13 (cost=0.00..890.61 rows=23,061 width=199) (actual time=0.003..1.816 rows=23,041 loops=1)

18. 1.784 1.784 ↑ 1.0 22,993 1

Seq Scan on raws_0e r_14 (cost=0.00..888.97 rows=22,997 width=199) (actual time=0.004..1.784 rows=22,993 loops=1)

19. 1.808 1.808 ↑ 1.0 22,912 1

Seq Scan on raws_0f r_15 (cost=0.00..886.22 rows=22,922 width=199) (actual time=0.003..1.808 rows=22,912 loops=1)

20. 1.808 1.808 ↑ 1.0 23,221 1

Seq Scan on raws_10 r_16 (cost=0.00..898.56 rows=23,256 width=198) (actual time=0.003..1.808 rows=23,221 loops=1)

21. 1.803 1.803 ↓ 1.0 23,069 1

Seq Scan on raws_11 r_17 (cost=0.00..891.63 rows=23,063 width=199) (actual time=0.003..1.803 rows=23,069 loops=1)

22. 1.812 1.812 ↑ 1.0 22,983 1

Seq Scan on raws_12 r_18 (cost=0.00..888.96 rows=22,996 width=199) (actual time=0.003..1.812 rows=22,983 loops=1)

23. 1.805 1.805 ↑ 1.0 23,167 1

Seq Scan on raws_13 r_19 (cost=0.00..895.90 rows=23,190 width=198) (actual time=0.003..1.805 rows=23,167 loops=1)

24. 1.784 1.784 ↑ 1.0 23,170 1

Seq Scan on raws_14 r_20 (cost=0.00..897.00 rows=23,200 width=198) (actual time=0.004..1.784 rows=23,170 loops=1)

25. 1.845 1.845 ↑ 1.0 23,429 1

Seq Scan on raws_15 r_21 (cost=0.00..906.52 rows=23,452 width=198) (actual time=0.003..1.845 rows=23,429 loops=1)

26. 1.821 1.821 ↑ 1.0 23,221 1

Seq Scan on raws_16 r_22 (cost=0.00..898.22 rows=23,222 width=199) (actual time=0.003..1.821 rows=23,221 loops=1)

27. 1.786 1.786 ↓ 1.0 22,914 1

Seq Scan on raws_17 r_23 (cost=0.00..885.00 rows=22,900 width=198) (actual time=0.004..1.786 rows=22,914 loops=1)

28. 1.779 1.779 ↑ 1.0 22,894 1

Seq Scan on raws_18 r_24 (cost=0.00..885.17 rows=22,917 width=198) (actual time=0.003..1.779 rows=22,894 loops=1)

29. 1.853 1.853 ↑ 1.0 23,041 1

Seq Scan on raws_19 r_25 (cost=0.00..891.67 rows=23,067 width=199) (actual time=0.004..1.853 rows=23,041 loops=1)

30. 1.768 1.768 ↑ 1.0 22,820 1

Seq Scan on raws_1a r_26 (cost=0.00..882.55 rows=22,855 width=199) (actual time=0.003..1.768 rows=22,820 loops=1)

31. 1.800 1.800 ↑ 1.0 23,042 1

Seq Scan on raws_1b r_27 (cost=0.00..890.63 rows=23,063 width=198) (actual time=0.003..1.800 rows=23,042 loops=1)

32. 1.791 1.791 ↑ 1.0 23,091 1

Seq Scan on raws_1c r_28 (cost=0.00..893.16 rows=23,116 width=199) (actual time=0.004..1.791 rows=23,091 loops=1)

33. 1.797 1.797 ↑ 1.0 22,822 1

Seq Scan on raws_1d r_29 (cost=0.00..883.28 rows=22,828 width=199) (actual time=0.003..1.797 rows=22,822 loops=1)

34. 1.812 1.812 ↑ 1.0 23,121 1

Seq Scan on raws_1e r_30 (cost=0.00..895.52 rows=23,152 width=199) (actual time=0.004..1.812 rows=23,121 loops=1)

35. 1.811 1.811 ↑ 1.0 23,023 1

Seq Scan on raws_1f r_31 (cost=0.00..890.53 rows=23,053 width=198) (actual time=0.003..1.811 rows=23,023 loops=1)

36. 1.823 1.823 ↑ 1.0 23,117 1

Seq Scan on raws_20 r_32 (cost=0.00..894.59 rows=23,159 width=199) (actual time=0.004..1.823 rows=23,117 loops=1)

37. 1.843 1.843 ↑ 1.0 23,271 1

Seq Scan on raws_21 r_33 (cost=0.00..901.17 rows=23,317 width=199) (actual time=0.003..1.843 rows=23,271 loops=1)

38. 1.784 1.784 ↑ 1.0 23,126 1

Seq Scan on raws_22 r_34 (cost=0.00..894.57 rows=23,157 width=198) (actual time=0.003..1.784 rows=23,126 loops=1)

39. 1.776 1.776 ↑ 1.0 23,037 1

Seq Scan on raws_23 r_35 (cost=0.00..890.52 rows=23,052 width=198) (actual time=0.003..1.776 rows=23,037 loops=1)

40. 1.794 1.794 ↑ 1.0 22,986 1

Seq Scan on raws_24 r_36 (cost=0.00..889.02 rows=23,002 width=198) (actual time=0.004..1.794 rows=22,986 loops=1)

41. 1.866 1.866 ↑ 1.0 23,199 1

Seq Scan on raws_25 r_37 (cost=0.00..897.21 rows=23,221 width=199) (actual time=0.003..1.866 rows=23,199 loops=1)

42. 1.791 1.791 ↑ 1.0 23,101 1

Seq Scan on raws_26 r_38 (cost=0.00..894.21 rows=23,121 width=199) (actual time=0.003..1.791 rows=23,101 loops=1)

43. 1.809 1.809 ↑ 1.0 23,212 1

Seq Scan on raws_27 r_39 (cost=0.00..898.21 rows=23,221 width=199) (actual time=0.004..1.809 rows=23,212 loops=1)

44. 1.780 1.780 ↑ 1.0 22,929 1

Seq Scan on raws_28 r_40 (cost=0.00..887.33 rows=22,933 width=199) (actual time=0.003..1.780 rows=22,929 loops=1)

45. 1.855 1.855 ↑ 1.0 22,973 1

Seq Scan on raws_29 r_41 (cost=0.00..888.97 rows=22,997 width=199) (actual time=0.003..1.855 rows=22,973 loops=1)

46. 1.818 1.818 ↑ 1.0 23,002 1

Seq Scan on raws_2a r_42 (cost=0.00..890.21 rows=23,021 width=199) (actual time=0.004..1.818 rows=23,002 loops=1)

47. 1.790 1.790 ↑ 1.0 23,106 1

Seq Scan on raws_2b r_43 (cost=0.00..894.33 rows=23,133 width=199) (actual time=0.003..1.790 rows=23,106 loops=1)

48. 1.943 1.943 ↑ 1.0 23,100 1

Seq Scan on raws_2c r_44 (cost=0.00..894.46 rows=23,146 width=199) (actual time=0.003..1.943 rows=23,100 loops=1)

49. 2.040 2.040 ↑ 1.0 23,239 1

Seq Scan on raws_2d r_45 (cost=0.00..898.46 rows=23,246 width=198) (actual time=0.004..2.040 rows=23,239 loops=1)

50. 1.991 1.991 ↑ 1.0 22,886 1

Seq Scan on raws_2e r_46 (cost=0.00..886.30 rows=22,930 width=199) (actual time=0.003..1.991 rows=22,886 loops=1)

51. 1.995 1.995 ↑ 1.0 23,085 1

Seq Scan on raws_2f r_47 (cost=0.00..893.12 rows=23,112 width=199) (actual time=0.003..1.995 rows=23,085 loops=1)

52. 1.996 1.996 ↑ 1.0 23,188 1

Seq Scan on raws_30 r_48 (cost=0.00..897.12 rows=23,212 width=199) (actual time=0.004..1.996 rows=23,188 loops=1)

53. 2.047 2.047 ↑ 1.0 22,818 1

Seq Scan on raws_31 r_49 (cost=0.00..882.41 rows=22,841 width=199) (actual time=0.003..2.047 rows=22,818 loops=1)

54. 1.996 1.996 ↑ 1.0 23,180 1

Seq Scan on raws_32 r_50 (cost=0.00..897.24 rows=23,224 width=199) (actual time=0.003..1.996 rows=23,180 loops=1)

55. 2.013 2.013 ↑ 1.0 23,359 1

Seq Scan on raws_33 r_51 (cost=0.00..904.12 rows=23,412 width=199) (actual time=0.003..2.013 rows=23,359 loops=1)

56. 1.984 1.984 ↑ 1.0 23,027 1

Seq Scan on raws_34 r_52 (cost=0.00..890.68 rows=23,068 width=199) (actual time=0.004..1.984 rows=23,027 loops=1)

57. 2.044 2.044 ↑ 1.0 23,085 1

Seq Scan on raws_35 r_53 (cost=0.00..892.06 rows=23,106 width=198) (actual time=0.003..2.044 rows=23,085 loops=1)

58. 1.910 1.910 ↓ 1.0 22,861 1

Seq Scan on raws_36 r_54 (cost=0.00..883.51 rows=22,851 width=199) (actual time=0.004..1.910 rows=22,861 loops=1)

59. 1.952 1.952 ↑ 1.0 22,877 1

Seq Scan on raws_37 r_55 (cost=0.00..884.78 rows=22,878 width=199) (actual time=0.003..1.952 rows=22,877 loops=1)

60. 1.983 1.983 ↑ 1.0 23,126 1

Seq Scan on raws_38 r_56 (cost=0.00..894.78 rows=23,178 width=198) (actual time=0.004..1.983 rows=23,126 loops=1)

61. 1.985 1.985 ↑ 1.0 23,075 1

Seq Scan on raws_39 r_57 (cost=0.00..891.82 rows=23,082 width=199) (actual time=0.004..1.985 rows=23,075 loops=1)

62. 2.009 2.009 ↑ 1.0 22,906 1

Seq Scan on raws_3a r_58 (cost=0.00..886.28 rows=22,928 width=199) (actual time=0.003..2.009 rows=22,906 loops=1)

63. 2.017 2.017 ↑ 1.0 23,283 1

Seq Scan on raws_3b r_59 (cost=0.00..901.34 rows=23,334 width=199) (actual time=0.004..2.017 rows=23,283 loops=1)

64. 1.952 1.952 ↑ 1.0 22,821 1

Seq Scan on raws_3c r_60 (cost=0.00..883.45 rows=22,845 width=199) (actual time=0.003..1.952 rows=22,821 loops=1)

65. 2.009 2.009 ↑ 1.0 23,180 1

Seq Scan on raws_3d r_61 (cost=0.00..897.23 rows=23,223 width=199) (actual time=0.004..2.009 rows=23,180 loops=1)

66. 1.908 1.908 ↑ 1.0 23,079 1

Seq Scan on raws_3e r_62 (cost=0.00..893.00 rows=23,100 width=199) (actual time=0.004..1.908 rows=23,079 loops=1)

67. 1.963 1.963 ↑ 1.0 22,959 1

Seq Scan on raws_3f r_63 (cost=0.00..887.69 rows=22,969 width=198) (actual time=0.003..1.963 rows=22,959 loops=1)

68. 2.008 2.008 ↑ 1.0 22,857 1

Seq Scan on raws_40 r_64 (cost=0.00..884.93 rows=22,893 width=198) (actual time=0.003..2.008 rows=22,857 loops=1)

69. 2.006 2.006 ↑ 1.0 23,042 1

Seq Scan on raws_41 r_65 (cost=0.00..891.66 rows=23,066 width=199) (actual time=0.004..2.006 rows=23,042 loops=1)

70. 1.977 1.977 ↑ 1.0 23,179 1

Seq Scan on raws_42 r_66 (cost=0.00..896.91 rows=23,191 width=199) (actual time=0.004..1.977 rows=23,179 loops=1)

71. 1.931 1.931 ↑ 1.0 23,136 1

Seq Scan on raws_43 r_67 (cost=0.00..894.46 rows=23,146 width=199) (actual time=0.004..1.931 rows=23,136 loops=1)

72. 1.912 1.912 ↑ 1.0 22,735 1

Seq Scan on raws_44 r_68 (cost=0.00..879.50 rows=22,750 width=199) (actual time=0.004..1.912 rows=22,735 loops=1)

73. 1.960 1.960 ↑ 1.0 23,239 1

Seq Scan on raws_45 r_69 (cost=0.00..899.74 rows=23,274 width=199) (actual time=0.003..1.960 rows=23,239 loops=1)

74. 1.949 1.949 ↑ 1.0 22,756 1

Seq Scan on raws_46 r_70 (cost=0.00..879.61 rows=22,761 width=199) (actual time=0.003..1.949 rows=22,756 loops=1)

75. 1.935 1.935 ↑ 1.0 22,976 1

Seq Scan on raws_47 r_71 (cost=0.00..887.83 rows=22,983 width=199) (actual time=0.003..1.935 rows=22,976 loops=1)

76. 1.934 1.934 ↑ 1.0 22,962 1

Seq Scan on raws_48 r_72 (cost=0.00..887.71 rows=22,971 width=199) (actual time=0.003..1.934 rows=22,962 loops=1)

77. 1.951 1.951 ↑ 1.0 22,844 1

Seq Scan on raws_49 r_73 (cost=0.00..883.84 rows=22,884 width=199) (actual time=0.003..1.951 rows=22,844 loops=1)

78. 1.908 1.908 ↓ 1.0 23,226 1

Seq Scan on raws_4a r_74 (cost=0.00..898.24 rows=23,224 width=199) (actual time=0.003..1.908 rows=23,226 loops=1)

79. 1.992 1.992 ↑ 1.0 23,249 1

Seq Scan on raws_4b r_75 (cost=0.00..899.77 rows=23,277 width=199) (actual time=0.003..1.992 rows=23,249 loops=1)

80. 1.914 1.914 ↑ 1.0 23,036 1

Seq Scan on raws_4c r_76 (cost=0.00..891.81 rows=23,081 width=199) (actual time=0.003..1.914 rows=23,036 loops=1)

81. 1.913 1.913 ↑ 1.0 23,007 1

Seq Scan on raws_4d r_77 (cost=0.00..890.40 rows=23,040 width=199) (actual time=0.004..1.913 rows=23,007 loops=1)

82. 1.941 1.941 ↑ 1.0 23,200 1

Seq Scan on raws_4e r_78 (cost=0.00..898.21 rows=23,221 width=199) (actual time=0.004..1.941 rows=23,200 loops=1)

83. 1.977 1.977 ↑ 1.0 23,235 1

Seq Scan on raws_4f r_79 (cost=0.00..899.59 rows=23,259 width=199) (actual time=0.004..1.977 rows=23,235 loops=1)

84. 1.945 1.945 ↑ 1.0 23,159 1

Seq Scan on raws_50 r_80 (cost=0.00..895.66 rows=23,166 width=199) (actual time=0.003..1.945 rows=23,159 loops=1)

85. 1.940 1.940 ↓ 1.0 22,954 1

Seq Scan on raws_51 r_81 (cost=0.00..887.33 rows=22,933 width=199) (actual time=0.004..1.940 rows=22,954 loops=1)

86. 1.964 1.964 ↓ 1.0 23,075 1

Seq Scan on raws_52 r_82 (cost=0.00..892.59 rows=23,059 width=199) (actual time=0.003..1.964 rows=23,075 loops=1)

87. 1.902 1.902 ↑ 1.0 22,814 1

Seq Scan on raws_53 r_83 (cost=0.00..882.37 rows=22,837 width=199) (actual time=0.003..1.902 rows=22,814 loops=1)

88. 2.200 2.200 ↑ 1.0 23,153 1

Seq Scan on raws_54 r_84 (cost=0.00..896.73 rows=23,173 width=199) (actual time=0.003..2.200 rows=23,153 loops=1)

89. 2.053 2.053 ↓ 1.0 22,904 1

Seq Scan on raws_55 r_85 (cost=0.00..886.00 rows=22,900 width=199) (actual time=0.003..2.053 rows=22,904 loops=1)

90. 2.184 2.184 ↑ 1.0 23,130 1

Seq Scan on raws_56 r_86 (cost=0.00..894.50 rows=23,150 width=199) (actual time=0.003..2.184 rows=23,130 loops=1)

91. 1.964 1.964 ↑ 1.0 23,145 1

Seq Scan on raws_57 r_87 (cost=0.00..895.64 rows=23,164 width=199) (actual time=0.004..1.964 rows=23,145 loops=1)

92. 1.991 1.991 ↑ 1.0 23,196 1

Seq Scan on raws_58 r_88 (cost=0.00..897.21 rows=23,221 width=198) (actual time=0.004..1.991 rows=23,196 loops=1)

93. 1.945 1.945 ↑ 1.0 23,204 1

Seq Scan on raws_59 r_89 (cost=0.00..898.41 rows=23,241 width=199) (actual time=0.004..1.945 rows=23,204 loops=1)

94. 1.898 1.898 ↑ 1.0 22,959 1

Seq Scan on raws_5a r_90 (cost=0.00..888.76 rows=22,976 width=199) (actual time=0.003..1.898 rows=22,959 loops=1)

95. 1.918 1.918 ↑ 1.0 23,158 1

Seq Scan on raws_5b r_91 (cost=0.00..895.58 rows=23,158 width=199) (actual time=0.003..1.918 rows=23,158 loops=1)

96. 1.983 1.983 ↑ 1.0 22,983 1

Seq Scan on raws_5c r_92 (cost=0.00..890.25 rows=23,025 width=199) (actual time=0.004..1.983 rows=22,983 loops=1)

97. 1.932 1.932 ↑ 1.0 23,084 1

Seq Scan on raws_5d r_93 (cost=0.00..893.05 rows=23,105 width=199) (actual time=0.003..1.932 rows=23,084 loops=1)

98. 1.944 1.944 ↑ 1.0 23,147 1

Seq Scan on raws_5e r_94 (cost=0.00..894.54 rows=23,154 width=199) (actual time=0.003..1.944 rows=23,147 loops=1)

99. 1.965 1.965 ↑ 1.0 22,990 1

Seq Scan on raws_5f r_95 (cost=0.00..888.97 rows=22,997 width=199) (actual time=0.003..1.965 rows=22,990 loops=1)

100. 2.226 2.226 ↑ 1.0 23,131 1

Seq Scan on raws_60 r_96 (cost=0.00..894.79 rows=23,179 width=199) (actual time=0.003..2.226 rows=23,131 loops=1)

101. 2.216 2.216 ↑ 1.0 23,034 1

Seq Scan on raws_61 r_97 (cost=0.00..891.42 rows=23,042 width=199) (actual time=0.003..2.216 rows=23,034 loops=1)

102. 2.030 2.030 ↑ 1.0 23,257 1

Seq Scan on raws_62 r_98 (cost=0.00..899.64 rows=23,264 width=199) (actual time=0.003..2.030 rows=23,257 loops=1)

103. 1.952 1.952 ↑ 1.0 23,221 1

Seq Scan on raws_63 r_99 (cost=0.00..898.63 rows=23,263 width=199) (actual time=0.004..1.952 rows=23,221 loops=1)

104. 2.092 2.092 ↑ 1.0 22,851 1

Seq Scan on raws_64 r_100 (cost=0.00..884.70 rows=22,870 width=199) (actual time=0.004..2.092 rows=22,851 loops=1)

105. 2.065 2.065 ↑ 1.0 22,948 1

Seq Scan on raws_65 r_101 (cost=0.00..888.08 rows=23,008 width=198) (actual time=0.004..2.065 rows=22,948 loops=1)

106. 2.060 2.060 ↑ 1.0 22,905 1

Seq Scan on raws_66 r_102 (cost=0.00..886.32 rows=22,932 width=199) (actual time=0.004..2.060 rows=22,905 loops=1)

107. 2.069 2.069 ↑ 1.0 23,392 1

Seq Scan on raws_67 r_103 (cost=0.00..904.01 rows=23,401 width=199) (actual time=0.003..2.069 rows=23,392 loops=1)

108. 2.058 2.058 ↑ 1.0 23,038 1

Seq Scan on raws_68 r_104 (cost=0.00..891.86 rows=23,086 width=198) (actual time=0.004..2.058 rows=23,038 loops=1)

109. 2.013 2.013 ↓ 1.0 23,071 1

Seq Scan on raws_69 r_105 (cost=0.00..891.70 rows=23,070 width=198) (actual time=0.004..2.013 rows=23,071 loops=1)

110. 2.078 2.078 ↓ 1.0 23,131 1

Seq Scan on raws_6a r_106 (cost=0.00..895.27 rows=23,127 width=199) (actual time=0.004..2.078 rows=23,131 loops=1)

111. 1.946 1.946 ↓ 1.0 23,113 1

Seq Scan on raws_6b r_107 (cost=0.00..892.93 rows=23,093 width=199) (actual time=0.004..1.946 rows=23,113 loops=1)

112. 2.031 2.031 ↑ 1.0 23,016 1

Seq Scan on raws_6c r_108 (cost=0.00..890.45 rows=23,045 width=199) (actual time=0.003..2.031 rows=23,016 loops=1)

113. 2.049 2.049 ↑ 1.0 22,976 1

Seq Scan on raws_6d r_109 (cost=0.00..889.08 rows=23,008 width=199) (actual time=0.004..2.049 rows=22,976 loops=1)

114. 2.038 2.038 ↑ 1.0 23,203 1

Seq Scan on raws_6e r_110 (cost=0.00..897.35 rows=23,235 width=198) (actual time=0.003..2.038 rows=23,203 loops=1)

115. 2.005 2.005 ↓ 1.0 23,247 1

Seq Scan on raws_6f r_111 (cost=0.00..899.46 rows=23,246 width=199) (actual time=0.004..2.005 rows=23,247 loops=1)

116. 2.058 2.058 ↓ 1.0 23,059 1

Seq Scan on raws_70 r_112 (cost=0.00..890.49 rows=23,049 width=199) (actual time=0.004..2.058 rows=23,059 loops=1)

117. 2.091 2.091 ↑ 1.0 23,207 1

Seq Scan on raws_71 r_113 (cost=0.00..897.22 rows=23,222 width=199) (actual time=0.004..2.091 rows=23,207 loops=1)

118. 1.996 1.996 ↑ 1.0 22,946 1

Seq Scan on raws_72 r_114 (cost=0.00..887.66 rows=22,966 width=199) (actual time=0.004..1.996 rows=22,946 loops=1)

119. 2.045 2.045 ↑ 1.0 23,042 1

Seq Scan on raws_73 r_115 (cost=0.00..891.65 rows=23,065 width=199) (actual time=0.004..2.045 rows=23,042 loops=1)

120. 2.046 2.046 ↑ 1.0 23,212 1

Seq Scan on raws_74 r_116 (cost=0.00..897.19 rows=23,219 width=199) (actual time=0.004..2.046 rows=23,212 loops=1)

121. 1.966 1.966 ↓ 1.0 23,034 1

Seq Scan on raws_75 r_117 (cost=0.00..890.19 rows=23,019 width=199) (actual time=0.004..1.966 rows=23,034 loops=1)

122. 2.018 2.018 ↓ 1.0 23,339 1

Seq Scan on raws_76 r_118 (cost=0.00..902.32 rows=23,332 width=199) (actual time=0.004..2.018 rows=23,339 loops=1)

123. 2.024 2.024 ↑ 1.0 23,101 1

Seq Scan on raws_77 r_119 (cost=0.00..893.38 rows=23,138 width=199) (actual time=0.004..2.024 rows=23,101 loops=1)

124. 1.969 1.969 ↑ 1.0 23,343 1

Seq Scan on raws_78 r_120 (cost=0.00..903.52 rows=23,352 width=199) (actual time=0.004..1.969 rows=23,343 loops=1)

125. 1.989 1.989 ↑ 1.0 22,850 1

Seq Scan on raws_79 r_121 (cost=0.00..883.64 rows=22,864 width=198) (actual time=0.004..1.989 rows=22,850 loops=1)

126. 2.047 2.047 ↓ 1.0 23,230 1

Seq Scan on raws_7a r_122 (cost=0.00..898.19 rows=23,219 width=199) (actual time=0.004..2.047 rows=23,230 loops=1)

127. 2.027 2.027 ↑ 1.0 23,054 1

Seq Scan on raws_7b r_123 (cost=0.00..891.92 rows=23,092 width=199) (actual time=0.004..2.027 rows=23,054 loops=1)

128. 1.994 1.994 ↑ 1.0 23,371 1

Seq Scan on raws_7c r_124 (cost=0.00..902.72 rows=23,372 width=199) (actual time=0.004..1.994 rows=23,371 loops=1)

129. 1.941 1.941 ↑ 1.0 23,041 1

Seq Scan on raws_7d r_125 (cost=0.00..891.44 rows=23,044 width=199) (actual time=0.003..1.941 rows=23,041 loops=1)

130. 2.005 2.005 ↑ 1.0 23,256 1

Seq Scan on raws_7e r_126 (cost=0.00..899.92 rows=23,292 width=198) (actual time=0.010..2.005 rows=23,256 loops=1)

131. 2.010 2.010 ↑ 1.0 22,818 1

Seq Scan on raws_7f r_127 (cost=0.00..882.66 rows=22,866 width=199) (actual time=0.004..2.010 rows=22,818 loops=1)

132. 2.048 2.048 ↑ 1.0 23,145 1

Seq Scan on raws_80 r_128 (cost=0.00..895.92 rows=23,192 width=199) (actual time=0.003..2.048 rows=23,145 loops=1)

133. 2.022 2.022 ↑ 1.0 23,098 1

Seq Scan on raws_81 r_129 (cost=0.00..893.18 rows=23,118 width=198) (actual time=0.004..2.022 rows=23,098 loops=1)

134. 1.978 1.978 ↑ 1.0 23,059 1

Seq Scan on raws_82 r_130 (cost=0.00..891.62 rows=23,062 width=199) (actual time=0.003..1.978 rows=23,059 loops=1)

135. 1.967 1.967 ↓ 1.0 23,280 1

Seq Scan on raws_83 r_131 (cost=0.00..899.63 rows=23,263 width=199) (actual time=0.004..1.967 rows=23,280 loops=1)

136. 2.042 2.042 ↑ 1.0 23,052 1

Seq Scan on raws_84 r_132 (cost=0.00..891.54 rows=23,054 width=199) (actual time=0.004..2.042 rows=23,052 loops=1)

137. 1.997 1.997 ↑ 1.0 22,895 1

Seq Scan on raws_85 r_133 (cost=0.00..885.14 rows=22,914 width=198) (actual time=0.004..1.997 rows=22,895 loops=1)

138. 1.995 1.995 ↑ 1.0 23,020 1

Seq Scan on raws_86 r_134 (cost=0.00..890.21 rows=23,021 width=199) (actual time=0.004..1.995 rows=23,020 loops=1)

139. 2.028 2.028 ↓ 1.0 23,006 1

Seq Scan on raws_87 r_135 (cost=0.00..890.05 rows=23,005 width=199) (actual time=0.004..2.028 rows=23,006 loops=1)

140. 1.949 1.949 ↑ 1.0 23,099 1

Seq Scan on raws_88 r_136 (cost=0.00..893.24 rows=23,124 width=199) (actual time=0.003..1.949 rows=23,099 loops=1)

141. 1.991 1.991 ↑ 1.0 22,985 1

Seq Scan on raws_89 r_137 (cost=0.00..889.04 rows=23,004 width=199) (actual time=0.003..1.991 rows=22,985 loops=1)

142. 1.968 1.968 ↑ 1.0 23,129 1

Seq Scan on raws_8a r_138 (cost=0.00..895.81 rows=23,181 width=199) (actual time=0.003..1.968 rows=23,129 loops=1)

143. 1.950 1.950 ↑ 1.0 23,162 1

Seq Scan on raws_8b r_139 (cost=0.00..895.65 rows=23,165 width=199) (actual time=0.004..1.950 rows=23,162 loops=1)

144. 1.960 1.960 ↑ 1.0 22,841 1

Seq Scan on raws_8c r_140 (cost=0.00..883.50 rows=22,850 width=199) (actual time=0.003..1.960 rows=22,841 loops=1)

145. 1.946 1.946 ↑ 1.0 22,945 1

Seq Scan on raws_8d r_141 (cost=0.00..886.46 rows=22,946 width=198) (actual time=0.003..1.946 rows=22,945 loops=1)

146. 1.988 1.988 ↑ 1.0 23,104 1

Seq Scan on raws_8e r_142 (cost=0.00..894.29 rows=23,129 width=199) (actual time=0.003..1.988 rows=23,104 loops=1)

147. 1.951 1.951 ↑ 1.0 22,994 1

Seq Scan on raws_8f r_143 (cost=0.00..889.22 rows=23,022 width=198) (actual time=0.004..1.951 rows=22,994 loops=1)

148. 1.981 1.981 ↑ 1.0 22,873 1

Seq Scan on raws_90 r_144 (cost=0.00..884.90 rows=22,890 width=199) (actual time=0.004..1.981 rows=22,873 loops=1)

149. 2.033 2.033 ↑ 1.0 23,255 1

Seq Scan on raws_91 r_145 (cost=0.00..899.69 rows=23,269 width=199) (actual time=0.004..2.033 rows=23,255 loops=1)

150. 2.160 2.160 ↑ 1.0 23,256 1

Seq Scan on raws_92 r_146 (cost=0.00..899.70 rows=23,270 width=199) (actual time=0.004..2.160 rows=23,256 loops=1)

151. 2.207 2.207 ↑ 1.0 23,057 1

Seq Scan on raws_93 r_147 (cost=0.00..892.02 rows=23,102 width=198) (actual time=0.004..2.207 rows=23,057 loops=1)

152. 2.155 2.155 ↑ 1.0 23,334 1

Seq Scan on raws_94 r_148 (cost=0.00..902.74 rows=23,374 width=198) (actual time=0.004..2.155 rows=23,334 loops=1)

153. 2.120 2.120 ↑ 1.0 23,165 1

Seq Scan on raws_95 r_149 (cost=0.00..895.85 rows=23,185 width=198) (actual time=0.004..2.120 rows=23,165 loops=1)

154. 2.078 2.078 ↑ 1.0 23,197 1

Seq Scan on raws_96 r_150 (cost=0.00..898.31 rows=23,231 width=199) (actual time=0.004..2.078 rows=23,197 loops=1)

155. 2.149 2.149 ↑ 1.0 23,188 1

Seq Scan on raws_97 r_151 (cost=0.00..897.04 rows=23,204 width=199) (actual time=0.003..2.149 rows=23,188 loops=1)

156. 2.008 2.008 ↓ 1.0 23,133 1

Seq Scan on raws_98 r_152 (cost=0.00..894.18 rows=23,118 width=199) (actual time=0.003..2.008 rows=23,133 loops=1)

157. 2.072 2.072 ↑ 1.0 23,320 1

Seq Scan on raws_99 r_153 (cost=0.00..902.57 rows=23,357 width=199) (actual time=0.003..2.072 rows=23,320 loops=1)

158. 2.091 2.091 ↑ 1.0 23,065 1

Seq Scan on raws_9a r_154 (cost=0.00..891.68 rows=23,068 width=199) (actual time=0.004..2.091 rows=23,065 loops=1)

159. 2.052 2.052 ↑ 1.0 23,210 1

Seq Scan on raws_9b r_155 (cost=0.00..897.21 rows=23,221 width=198) (actual time=0.003..2.052 rows=23,210 loops=1)

160. 2.007 2.007 ↑ 1.0 23,068 1

Seq Scan on raws_9c r_156 (cost=0.00..893.30 rows=23,130 width=199) (actual time=0.003..2.007 rows=23,068 loops=1)

161. 2.056 2.056 ↑ 1.0 23,265 1

Seq Scan on raws_9d r_157 (cost=0.00..899.82 rows=23,282 width=199) (actual time=0.003..2.056 rows=23,265 loops=1)

162. 1.948 1.948 ↑ 1.0 23,020 1

Seq Scan on raws_9e r_158 (cost=0.00..890.52 rows=23,052 width=199) (actual time=0.003..1.948 rows=23,020 loops=1)

163. 2.001 2.001 ↑ 1.0 23,186 1

Seq Scan on raws_9f r_159 (cost=0.00..897.16 rows=23,216 width=199) (actual time=0.003..2.001 rows=23,186 loops=1)

164. 1.949 1.949 ↑ 1.0 23,104 1

Seq Scan on raws_a0 r_160 (cost=0.00..894.56 rows=23,156 width=199) (actual time=0.004..1.949 rows=23,104 loops=1)

165. 1.905 1.905 ↑ 1.0 23,197 1

Seq Scan on raws_a1 r_161 (cost=0.00..897.15 rows=23,215 width=199) (actual time=0.003..1.905 rows=23,197 loops=1)

166. 1.935 1.935 ↑ 1.0 22,875 1

Seq Scan on raws_a2 r_162 (cost=0.00..884.96 rows=22,896 width=199) (actual time=0.004..1.935 rows=22,875 loops=1)

167. 2.004 2.004 ↑ 1.0 23,131 1

Seq Scan on raws_a3 r_163 (cost=0.00..895.77 rows=23,177 width=199) (actual time=0.004..2.004 rows=23,131 loops=1)

168. 1.924 1.924 ↓ 1.0 23,261 1

Seq Scan on raws_a4 r_164 (cost=0.00..899.59 rows=23,259 width=199) (actual time=0.003..1.924 rows=23,261 loops=1)

169. 1.930 1.930 ↑ 1.0 22,859 1

Seq Scan on raws_a5 r_165 (cost=0.00..883.92 rows=22,892 width=198) (actual time=0.003..1.930 rows=22,859 loops=1)

170. 1.980 1.980 ↑ 1.0 23,220 1

Seq Scan on raws_a6 r_166 (cost=0.00..898.35 rows=23,235 width=199) (actual time=0.004..1.980 rows=23,220 loops=1)

171. 1.984 1.984 ↑ 1.0 23,143 1

Seq Scan on raws_a7 r_167 (cost=0.00..895.64 rows=23,164 width=199) (actual time=0.004..1.984 rows=23,143 loops=1)

172. 1.913 1.913 ↑ 1.0 23,180 1

Seq Scan on raws_a8 r_168 (cost=0.00..897.08 rows=23,208 width=199) (actual time=0.004..1.913 rows=23,180 loops=1)

173. 1.949 1.949 ↑ 1.0 23,034 1

Seq Scan on raws_a9 r_169 (cost=0.00..890.72 rows=23,072 width=198) (actual time=0.003..1.949 rows=23,034 loops=1)

174. 1.929 1.929 ↓ 1.0 23,008 1

Seq Scan on raws_aa r_170 (cost=0.00..888.99 rows=22,999 width=199) (actual time=0.003..1.929 rows=23,008 loops=1)

175. 1.966 1.966 ↑ 1.0 23,206 1

Seq Scan on raws_ab r_171 (cost=0.00..897.18 rows=23,218 width=199) (actual time=0.003..1.966 rows=23,206 loops=1)

176. 1.915 1.915 ↑ 1.0 23,065 1

Seq Scan on raws_ac r_172 (cost=0.00..893.00 rows=23,100 width=199) (actual time=0.003..1.915 rows=23,065 loops=1)

177. 1.947 1.947 ↑ 1.0 23,206 1

Seq Scan on raws_ad r_173 (cost=0.00..898.44 rows=23,244 width=199) (actual time=0.003..1.947 rows=23,206 loops=1)

178. 1.925 1.925 ↑ 1.0 22,969 1

Seq Scan on raws_ae r_174 (cost=0.00..888.97 rows=22,997 width=198) (actual time=0.003..1.925 rows=22,969 loops=1)

179. 1.981 1.981 ↑ 1.0 23,152 1

Seq Scan on raws_af r_175 (cost=0.00..895.89 rows=23,189 width=199) (actual time=0.004..1.981 rows=23,152 loops=1)

180. 1.968 1.968 ↑ 1.0 23,040 1

Seq Scan on raws_b0 r_176 (cost=0.00..891.65 rows=23,065 width=199) (actual time=0.003..1.968 rows=23,040 loops=1)

181. 1.949 1.949 ↑ 1.0 23,028 1

Seq Scan on raws_b1 r_177 (cost=0.00..890.32 rows=23,032 width=199) (actual time=0.004..1.949 rows=23,028 loops=1)

182. 1.945 1.945 ↑ 1.0 23,218 1

Seq Scan on raws_b2 r_178 (cost=0.00..898.63 rows=23,263 width=199) (actual time=0.004..1.945 rows=23,218 loops=1)

183. 1.995 1.995 ↑ 1.0 23,359 1

Seq Scan on raws_b3 r_179 (cost=0.00..903.99 rows=23,399 width=199) (actual time=0.003..1.995 rows=23,359 loops=1)

184. 1.927 1.927 ↓ 1.0 23,204 1

Seq Scan on raws_b4 r_180 (cost=0.00..896.95 rows=23,195 width=199) (actual time=0.003..1.927 rows=23,204 loops=1)

185. 1.954 1.954 ↑ 1.0 23,087 1

Seq Scan on raws_b5 r_181 (cost=0.00..892.88 rows=23,088 width=199) (actual time=0.003..1.954 rows=23,087 loops=1)

186. 1.918 1.918 ↑ 1.0 22,904 1

Seq Scan on raws_b6 r_182 (cost=0.00..886.46 rows=22,946 width=199) (actual time=0.004..1.918 rows=22,904 loops=1)

187. 1.973 1.973 ↑ 1.0 23,078 1

Seq Scan on raws_b7 r_183 (cost=0.00..893.16 rows=23,116 width=199) (actual time=0.003..1.973 rows=23,078 loops=1)

188. 1.953 1.953 ↑ 1.0 23,174 1

Seq Scan on raws_b8 r_184 (cost=0.00..897.03 rows=23,203 width=199) (actual time=0.003..1.953 rows=23,174 loops=1)

189. 1.911 1.911 ↑ 1.0 23,098 1

Seq Scan on raws_b9 r_185 (cost=0.00..893.13 rows=23,113 width=199) (actual time=0.004..1.911 rows=23,098 loops=1)

190. 1.882 1.882 ↓ 1.0 22,977 1

Seq Scan on raws_ba r_186 (cost=0.00..887.66 rows=22,966 width=199) (actual time=0.004..1.882 rows=22,977 loops=1)

191. 1.914 1.914 ↑ 1.0 23,124 1

Seq Scan on raws_bb r_187 (cost=0.00..894.27 rows=23,127 width=199) (actual time=0.004..1.914 rows=23,124 loops=1)

192. 1.890 1.890 ↑ 1.0 22,829 1

Seq Scan on raws_bc r_188 (cost=0.00..882.39 rows=22,839 width=199) (actual time=0.004..1.890 rows=22,829 loops=1)

193. 1.952 1.952 ↑ 1.0 23,046 1

Seq Scan on raws_bd r_189 (cost=0.00..891.71 rows=23,071 width=199) (actual time=0.004..1.952 rows=23,046 loops=1)

194. 1.890 1.890 ↑ 1.0 22,741 1

Seq Scan on raws_be r_190 (cost=0.00..879.89 rows=22,789 width=198) (actual time=0.003..1.890 rows=22,741 loops=1)

195. 1.903 1.903 ↑ 1.0 22,937 1

Seq Scan on raws_bf r_191 (cost=0.00..886.71 rows=22,971 width=198) (actual time=0.003..1.903 rows=22,937 loops=1)

196. 1.868 1.868 ↓ 1.0 23,108 1

Seq Scan on raws_c0 r_192 (cost=0.00..892.99 rows=23,099 width=198) (actual time=0.004..1.868 rows=23,108 loops=1)

197. 1.892 1.892 ↑ 1.0 22,968 1

Seq Scan on raws_c1 r_193 (cost=0.00..889.96 rows=22,996 width=199) (actual time=0.003..1.892 rows=22,968 loops=1)

198. 1.943 1.943 ↑ 1.0 23,067 1

Seq Scan on raws_c2 r_194 (cost=0.00..891.81 rows=23,081 width=198) (actual time=0.003..1.943 rows=23,067 loops=1)

199. 1.880 1.880 ↑ 1.0 23,044 1

Seq Scan on raws_c3 r_195 (cost=0.00..890.57 rows=23,057 width=199) (actual time=0.004..1.880 rows=23,044 loops=1)

200. 1.941 1.941 ↑ 1.0 23,092 1

Seq Scan on raws_c4 r_196 (cost=0.00..893.16 rows=23,116 width=199) (actual time=0.004..1.941 rows=23,092 loops=1)

201. 1.907 1.907 ↑ 1.0 22,990 1

Seq Scan on raws_c5 r_197 (cost=0.00..889.12 rows=23,012 width=199) (actual time=0.004..1.907 rows=22,990 loops=1)

202. 1.858 1.858 ↑ 1.0 23,075 1

Seq Scan on raws_c6 r_198 (cost=0.00..891.84 rows=23,084 width=199) (actual time=0.003..1.858 rows=23,075 loops=1)

203. 1.933 1.933 ↑ 1.0 23,150 1

Seq Scan on raws_c7 r_199 (cost=0.00..895.76 rows=23,176 width=198) (actual time=0.004..1.933 rows=23,150 loops=1)

204. 1.964 1.964 ↑ 1.0 23,070 1

Seq Scan on raws_c8 r_200 (cost=0.00..892.86 rows=23,086 width=199) (actual time=0.004..1.964 rows=23,070 loops=1)

205. 1.882 1.882 ↑ 1.0 23,334 1

Seq Scan on raws_c9 r_201 (cost=0.00..902.69 rows=23,369 width=199) (actual time=0.003..1.882 rows=23,334 loops=1)

206. 1.919 1.919 ↑ 1.0 23,037 1

Seq Scan on raws_ca r_202 (cost=0.00..891.74 rows=23,074 width=199) (actual time=0.004..1.919 rows=23,037 loops=1)

207. 1.973 1.973 ↑ 1.0 23,270 1

Seq Scan on raws_cb r_203 (cost=0.00..900.93 rows=23,293 width=199) (actual time=0.004..1.973 rows=23,270 loops=1)

208. 1.956 1.956 ↑ 1.0 23,331 1

Seq Scan on raws_cc r_204 (cost=0.00..902.55 rows=23,355 width=198) (actual time=0.003..1.956 rows=23,331 loops=1)

209. 1.866 1.866 ↓ 1.0 23,209 1

Seq Scan on raws_cd r_205 (cost=0.00..896.99 rows=23,199 width=199) (actual time=0.004..1.866 rows=23,209 loops=1)

210. 1.921 1.921 ↑ 1.0 23,002 1

Seq Scan on raws_ce r_206 (cost=0.00..890.22 rows=23,022 width=198) (actual time=0.003..1.921 rows=23,002 loops=1)

211. 1.883 1.883 ↑ 1.0 22,745 1

Seq Scan on raws_cf r_207 (cost=0.00..878.51 rows=22,751 width=198) (actual time=0.003..1.883 rows=22,745 loops=1)

212. 1.912 1.912 ↑ 1.0 23,068 1

Seq Scan on raws_d0 r_208 (cost=0.00..892.91 rows=23,091 width=199) (actual time=0.003..1.912 rows=23,068 loops=1)

213. 1.885 1.885 ↑ 1.0 23,015 1

Seq Scan on raws_d1 r_209 (cost=0.00..890.31 rows=23,031 width=198) (actual time=0.004..1.885 rows=23,015 loops=1)

214. 1.845 1.845 ↑ 1.0 23,174 1

Seq Scan on raws_d2 r_210 (cost=0.00..896.84 rows=23,184 width=199) (actual time=0.004..1.845 rows=23,174 loops=1)

215. 1.924 1.924 ↑ 1.0 22,952 1

Seq Scan on raws_d3 r_211 (cost=0.00..887.79 rows=22,979 width=199) (actual time=0.003..1.924 rows=22,952 loops=1)

216. 1.958 1.958 ↑ 1.0 23,228 1

Seq Scan on raws_d4 r_212 (cost=0.00..898.39 rows=23,239 width=199) (actual time=0.003..1.958 rows=23,228 loops=1)

217. 1.909 1.909 ↑ 1.0 23,064 1

Seq Scan on raws_d5 r_213 (cost=0.00..892.82 rows=23,082 width=199) (actual time=0.003..1.909 rows=23,064 loops=1)

218. 1.925 1.925 ↑ 1.0 22,970 1

Seq Scan on raws_d6 r_214 (cost=0.00..888.00 rows=23,000 width=198) (actual time=0.004..1.925 rows=22,970 loops=1)

219. 1.912 1.912 ↑ 1.0 23,119 1

Seq Scan on raws_d7 r_215 (cost=0.00..894.32 rows=23,132 width=199) (actual time=0.003..1.912 rows=23,119 loops=1)

220. 1.906 1.906 ↑ 1.0 23,084 1

Seq Scan on raws_d8 r_216 (cost=0.00..893.00 rows=23,100 width=199) (actual time=0.003..1.906 rows=23,084 loops=1)

221. 1.858 1.858 ↑ 1.0 22,989 1

Seq Scan on raws_d9 r_217 (cost=0.00..888.92 rows=22,992 width=199) (actual time=0.004..1.858 rows=22,989 loops=1)

222. 1.924 1.924 ↑ 1.0 23,201 1

Seq Scan on raws_da r_218 (cost=0.00..897.09 rows=23,209 width=199) (actual time=0.003..1.924 rows=23,201 loops=1)

223. 1.905 1.905 ↑ 1.0 22,896 1

Seq Scan on raws_db r_219 (cost=0.00..886.34 rows=22,934 width=199) (actual time=0.004..1.905 rows=22,896 loops=1)

224. 1.882 1.882 ↓ 1.0 23,443 1

Seq Scan on raws_dc r_220 (cost=0.00..906.35 rows=23,435 width=199) (actual time=0.003..1.882 rows=23,443 loops=1)

225. 1.882 1.882 ↑ 1.0 22,932 1

Seq Scan on raws_dd r_221 (cost=0.00..887.63 rows=22,963 width=199) (actual time=0.003..1.882 rows=22,932 loops=1)

226. 1.918 1.918 ↑ 1.0 22,990 1

Seq Scan on raws_de r_222 (cost=0.00..890.36 rows=23,036 width=199) (actual time=0.004..1.918 rows=22,990 loops=1)

227. 1.928 1.928 ↑ 1.0 23,254 1

Seq Scan on raws_df r_223 (cost=0.00..899.72 rows=23,272 width=199) (actual time=0.004..1.928 rows=23,254 loops=1)

228. 2.080 2.080 ↓ 1.0 22,903 1

Seq Scan on raws_e0 r_224 (cost=0.00..885.01 rows=22,901 width=199) (actual time=0.003..2.080 rows=22,903 loops=1)

229. 2.014 2.014 ↑ 1.0 23,073 1

Seq Scan on raws_e1 r_225 (cost=0.00..892.03 rows=23,103 width=198) (actual time=0.004..2.014 rows=23,073 loops=1)

230. 2.017 2.017 ↑ 1.0 23,120 1

Seq Scan on raws_e2 r_226 (cost=0.00..894.64 rows=23,164 width=198) (actual time=0.004..2.017 rows=23,120 loops=1)

231. 1.913 1.913 ↑ 1.0 22,979 1

Seq Scan on raws_e3 r_227 (cost=0.00..889.25 rows=23,025 width=198) (actual time=0.004..1.913 rows=22,979 loops=1)

232. 1.897 1.897 ↑ 1.0 22,860 1

Seq Scan on raws_e4 r_228 (cost=0.00..883.73 rows=22,873 width=199) (actual time=0.003..1.897 rows=22,860 loops=1)

233. 1.908 1.908 ↑ 1.0 23,045 1

Seq Scan on raws_e5 r_229 (cost=0.00..891.67 rows=23,067 width=199) (actual time=0.003..1.908 rows=23,045 loops=1)

234. 1.921 1.921 ↑ 1.0 23,057 1

Seq Scan on raws_e6 r_230 (cost=0.00..891.91 rows=23,091 width=199) (actual time=0.003..1.921 rows=23,057 loops=1)

235. 1.902 1.902 ↑ 1.0 23,002 1

Seq Scan on raws_e7 r_231 (cost=0.00..890.51 rows=23,051 width=198) (actual time=0.003..1.902 rows=23,002 loops=1)

236. 1.858 1.858 ↑ 1.0 23,092 1

Seq Scan on raws_e8 r_232 (cost=0.00..893.05 rows=23,105 width=199) (actual time=0.003..1.858 rows=23,092 loops=1)

237. 1.894 1.894 ↑ 1.0 23,220 1

Seq Scan on raws_e9 r_233 (cost=0.00..898.36 rows=23,236 width=199) (actual time=0.003..1.894 rows=23,220 loops=1)

238. 1.854 1.854 ↑ 1.0 22,968 1

Seq Scan on raws_ea r_234 (cost=0.00..888.84 rows=22,984 width=199) (actual time=0.004..1.854 rows=22,968 loops=1)

239. 1.894 1.894 ↑ 1.0 23,225 1

Seq Scan on raws_eb r_235 (cost=0.00..898.28 rows=23,228 width=199) (actual time=0.003..1.894 rows=23,225 loops=1)

240. 2.133 2.133 ↑ 1.0 23,340 1

Seq Scan on raws_ec r_236 (cost=0.00..902.81 rows=23,381 width=198) (actual time=0.004..2.133 rows=23,340 loops=1)

241. 2.217 2.217 ↑ 1.0 23,146 1

Seq Scan on raws_ed r_237 (cost=0.00..895.88 rows=23,188 width=199) (actual time=0.003..2.217 rows=23,146 loops=1)

242. 2.014 2.014 ↑ 1.0 22,978 1

Seq Scan on raws_ee r_238 (cost=0.00..889.04 rows=23,004 width=198) (actual time=0.003..2.014 rows=22,978 loops=1)

243. 1.958 1.958 ↑ 1.0 23,075 1

Seq Scan on raws_ef r_239 (cost=0.00..893.34 rows=23,134 width=199) (actual time=0.003..1.958 rows=23,075 loops=1)

244. 1.995 1.995 ↑ 1.0 23,304 1

Seq Scan on raws_f0 r_240 (cost=0.00..902.11 rows=23,311 width=199) (actual time=0.003..1.995 rows=23,304 loops=1)

245. 2.022 2.022 ↑ 1.0 23,156 1

Seq Scan on raws_f1 r_241 (cost=0.00..895.56 rows=23,156 width=199) (actual time=0.004..2.022 rows=23,156 loops=1)

246. 2.082 2.082 ↑ 1.0 23,226 1

Seq Scan on raws_f2 r_242 (cost=0.00..898.63 rows=23,263 width=199) (actual time=0.003..2.082 rows=23,226 loops=1)

247. 1.989 1.989 ↓ 1.0 22,953 1

Seq Scan on raws_f3 r_243 (cost=0.00..887.48 rows=22,948 width=199) (actual time=0.004..1.989 rows=22,953 loops=1)

248. 1.949 1.949 ↑ 1.0 23,120 1

Seq Scan on raws_f4 r_244 (cost=0.00..894.37 rows=23,137 width=199) (actual time=0.004..1.949 rows=23,120 loops=1)

249. 1.978 1.978 ↑ 1.0 23,174 1

Seq Scan on raws_f5 r_245 (cost=0.00..896.88 rows=23,188 width=199) (actual time=0.003..1.978 rows=23,174 loops=1)

250. 2.035 2.035 ↑ 1.0 23,058 1

Seq Scan on raws_f6 r_246 (cost=0.00..891.70 rows=23,070 width=199) (actual time=0.004..2.035 rows=23,058 loops=1)

251. 1.922 1.922 ↑ 1.0 22,772 1

Seq Scan on raws_f7 r_247 (cost=0.00..880.85 rows=22,785 width=199) (actual time=0.004..1.922 rows=22,772 loops=1)

252. 1.935 1.935 ↑ 1.0 23,084 1

Seq Scan on raws_f8 r_248 (cost=0.00..893.22 rows=23,122 width=198) (actual time=0.003..1.935 rows=23,084 loops=1)

253. 1.943 1.943 ↑ 1.0 22,976 1

Seq Scan on raws_f9 r_249 (cost=0.00..890.00 rows=23,000 width=199) (actual time=0.003..1.943 rows=22,976 loops=1)

254. 1.950 1.950 ↑ 1.0 23,096 1

Seq Scan on raws_fa r_250 (cost=0.00..893.17 rows=23,117 width=199) (actual time=0.003..1.950 rows=23,096 loops=1)

255. 1.903 1.903 ↑ 1.0 22,997 1

Seq Scan on raws_fb r_251 (cost=0.00..890.12 rows=23,012 width=199) (actual time=0.003..1.903 rows=22,997 loops=1)

256. 1.933 1.933 ↑ 1.0 23,198 1

Seq Scan on raws_fc r_252 (cost=0.00..898.11 rows=23,211 width=199) (actual time=0.003..1.933 rows=23,198 loops=1)

257. 1.981 1.981 ↑ 1.0 22,901 1

Seq Scan on raws_fd r_253 (cost=0.00..885.01 rows=22,901 width=199) (actual time=0.004..1.981 rows=22,901 loops=1)

258. 1.973 1.973 ↑ 1.0 23,222 1

Seq Scan on raws_fe r_254 (cost=0.00..898.43 rows=23,243 width=199) (actual time=0.004..1.973 rows=23,222 loops=1)

259. 1.940 1.940 ↑ 1.0 23,294 1

Seq Scan on raws_ff r_255 (cost=0.00..900.14 rows=23,314 width=198) (actual time=0.004..1.940 rows=23,294 loops=1)

260. 88.083 174.772 ↑ 1.0 923,578 1

Hash (cost=20,259.49..20,259.49 rows=923,852 width=44) (actual time=174.772..174.772 rows=923,578 loops=1)

  • Buckets: 131,072 Batches: 8 Memory Usage: 9,615kB
261. 86.689 86.689 ↑ 1.0 923,578 1

Seq Scan on fast_search_domains_b3 e (cost=0.00..20,259.49 rows=923,852 width=44) (actual time=0.009..86.689 rows=923,578 loops=1)

  • Filter: (domain = '\xb33960790a6de22ca95a61c6d1310b3487304529cb0af6f3e9b80d2e5ddf76b8'::bytea)
  • Rows Removed by Filter: 3,649
Planning time : 3.601 ms
Execution time : 2,250.264 ms