explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DfOA : Optimization for: plan #DBBQ

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.885 469.766 ↑ 1.0 20,000 1

Limit (cost=39,799.13..42,156.13 rows=20,000 width=855) (actual time=157.149..469.766 rows=20,000 loops=1)

2. 3.817 468.881 ↑ 288.2 20,000 1

Hash Left Join (cost=39,799.13..719,127.31 rows=5,764,347 width=855) (actual time=157.148..468.881 rows=20,000 loops=1)

  • Hash Cond: (r.file_id = f.id)
3. 189.347 465.038 ↑ 288.2 20,000 1

Hash Right Join (cost=39,789.59..696,060.38 rows=5,764,347 width=243) (actual time=157.109..465.038 rows=20,000 loops=1)

  • Hash Cond: (r.id = e.raw_id)
4. 35.973 118.693 ↑ 5.8 1,001,766 1

Append (cost=0.00..252,475.65 rows=5,784,977 width=199) (actual time=0.006..118.693 rows=1,001,766 loops=1)

5. 1.887 1.887 ↑ 1.0 22,420 1

Seq Scan on raws_00 r (cost=0.00..867.43 rows=22,443 width=199) (actual time=0.005..1.887 rows=22,420 loops=1)

6. 2.000 2.000 ↓ 1.0 22,684 1

Seq Scan on raws_01 r_1 (cost=0.00..876.71 rows=22,671 width=198) (actual time=0.003..2.000 rows=22,684 loops=1)

7. 2.064 2.064 ↑ 1.0 22,748 1

Seq Scan on raws_02 r_2 (cost=0.00..879.88 rows=22,788 width=198) (actual time=0.003..2.064 rows=22,748 loops=1)

8. 1.913 1.913 ↑ 1.0 22,618 1

Seq Scan on raws_03 r_3 (cost=0.00..874.42 rows=22,642 width=198) (actual time=0.004..1.913 rows=22,618 loops=1)

9. 1.872 1.872 ↑ 1.0 22,716 1

Seq Scan on raws_04 r_4 (cost=0.00..878.53 rows=22,753 width=198) (actual time=0.006..1.872 rows=22,716 loops=1)

10. 1.835 1.835 ↑ 1.0 22,681 1

Seq Scan on raws_05 r_5 (cost=0.00..877.09 rows=22,709 width=199) (actual time=0.004..1.835 rows=22,681 loops=1)

11. 1.791 1.791 ↑ 1.0 22,426 1

Seq Scan on raws_06 r_6 (cost=0.00..867.65 rows=22,465 width=198) (actual time=0.003..1.791 rows=22,426 loops=1)

12. 1.787 1.787 ↑ 1.0 22,518 1

Seq Scan on raws_07 r_7 (cost=0.00..870.25 rows=22,525 width=198) (actual time=0.003..1.787 rows=22,518 loops=1)

13. 1.807 1.807 ↓ 1.0 22,611 1

Seq Scan on raws_08 r_8 (cost=0.00..873.93 rows=22,593 width=199) (actual time=0.006..1.807 rows=22,611 loops=1)

14. 1.798 1.798 ↑ 1.0 22,312 1

Seq Scan on raws_09 r_9 (cost=0.00..863.24 rows=22,324 width=199) (actual time=0.003..1.798 rows=22,312 loops=1)

15. 1.801 1.801 ↑ 1.0 22,504 1

Seq Scan on raws_0a r_10 (cost=0.00..870.07 rows=22,507 width=199) (actual time=0.003..1.801 rows=22,504 loops=1)

16. 1.817 1.817 ↑ 1.0 22,597 1

Seq Scan on raws_0b r_11 (cost=0.00..874.30 rows=22,630 width=199) (actual time=0.003..1.817 rows=22,597 loops=1)

17. 1.842 1.842 ↑ 1.0 22,514 1

Seq Scan on raws_0c r_12 (cost=0.00..870.32 rows=22,532 width=199) (actual time=0.005..1.842 rows=22,514 loops=1)

18. 2.032 2.032 ↑ 1.0 22,522 1

Seq Scan on raws_0d r_13 (cost=0.00..870.71 rows=22,571 width=198) (actual time=0.003..2.032 rows=22,522 loops=1)

19. 1.896 1.896 ↑ 1.0 22,461 1

Seq Scan on raws_0e r_14 (cost=0.00..869.17 rows=22,517 width=198) (actual time=0.003..1.896 rows=22,461 loops=1)

20. 1.855 1.855 ↑ 1.0 22,387 1

Seq Scan on raws_0f r_15 (cost=0.00..865.21 rows=22,421 width=199) (actual time=0.003..1.855 rows=22,387 loops=1)

21. 1.845 1.845 ↑ 1.0 22,738 1

Seq Scan on raws_10 r_16 (cost=0.00..879.67 rows=22,767 width=198) (actual time=0.006..1.845 rows=22,738 loops=1)

22. 1.857 1.857 ↓ 1.0 22,580 1

Seq Scan on raws_11 r_17 (cost=0.00..872.75 rows=22,575 width=199) (actual time=0.004..1.857 rows=22,580 loops=1)

23. 1.887 1.887 ↑ 1.0 22,473 1

Seq Scan on raws_12 r_18 (cost=0.00..868.73 rows=22,473 width=199) (actual time=0.003..1.887 rows=22,473 loops=1)

24. 1.910 1.910 ↑ 1.0 22,662 1

Seq Scan on raws_13 r_19 (cost=0.00..876.07 rows=22,707 width=198) (actual time=0.003..1.910 rows=22,662 loops=1)

25. 1.881 1.881 ↓ 1.0 22,686 1

Seq Scan on raws_14 r_20 (cost=0.00..876.77 rows=22,677 width=198) (actual time=0.005..1.881 rows=22,686 loops=1)

26. 1.900 1.900 ↓ 1.0 22,968 1

Seq Scan on raws_15 r_21 (cost=0.00..887.64 rows=22,964 width=198) (actual time=0.003..1.900 rows=22,968 loops=1)

27. 1.852 1.852 ↑ 1.0 22,759 1

Seq Scan on raws_16 r_22 (cost=0.00..880.84 rows=22,784 width=199) (actual time=0.003..1.852 rows=22,759 loops=1)

28. 1.821 1.821 ↓ 1.0 22,400 1

Seq Scan on raws_17 r_23 (cost=0.00..864.77 rows=22,377 width=198) (actual time=0.003..1.821 rows=22,400 loops=1)

29. 1.821 1.821 ↓ 1.0 22,367 1

Seq Scan on raws_18 r_24 (cost=0.00..863.58 rows=22,358 width=198) (actual time=0.005..1.821 rows=22,367 loops=1)

30. 1.860 1.860 ↑ 1.0 22,571 1

Seq Scan on raws_19 r_25 (cost=0.00..873.21 rows=22,621 width=198) (actual time=0.003..1.860 rows=22,571 loops=1)

31. 1.821 1.821 ↑ 1.0 22,333 1

Seq Scan on raws_1a r_26 (cost=0.00..863.66 rows=22,366 width=199) (actual time=0.003..1.821 rows=22,333 loops=1)

32. 1.828 1.828 ↑ 1.0 22,578 1

Seq Scan on raws_1b r_27 (cost=0.00..873.09 rows=22,609 width=198) (actual time=0.003..1.828 rows=22,578 loops=1)

33. 1.846 1.846 ↑ 1.0 22,606 1

Seq Scan on raws_1c r_28 (cost=0.00..874.27 rows=22,627 width=199) (actual time=0.005..1.846 rows=22,606 loops=1)

34. 1.839 1.839 ↑ 1.0 22,330 1

Seq Scan on raws_1d r_29 (cost=0.00..864.68 rows=22,368 width=199) (actual time=0.003..1.839 rows=22,330 loops=1)

35. 1.946 1.946 ↑ 1.0 22,617 1

Seq Scan on raws_1e r_30 (cost=0.00..875.50 rows=22,650 width=199) (actual time=0.004..1.946 rows=22,617 loops=1)

36. 1.847 1.847 ↑ 1.0 22,517 1

Seq Scan on raws_1f r_31 (cost=0.00..870.29 rows=22,529 width=198) (actual time=0.003..1.847 rows=22,517 loops=1)

37. 1.871 1.871 ↑ 1.0 22,621 1

Seq Scan on raws_20 r_32 (cost=0.00..874.35 rows=22,635 width=199) (actual time=0.006..1.871 rows=22,621 loops=1)

38. 1.888 1.888 ↑ 1.0 22,741 1

Seq Scan on raws_21 r_33 (cost=0.00..879.58 rows=22,758 width=199) (actual time=0.003..1.888 rows=22,741 loops=1)

39. 1.861 1.861 ↑ 1.0 22,631 1

Seq Scan on raws_22 r_34 (cost=0.00..874.33 rows=22,633 width=198) (actual time=0.003..1.861 rows=22,631 loops=1)

40. 1.845 1.845 ↑ 1.0 22,561 1

Seq Scan on raws_23 r_35 (cost=0.00..871.63 rows=22,563 width=198) (actual time=0.003..1.845 rows=22,561 loops=1)

41. 1.861 1.861 ↓ 1.0 22,449 1

Seq Scan on raws_24 r_36 (cost=0.00..867.44 rows=22,444 width=198) (actual time=0.005..1.861 rows=22,449 loops=1)

42. 1.859 1.859 ↓ 1.0 22,733 1

Seq Scan on raws_25 r_37 (cost=0.00..878.32 rows=22,732 width=199) (actual time=0.004..1.859 rows=22,733 loops=1)

43. 1.888 1.888 ↑ 1.0 22,617 1

Seq Scan on raws_26 r_38 (cost=0.00..875.32 rows=22,632 width=199) (actual time=0.003..1.888 rows=22,617 loops=1)

44. 1.832 1.832 ↓ 1.0 22,711 1

Seq Scan on raws_27 r_39 (cost=0.00..877.98 rows=22,698 width=199) (actual time=0.005..1.832 rows=22,711 loops=1)

45. 1.874 1.874 ↓ 1.0 22,427 1

Seq Scan on raws_28 r_40 (cost=0.00..867.11 rows=22,411 width=199) (actual time=0.003..1.874 rows=22,427 loops=1)

46. 1.837 1.837 ↑ 1.0 22,490 1

Seq Scan on raws_29 r_41 (cost=0.00..870.09 rows=22,509 width=199) (actual time=0.003..1.837 rows=22,490 loops=1)

47. 1.827 1.827 ↓ 1.0 22,499 1

Seq Scan on raws_2a r_42 (cost=0.00..869.98 rows=22,498 width=199) (actual time=0.004..1.827 rows=22,499 loops=1)

48. 1.828 1.828 ↑ 1.0 22,595 1

Seq Scan on raws_2b r_43 (cost=0.00..874.09 rows=22,609 width=199) (actual time=0.004..1.828 rows=22,595 loops=1)

49. 0.691 0.691 ↑ 2.6 8,787 1

Seq Scan on raws_2c r_44 (cost=0.00..875.57 rows=22,657 width=199) (actual time=0.003..0.691 rows=8,787 loops=1)

50. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_2d r_45 (cost=0.00..879.57 rows=22,757 width=198) (never executed)

51. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_2e r_46 (cost=0.00..866.06 rows=22,406 width=199) (never executed)

52. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_2f r_47 (cost=0.00..874.23 rows=22,623 width=199) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_30 r_48 (cost=0.00..875.54 rows=22,654 width=199) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_31 r_49 (cost=0.00..863.52 rows=22,352 width=199) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_32 r_50 (cost=0.00..875.66 rows=22,666 width=199) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_33 r_51 (cost=0.00..883.88 rows=22,888 width=199) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_34 r_52 (cost=0.00..871.79 rows=22,579 width=199) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_35 r_53 (cost=0.00..871.82 rows=22,582 width=198) (never executed)

59. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_36 r_54 (cost=0.00..866.20 rows=22,420 width=198) (never executed)

60. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_37 r_55 (cost=0.00..865.90 rows=22,390 width=199) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_38 r_56 (cost=0.00..874.53 rows=22,653 width=198) (never executed)

62. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_39 r_57 (cost=0.00..872.93 rows=22,593 width=199) (never executed)

63. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_3a r_58 (cost=0.00..867.40 rows=22,440 width=199) (never executed)

64. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_3b r_59 (cost=0.00..881.10 rows=22,810 width=199) (never executed)

65. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_3c r_60 (cost=0.00..863.22 rows=22,322 width=199) (never executed)

66. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_3d r_61 (cost=0.00..876.99 rows=22,699 width=199) (never executed)

67. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_3e r_62 (cost=0.00..874.12 rows=22,612 width=199) (never executed)

68. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_3f r_63 (cost=0.00..868.80 rows=22,480 width=198) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_40 r_64 (cost=0.00..864.69 rows=22,369 width=198) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_41 r_65 (cost=0.00..871.42 rows=22,542 width=199) (never executed)

71. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_42 r_66 (cost=0.00..878.03 rows=22,703 width=199) (never executed)

72. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_43 r_67 (cost=0.00..876.92 rows=22,692 width=199) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_44 r_68 (cost=0.00..859.27 rows=22,227 width=199) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_45 r_69 (cost=0.00..879.89 rows=22,789 width=199) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_46 r_70 (cost=0.00..860.72 rows=22,272 width=199) (never executed)

76. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_47 r_71 (cost=0.00..867.59 rows=22,459 width=199) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_48 r_72 (cost=0.00..867.47 rows=22,447 width=199) (never executed)

78. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_49 r_73 (cost=0.00..864.95 rows=22,395 width=199) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_4a r_74 (cost=0.00..879.68 rows=22,768 width=198) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_4b r_75 (cost=0.00..880.88 rows=22,788 width=199) (never executed)

81. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_4c r_76 (cost=0.00..870.22 rows=22,522 width=199) (never executed)

82. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_4d r_77 (cost=0.00..870.16 rows=22,516 width=199) (never executed)

83. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_4e r_78 (cost=0.00..879.33 rows=22,733 width=199) (never executed)

84. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_4f r_79 (cost=0.00..879.73 rows=22,773 width=199) (never executed)

85. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_50 r_80 (cost=0.00..875.43 rows=22,643 width=199) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_51 r_81 (cost=0.00..868.45 rows=22,445 width=199) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_52 r_82 (cost=0.00..873.71 rows=22,571 width=199) (never executed)

88. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_53 r_83 (cost=0.00..862.14 rows=22,314 width=199) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_54 r_84 (cost=0.00..876.50 rows=22,650 width=199) (never executed)

90. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_55 r_85 (cost=0.00..867.54 rows=22,454 width=198) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_56 r_86 (cost=0.00..872.92 rows=22,592 width=199) (never executed)

92. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_57 r_87 (cost=0.00..874.06 rows=22,606 width=199) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_58 r_88 (cost=0.00..878.32 rows=22,732 width=198) (never executed)

94. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_59 r_89 (cost=0.00..878.18 rows=22,718 width=199) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_5a r_90 (cost=0.00..868.53 rows=22,453 width=199) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_5b r_91 (cost=0.00..876.70 rows=22,670 width=199) (never executed)

97. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_5c r_92 (cost=0.00..868.67 rows=22,467 width=199) (never executed)

98. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_5d r_93 (cost=0.00..874.16 rows=22,616 width=199) (never executed)

99. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_5e r_94 (cost=0.00..874.30 rows=22,630 width=199) (never executed)

100. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_5f r_95 (cost=0.00..868.74 rows=22,474 width=199) (never executed)

101. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_60 r_96 (cost=0.00..874.54 rows=22,654 width=199) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_61 r_97 (cost=0.00..872.54 rows=22,554 width=199) (never executed)

103. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_62 r_98 (cost=0.00..880.95 rows=22,795 width=198) (never executed)

104. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_63 r_99 (cost=0.00..878.39 rows=22,739 width=199) (never executed)

105. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_64 r_100 (cost=0.00..865.82 rows=22,382 width=199) (never executed)

106. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_65 r_101 (cost=0.00..866.48 rows=22,448 width=198) (never executed)

107. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_66 r_102 (cost=0.00..866.08 rows=22,408 width=199) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_67 r_103 (cost=0.00..883.77 rows=22,877 width=199) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_68 r_104 (cost=0.00..871.62 rows=22,562 width=198) (never executed)

110. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_69 r_105 (cost=0.00..871.47 rows=22,547 width=198) (never executed)

111. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_6a r_106 (cost=0.00..875.04 rows=22,604 width=199) (never executed)

112. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_6b r_107 (cost=0.00..873.19 rows=22,619 width=198) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_6c r_108 (cost=0.00..870.21 rows=22,521 width=199) (never executed)

114. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_6d r_109 (cost=0.00..868.84 rows=22,484 width=199) (never executed)

115. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_6e r_110 (cost=0.00..878.46 rows=22,746 width=198) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_6f r_111 (cost=0.00..879.23 rows=22,723 width=199) (never executed)

117. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_70 r_112 (cost=0.00..873.28 rows=22,628 width=198) (never executed)

118. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_71 r_113 (cost=0.00..878.33 rows=22,733 width=199) (never executed)

119. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_72 r_114 (cost=0.00..868.78 rows=22,478 width=199) (never executed)

120. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_73 r_115 (cost=0.00..872.76 rows=22,576 width=199) (never executed)

121. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_74 r_116 (cost=0.00..878.30 rows=22,730 width=199) (never executed)

122. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_75 r_117 (cost=0.00..870.65 rows=22,565 width=198) (never executed)

123. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_76 r_118 (cost=0.00..882.09 rows=22,809 width=199) (never executed)

124. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_77 r_119 (cost=0.00..873.14 rows=22,614 width=199) (never executed)

125. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_78 r_120 (cost=0.00..883.93 rows=22,893 width=199) (never executed)

126. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_79 r_121 (cost=0.00..866.11 rows=22,411 width=198) (never executed)

127. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_7a r_122 (cost=0.00..879.87 rows=22,787 width=198) (never executed)

128. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_7b r_123 (cost=0.00..870.33 rows=22,533 width=199) (never executed)

129. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_7c r_124 (cost=0.00..885.17 rows=22,917 width=199) (never executed)

130. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_7d r_125 (cost=0.00..874.18 rows=22,618 width=198) (never executed)

131. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_7e r_126 (cost=0.00..881.03 rows=22,803 width=198) (never executed)

132. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_7f r_127 (cost=0.00..862.42 rows=22,342 width=199) (never executed)

133. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_80 r_128 (cost=0.00..874.33 rows=22,633 width=199) (never executed)

134. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_81 r_129 (cost=0.00..875.64 rows=22,664 width=198) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_82 r_130 (cost=0.00..872.74 rows=22,574 width=199) (never executed)

136. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_83 r_131 (cost=0.00..881.20 rows=22,820 width=198) (never executed)

137. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_84 r_132 (cost=0.00..872.65 rows=22,565 width=199) (never executed)

138. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_85 r_133 (cost=0.00..867.59 rows=22,459 width=198) (never executed)

139. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_86 r_134 (cost=0.00..869.98 rows=22,498 width=199) (never executed)

140. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_87 r_135 (cost=0.00..869.82 rows=22,482 width=199) (never executed)

141. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_88 r_136 (cost=0.00..873.12 rows=22,612 width=198) (never executed)

142. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_89 r_137 (cost=0.00..871.50 rows=22,550 width=199) (never executed)

143. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_8a r_138 (cost=0.00..876.92 rows=22,692 width=199) (never executed)

144. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_8b r_139 (cost=0.00..876.77 rows=22,677 width=199) (never executed)

145. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_8c r_140 (cost=0.00..863.68 rows=22,368 width=198) (never executed)

146. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_8d r_141 (cost=0.00..866.22 rows=22,422 width=198) (never executed)

147. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_8e r_142 (cost=0.00..874.06 rows=22,606 width=199) (never executed)

148. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_8f r_143 (cost=0.00..868.98 rows=22,498 width=198) (never executed)

149. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_90 r_144 (cost=0.00..866.19 rows=22,419 width=198) (never executed)

150. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_91 r_145 (cost=0.00..879.45 rows=22,745 width=199) (never executed)

151. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_92 r_146 (cost=0.00..879.46 rows=22,746 width=199) (never executed)

152. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_93 r_147 (cost=0.00..873.12 rows=22,612 width=198) (never executed)

153. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_94 r_148 (cost=0.00..882.50 rows=22,850 width=198) (never executed)

154. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_95 r_149 (cost=0.00..875.61 rows=22,661 width=198) (never executed)

155. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_96 r_150 (cost=0.00..878.07 rows=22,707 width=199) (never executed)

156. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_97 r_151 (cost=0.00..878.15 rows=22,715 width=199) (never executed)

157. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_98 r_152 (cost=0.00..875.73 rows=22,673 width=199) (never executed)

158. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_99 r_153 (cost=0.00..883.68 rows=22,868 width=199) (never executed)

159. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_9a r_154 (cost=0.00..874.15 rows=22,615 width=199) (never executed)

160. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_9b r_155 (cost=0.00..878.32 rows=22,732 width=198) (never executed)

161. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_9c r_156 (cost=0.00..873.05 rows=22,605 width=199) (never executed)

162. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_9d r_157 (cost=0.00..880.93 rows=22,793 width=199) (never executed)

163. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_9e r_158 (cost=0.00..871.63 rows=22,563 width=199) (never executed)

164. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_9f r_159 (cost=0.00..875.58 rows=22,658 width=199) (never executed)

165. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a0 r_160 (cost=0.00..872.98 rows=22,598 width=199) (never executed)

166. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a1 r_161 (cost=0.00..876.92 rows=22,692 width=199) (never executed)

167. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a2 r_162 (cost=0.00..866.07 rows=22,407 width=199) (never executed)

168. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a3 r_163 (cost=0.00..875.53 rows=22,653 width=199) (never executed)

169. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a4 r_164 (cost=0.00..879.84 rows=22,784 width=198) (never executed)

170. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a5 r_165 (cost=0.00..865.03 rows=22,403 width=198) (never executed)

171. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a6 r_166 (cost=0.00..879.47 rows=22,747 width=199) (never executed)

172. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a7 r_167 (cost=0.00..875.41 rows=22,641 width=199) (never executed)

173. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a8 r_168 (cost=0.00..878.20 rows=22,720 width=199) (never executed)

174. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_a9 r_169 (cost=0.00..871.82 rows=22,582 width=198) (never executed)

175. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_aa r_170 (cost=0.00..870.11 rows=22,511 width=199) (never executed)

176. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ab r_171 (cost=0.00..878.59 rows=22,759 width=198) (never executed)

177. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ac r_172 (cost=0.00..872.77 rows=22,577 width=199) (never executed)

178. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ad r_173 (cost=0.00..878.21 rows=22,721 width=199) (never executed)

179. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ae r_174 (cost=0.00..868.74 rows=22,474 width=198) (never executed)

180. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_af r_175 (cost=0.00..877.00 rows=22,700 width=199) (never executed)

181. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b0 r_176 (cost=0.00..870.07 rows=22,507 width=199) (never executed)

182. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b1 r_177 (cost=0.00..872.78 rows=22,578 width=199) (never executed)

183. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b2 r_178 (cost=0.00..878.39 rows=22,739 width=199) (never executed)

184. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b3 r_179 (cost=0.00..883.75 rows=22,875 width=199) (never executed)

185. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b4 r_180 (cost=0.00..878.58 rows=22,758 width=198) (never executed)

186. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b5 r_181 (cost=0.00..872.65 rows=22,565 width=199) (never executed)

187. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b6 r_182 (cost=0.00..864.87 rows=22,387 width=199) (never executed)

188. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b7 r_183 (cost=0.00..872.92 rows=22,592 width=199) (never executed)

189. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b8 r_184 (cost=0.00..876.79 rows=22,679 width=199) (never executed)

190. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_b9 r_185 (cost=0.00..875.59 rows=22,659 width=199) (never executed)

191. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ba r_186 (cost=0.00..868.77 rows=22,477 width=199) (never executed)

192. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_bb r_187 (cost=0.00..874.03 rows=22,603 width=199) (never executed)

193. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_bc r_188 (cost=0.00..863.50 rows=22,350 width=199) (never executed)

194. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_bd r_189 (cost=0.00..872.83 rows=22,583 width=199) (never executed)

195. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_be r_190 (cost=0.00..861.00 rows=22,300 width=198) (never executed)

196. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_bf r_191 (cost=0.00..867.81 rows=22,481 width=198) (never executed)

197. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c0 r_192 (cost=0.00..874.11 rows=22,611 width=198) (never executed)

198. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c1 r_193 (cost=0.00..869.73 rows=22,473 width=199) (never executed)

199. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c2 r_194 (cost=0.00..872.93 rows=22,593 width=198) (never executed)

200. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c3 r_195 (cost=0.00..870.33 rows=22,533 width=199) (never executed)

201. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c4 r_196 (cost=0.00..875.62 rows=22,662 width=199) (never executed)

202. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c5 r_197 (cost=0.00..870.24 rows=22,524 width=199) (never executed)

203. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c6 r_198 (cost=0.00..871.78 rows=22,578 width=198) (never executed)

204. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c7 r_199 (cost=0.00..876.87 rows=22,687 width=198) (never executed)

205. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c8 r_200 (cost=0.00..872.63 rows=22,563 width=199) (never executed)

206. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_c9 r_201 (cost=0.00..882.48 rows=22,848 width=198) (never executed)

207. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ca r_202 (cost=0.00..871.51 rows=22,551 width=199) (never executed)

208. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_cb r_203 (cost=0.00..880.70 rows=22,770 width=199) (never executed)

209. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_cc r_204 (cost=0.00..882.31 rows=22,831 width=198) (never executed)

210. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_cd r_205 (cost=0.00..877.13 rows=22,713 width=198) (never executed)

211. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ce r_206 (cost=0.00..871.34 rows=22,534 width=198) (never executed)

212. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_cf r_207 (cost=0.00..859.61 rows=22,261 width=198) (never executed)

213. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d0 r_208 (cost=0.00..875.37 rows=22,637 width=199) (never executed)

214. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d1 r_209 (cost=0.00..871.43 rows=22,543 width=198) (never executed)

215. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d2 r_210 (cost=0.00..876.98 rows=22,698 width=198) (never executed)

216. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d3 r_211 (cost=0.00..867.56 rows=22,456 width=199) (never executed)

217. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d4 r_212 (cost=0.00..879.50 rows=22,750 width=199) (never executed)

218. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d5 r_213 (cost=0.00..873.94 rows=22,594 width=199) (never executed)

219. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d6 r_214 (cost=0.00..867.75 rows=22,475 width=198) (never executed)

220. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d7 r_215 (cost=0.00..876.78 rows=22,678 width=199) (never executed)

221. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d8 r_216 (cost=0.00..872.77 rows=22,577 width=199) (never executed)

222. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_d9 r_217 (cost=0.00..870.03 rows=22,503 width=199) (never executed)

223. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_da r_218 (cost=0.00..876.85 rows=22,685 width=199) (never executed)

224. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_db r_219 (cost=0.00..867.45 rows=22,445 width=199) (never executed)

225. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_dc r_220 (cost=0.00..887.47 rows=22,947 width=199) (never executed)

226. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_dd r_221 (cost=0.00..866.05 rows=22,405 width=199) (never executed)

227. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_de r_222 (cost=0.00..870.12 rows=22,512 width=199) (never executed)

228. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_df r_223 (cost=0.00..879.49 rows=22,749 width=199) (never executed)

229. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e0 r_224 (cost=0.00..866.12 rows=22,412 width=199) (never executed)

230. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e1 r_225 (cost=0.00..873.14 rows=22,614 width=198) (never executed)

231. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e2 r_226 (cost=0.00..874.40 rows=22,640 width=198) (never executed)

232. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e3 r_227 (cost=0.00..870.36 rows=22,536 width=198) (never executed)

233. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e4 r_228 (cost=0.00..863.50 rows=22,350 width=199) (never executed)

234. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e5 r_229 (cost=0.00..872.79 rows=22,579 width=199) (never executed)

235. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e6 r_230 (cost=0.00..871.67 rows=22,567 width=199) (never executed)

236. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e7 r_231 (cost=0.00..870.27 rows=22,527 width=198) (never executed)

237. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e8 r_232 (cost=0.00..872.82 rows=22,582 width=199) (never executed)

238. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_e9 r_233 (cost=0.00..878.13 rows=22,713 width=199) (never executed)

239. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ea r_234 (cost=0.00..870.06 rows=22,506 width=198) (never executed)

240. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_eb r_235 (cost=0.00..879.40 rows=22,740 width=199) (never executed)

241. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ec r_236 (cost=0.00..882.57 rows=22,857 width=198) (never executed)

242. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ed r_237 (cost=0.00..875.64 rows=22,664 width=199) (never executed)

243. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ee r_238 (cost=0.00..870.15 rows=22,515 width=198) (never executed)

244. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ef r_239 (cost=0.00..871.75 rows=22,575 width=199) (never executed)

245. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f0 r_240 (cost=0.00..881.88 rows=22,788 width=199) (never executed)

246. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f1 r_241 (cost=0.00..875.33 rows=22,633 width=199) (never executed)

247. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f2 r_242 (cost=0.00..877.04 rows=22,704 width=199) (never executed)

248. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f3 r_243 (cost=0.00..867.25 rows=22,425 width=199) (never executed)

249. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f4 r_244 (cost=0.00..875.49 rows=22,649 width=199) (never executed)

250. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f5 r_245 (cost=0.00..878.00 rows=22,700 width=199) (never executed)

251. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f6 r_246 (cost=0.00..872.81 rows=22,581 width=199) (never executed)

252. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f7 r_247 (cost=0.00..863.32 rows=22,332 width=199) (never executed)

253. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f8 r_248 (cost=0.00..871.63 rows=22,563 width=198) (never executed)

254. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_f9 r_249 (cost=0.00..869.77 rows=22,477 width=199) (never executed)

255. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_fa r_250 (cost=0.00..873.22 rows=22,622 width=198) (never executed)

256. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_fb r_251 (cost=0.00..870.22 rows=22,522 width=199) (never executed)

257. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_fc r_252 (cost=0.00..878.32 rows=22,732 width=199) (never executed)

258. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_fd r_253 (cost=0.00..866.12 rows=22,412 width=199) (never executed)

259. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_fe r_254 (cost=0.00..878.20 rows=22,720 width=199) (never executed)

260. 0.000 0.000 ↓ 0.0 0

Seq Scan on raws_ff r_255 (cost=0.00..878.92 rows=22,792 width=198) (never executed)

261. 78.913 156.998 ↑ 1.0 920,458 1

Hash (cost=20,189.39..20,189.39 rows=920,656 width=44) (actual time=156.998..156.998 rows=920,458 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 9587kB
262. 78.085 78.085 ↑ 1.0 920,458 1

Seq Scan on fast_search_domains_b3 e (cost=0.00..20,189.39 rows=920,656 width=44) (actual time=0.007..78.085 rows=920,458 loops=1)

  • Filter: (domain = '\xb33960790a6de22ca95a61c6d1310b3487304529cb0af6f3e9b80d2e5ddf76b8'::bytea)
  • Rows Removed by Filter: 3565
263. 0.004 0.026 ↑ 1.0 5 1

Hash (cost=9.48..9.48 rows=5 width=612) (actual time=0.026..0.026 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
264. 0.007 0.022 ↑ 1.0 5 1

Nested Loop Left Join (cost=0.14..9.48 rows=5 width=612) (actual time=0.016..0.022 rows=5 loops=1)

265. 0.005 0.005 ↑ 1.0 5 1

Seq Scan on files f (cost=0.00..2.05 rows=5 width=76) (actual time=0.003..0.005 rows=5 loops=1)

266. 0.010 0.010 ↑ 1.0 1 5

Index Scan using buckets_pkey on buckets b (cost=0.14..1.48 rows=1 width=536) (actual time=0.002..0.002 rows=1 loops=5)

  • Index Cond: (id = f.bucket_id)
Planning time : 9.307 ms
Execution time : 493.269 ms