explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Svqq

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 1,354 1

Hash Join (cost=0..0 rows=0 width=0) (actual rows=1,354 loops=1)

2. 0.000 0.000 ↓ 0.0 1,354 1

Nested Loop (cost=0..0 rows=0 width=0) (actual rows=1,354 loops=1)

3. 0.000 0.000 ↓ 0.0 1,354 1

Nested Loop (cost=0..0 rows=0 width=0) (actual rows=1,354 loops=1)

4. 0.000 0.000 ↓ 0.0 1,354 1

Merge Join (cost=0..0 rows=0 width=0) (actual rows=1,354 loops=1)

5. 0.000 0.000 ↓ 0.0 16,644 1

Sort (cost=0..0 rows=0 width=0) (actual rows=16,644 loops=1)

  • Sort Key: r.phpsessid, r.searchid
  • Sort Method: quicksort Memory: 11,955kB
6. 0.000 0.000 ↓ 0.0 16,644 1

Append (cost=0..0 rows=0 width=0) (actual rows=16,644 loops=1)

7. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2013_1_141093 r (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

8. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2013_2_141125 r_1 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

9. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2013_3_141157 r_2 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

10. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2013_4_141189 r_3 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

11. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2013_5_141221 r_4 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

12. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2013_6_141253 r_5 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

13. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2013_7_141285 r_6 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

14. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2013_8_141317 r_7 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

15. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2013_9_141349 r_8 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

16. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2013_10_141381 r_9 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

17. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2013_11_141413 r_10 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

18. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2013_12_141445 r_11 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

19. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2014_1_141477 r_12 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

20. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2014_2_141509 r_13 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

21. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2014_3_141541 r_14 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

22. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2014_4_141573 r_15 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

23. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2014_5_141605 r_16 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

24. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2014_6_141637 r_17 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

25. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2014_7_141669 r_18 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

26. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2014_8_141701 r_19 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

27. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2014_9_141733 r_20 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

28. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2014_10_141765 r_21 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

29. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2014_11_141797 r_22 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

30. 0.000 0.000 ↓ 0.0 11 1

Seq Scan on reservations_sh_2014_12_141829 r_23 (cost=0..0 rows=0 width=0) (actual rows=11 loops=1)

31. 0.000 0.000 ↓ 0.0 33 1

Seq Scan on reservations_sh_2015_1_141861 r_24 (cost=0..0 rows=0 width=0) (actual rows=33 loops=1)

32. 0.000 0.000 ↓ 0.0 43 1

Seq Scan on reservations_sh_2015_2_141893 r_25 (cost=0..0 rows=0 width=0) (actual rows=43 loops=1)

33. 0.000 0.000 ↓ 0.0 68 1

Seq Scan on reservations_sh_2015_3_141925 r_26 (cost=0..0 rows=0 width=0) (actual rows=68 loops=1)

34. 0.000 0.000 ↓ 0.0 64 1

Seq Scan on reservations_sh_2015_4_141957 r_27 (cost=0..0 rows=0 width=0) (actual rows=64 loops=1)

35. 0.000 0.000 ↓ 0.0 72 1

Seq Scan on reservations_sh_2015_5_141989 r_28 (cost=0..0 rows=0 width=0) (actual rows=72 loops=1)

36. 0.000 0.000 ↓ 0.0 60 1

Seq Scan on reservations_sh_2015_6_142021 r_29 (cost=0..0 rows=0 width=0) (actual rows=60 loops=1)

37. 0.000 0.000 ↓ 0.0 84 1

Seq Scan on reservations_sh_2015_7_142053 r_30 (cost=0..0 rows=0 width=0) (actual rows=84 loops=1)

38. 0.000 0.000 ↓ 0.0 65 1

Seq Scan on reservations_sh_2015_8_142085 r_31 (cost=0..0 rows=0 width=0) (actual rows=65 loops=1)

39. 0.000 0.000 ↓ 0.0 59 1

Seq Scan on reservations_sh_2015_9_142117 r_32 (cost=0..0 rows=0 width=0) (actual rows=59 loops=1)

40. 0.000 0.000 ↓ 0.0 63 1

Seq Scan on reservations_sh_2015_10_142149 r_33 (cost=0..0 rows=0 width=0) (actual rows=63 loops=1)

41. 0.000 0.000 ↓ 0.0 55 1

Seq Scan on reservations_sh_2015_11_142181 r_34 (cost=0..0 rows=0 width=0) (actual rows=55 loops=1)

42. 0.000 0.000 ↓ 0.0 44 1

Seq Scan on reservations_sh_2015_12_142213 r_35 (cost=0..0 rows=0 width=0) (actual rows=44 loops=1)

43. 0.000 0.000 ↓ 0.0 100 1

Seq Scan on reservations_sh_2016_1_142245 r_36 (cost=0..0 rows=0 width=0) (actual rows=100 loops=1)

44. 0.000 0.000 ↓ 0.0 104 1

Seq Scan on reservations_sh_2016_2_142277 r_37 (cost=0..0 rows=0 width=0) (actual rows=104 loops=1)

45. 0.000 0.000 ↓ 0.0 135 1

Seq Scan on reservations_sh_2016_3_142309 r_38 (cost=0..0 rows=0 width=0) (actual rows=135 loops=1)

46. 0.000 0.000 ↓ 0.0 100 1

Seq Scan on reservations_sh_2016_4_142341 r_39 (cost=0..0 rows=0 width=0) (actual rows=100 loops=1)

47. 0.000 0.000 ↓ 0.0 156 1

Seq Scan on reservations_sh_2016_5_142373 r_40 (cost=0..0 rows=0 width=0) (actual rows=156 loops=1)

48. 0.000 0.000 ↓ 0.0 146 1

Seq Scan on reservations_sh_2016_6_142405 r_41 (cost=0..0 rows=0 width=0) (actual rows=146 loops=1)

49. 0.000 0.000 ↓ 0.0 141 1

Seq Scan on reservations_sh_2016_7_142437 r_42 (cost=0..0 rows=0 width=0) (actual rows=141 loops=1)

50. 0.000 0.000 ↓ 0.0 140 1

Seq Scan on reservations_sh_2016_8_142469 r_43 (cost=0..0 rows=0 width=0) (actual rows=140 loops=1)

51. 0.000 0.000 ↓ 0.0 148 1

Seq Scan on reservations_sh_2016_9_142501 r_44 (cost=0..0 rows=0 width=0) (actual rows=148 loops=1)

52. 0.000 0.000 ↓ 0.0 114 1

Seq Scan on reservations_sh_2016_10_142533 r_45 (cost=0..0 rows=0 width=0) (actual rows=114 loops=1)

53. 0.000 0.000 ↓ 0.0 109 1

Seq Scan on reservations_sh_2016_11_142565 r_46 (cost=0..0 rows=0 width=0) (actual rows=109 loops=1)

54. 0.000 0.000 ↓ 0.0 105 1

Seq Scan on reservations_sh_2016_12_142597 r_47 (cost=0..0 rows=0 width=0) (actual rows=105 loops=1)

55. 0.000 0.000 ↓ 0.0 201 1

Seq Scan on reservations_sh_2017_1_142629 r_48 (cost=0..0 rows=0 width=0) (actual rows=201 loops=1)

56. 0.000 0.000 ↓ 0.0 206 1

Seq Scan on reservations_sh_2017_2_142661 r_49 (cost=0..0 rows=0 width=0) (actual rows=206 loops=1)

57. 0.000 0.000 ↓ 0.0 239 1

Seq Scan on reservations_sh_2017_3_142693 r_50 (cost=0..0 rows=0 width=0) (actual rows=239 loops=1)

58. 0.000 0.000 ↓ 0.0 229 1

Seq Scan on reservations_sh_2017_4_142725 r_51 (cost=0..0 rows=0 width=0) (actual rows=229 loops=1)

59. 0.000 0.000 ↓ 0.0 255 1

Seq Scan on reservations_sh_2017_5_142757 r_52 (cost=0..0 rows=0 width=0) (actual rows=255 loops=1)

60. 0.000 0.000 ↓ 0.0 236 1

Seq Scan on reservations_sh_2017_6_142789 r_53 (cost=0..0 rows=0 width=0) (actual rows=236 loops=1)

61. 0.000 0.000 ↓ 0.0 223 1

Seq Scan on reservations_sh_2017_7_142821 r_54 (cost=0..0 rows=0 width=0) (actual rows=223 loops=1)

62. 0.000 0.000 ↓ 0.0 224 1

Seq Scan on reservations_sh_2017_8_142853 r_55 (cost=0..0 rows=0 width=0) (actual rows=224 loops=1)

63. 0.000 0.000 ↓ 0.0 176 1

Seq Scan on reservations_sh_2017_9_142885 r_56 (cost=0..0 rows=0 width=0) (actual rows=176 loops=1)

64. 0.000 0.000 ↓ 0.0 209 1

Seq Scan on reservations_sh_2017_10_142917 r_57 (cost=0..0 rows=0 width=0) (actual rows=209 loops=1)

65. 0.000 0.000 ↓ 0.0 199 1

Seq Scan on reservations_sh_2017_11_142949 r_58 (cost=0..0 rows=0 width=0) (actual rows=199 loops=1)

66. 0.000 0.000 ↓ 0.0 183 1

Seq Scan on reservations_sh_2017_12_142981 r_59 (cost=0..0 rows=0 width=0) (actual rows=183 loops=1)

67. 0.000 0.000 ↓ 0.0 344 1

Seq Scan on reservations_sh_2018_1_143013 r_60 (cost=0..0 rows=0 width=0) (actual rows=344 loops=1)

68. 0.000 0.000 ↓ 0.0 305 1

Seq Scan on reservations_sh_2018_2_143045 r_61 (cost=0..0 rows=0 width=0) (actual rows=305 loops=1)

69. 0.000 0.000 ↓ 0.0 350 1

Seq Scan on reservations_sh_2018_3_143077 r_62 (cost=0..0 rows=0 width=0) (actual rows=350 loops=1)

70. 0.000 0.000 ↓ 0.0 415 1

Seq Scan on reservations_sh_2018_4_143109 r_63 (cost=0..0 rows=0 width=0) (actual rows=415 loops=1)

71. 0.000 0.000 ↓ 0.0 426 1

Seq Scan on reservations_sh_2018_5_143141 r_64 (cost=0..0 rows=0 width=0) (actual rows=426 loops=1)

72. 0.000 0.000 ↓ 0.0 380 1

Seq Scan on reservations_sh_2018_6_143173 r_65 (cost=0..0 rows=0 width=0) (actual rows=380 loops=1)

73. 0.000 0.000 ↓ 0.0 346 1

Seq Scan on reservations_sh_2018_7_143205 r_66 (cost=0..0 rows=0 width=0) (actual rows=346 loops=1)

74. 0.000 0.000 ↓ 0.0 318 1

Seq Scan on reservations_sh_2018_8_143237 r_67 (cost=0..0 rows=0 width=0) (actual rows=318 loops=1)

75. 0.000 0.000 ↓ 0.0 259 1

Seq Scan on reservations_sh_2018_9_143269 r_68 (cost=0..0 rows=0 width=0) (actual rows=259 loops=1)

76. 0.000 0.000 ↓ 0.0 257 1

Seq Scan on reservations_sh_2018_10_143301 r_69 (cost=0..0 rows=0 width=0) (actual rows=257 loops=1)

77. 0.000 0.000 ↓ 0.0 252 1

Seq Scan on reservations_sh_2018_11_143333 r_70 (cost=0..0 rows=0 width=0) (actual rows=252 loops=1)

78. 0.000 0.000 ↓ 0.0 262 1

Seq Scan on reservations_sh_2018_12_143365 r_71 (cost=0..0 rows=0 width=0) (actual rows=262 loops=1)

79. 0.000 0.000 ↓ 0.0 379 1

Seq Scan on reservations_sh_2019_1_143397 r_72 (cost=0..0 rows=0 width=0) (actual rows=379 loops=1)

80. 0.000 0.000 ↓ 0.0 420 1

Seq Scan on reservations_sh_2019_2_143429 r_73 (cost=0..0 rows=0 width=0) (actual rows=420 loops=1)

81. 0.000 0.000 ↓ 0.0 465 1

Seq Scan on reservations_sh_2019_3_143461 r_74 (cost=0..0 rows=0 width=0) (actual rows=465 loops=1)

82. 0.000 0.000 ↓ 0.0 462 1

Seq Scan on reservations_sh_2019_4_143493 r_75 (cost=0..0 rows=0 width=0) (actual rows=462 loops=1)

83. 0.000 0.000 ↓ 0.0 525 1

Seq Scan on reservations_sh_2019_5_143525 r_76 (cost=0..0 rows=0 width=0) (actual rows=525 loops=1)

84. 0.000 0.000 ↓ 0.0 609 1

Seq Scan on reservations_sh_2019_6_143557 r_77 (cost=0..0 rows=0 width=0) (actual rows=609 loops=1)

85. 0.000 0.000 ↓ 0.0 620 1

Seq Scan on reservations_sh_2019_7_143589 r_78 (cost=0..0 rows=0 width=0) (actual rows=620 loops=1)

86. 0.000 0.000 ↓ 0.0 543 1

Seq Scan on reservations_sh_2019_8_143621 r_79 (cost=0..0 rows=0 width=0) (actual rows=543 loops=1)

87. 0.000 0.000 ↓ 0.0 450 1

Seq Scan on reservations_sh_2019_9_143653 r_80 (cost=0..0 rows=0 width=0) (actual rows=450 loops=1)

88. 0.000 0.000 ↓ 0.0 434 1

Seq Scan on reservations_sh_2019_10_143685 r_81 (cost=0..0 rows=0 width=0) (actual rows=434 loops=1)

89. 0.000 0.000 ↓ 0.0 440 1

Seq Scan on reservations_sh_2019_11_143717 r_82 (cost=0..0 rows=0 width=0) (actual rows=440 loops=1)

90. 0.000 0.000 ↓ 0.0 444 1

Seq Scan on reservations_sh_2019_12_143749 r_83 (cost=0..0 rows=0 width=0) (actual rows=444 loops=1)

91. 0.000 0.000 ↓ 0.0 691 1

Seq Scan on reservations_sh_2020_1_143781 r_84 (cost=0..0 rows=0 width=0) (actual rows=691 loops=1)

92. 0.000 0.000 ↓ 0.0 568 1

Seq Scan on reservations_sh_2020_2_143813 r_85 (cost=0..0 rows=0 width=0) (actual rows=568 loops=1)

93. 0.000 0.000 ↓ 0.0 79 1

Seq Scan on reservations_sh_2020_3_143845 r_86 (cost=0..0 rows=0 width=0) (actual rows=79 loops=1)

94. 0.000 0.000 ↓ 0.0 42 1

Seq Scan on reservations_sh_2020_4_143877 r_87 (cost=0..0 rows=0 width=0) (actual rows=42 loops=1)

95. 0.000 0.000 ↓ 0.0 140 1

Seq Scan on reservations_sh_2020_5_143909 r_88 (cost=0..0 rows=0 width=0) (actual rows=140 loops=1)

96. 0.000 0.000 ↓ 0.0 48 1

Seq Scan on reservations_sh_2020_6_143941 r_89 (cost=0..0 rows=0 width=0) (actual rows=48 loops=1)

97. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2020_7_143973 r_90 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

98. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2020_8_144005 r_91 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

99. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2020_9_144037 r_92 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

100. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2020_10_144069 r_93 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

101. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2020_11_144101 r_94 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

102. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2020_12_144133 r_95 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

103. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2021_1_144165 r_96 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

104. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2021_2_144197 r_97 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

105. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2021_3_144229 r_98 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

106. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2021_4_144261 r_99 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

107. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2021_5_144293 r_100 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

108. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2021_6_144325 r_101 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

109. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2021_7_144357 r_102 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

110. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2021_8_144389 r_103 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

111. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2021_9_144421 r_104 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

112. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2021_10_144453 r_105 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

113. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2021_11_144485 r_106 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

114. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on reservations_sh_2021_12_144517 r_107 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

115. 0.000 0.000 ↓ 0.0 572 1

Seq Scan on reservations_sh_default_141061 r_108 (cost=0..0 rows=0 width=0) (actual rows=572 loops=1)

116. 0.000 0.000 ↓ 0.0 34,108 1

Sort (cost=0..0 rows=0 width=0) (actual rows=34,108 loops=1)

  • Sort Key: s.phpsessid, s.searchid
  • Sort Method: quicksort Memory: 6,333kB
117. 0.000 0.000 ↓ 0.0 34,108 1

Append (cost=0..0 rows=0 width=0) (actual rows=34,108 loops=1)

118. 0.000 0.000 ↓ 0.0 34,086 1

Seq Scan on stats_2019_1_125600 s (cost=0..0 rows=0 width=0) (actual rows=34,086 loops=1)

  • Filter: ((searchid IS NOT NULL) AND (createdate >= '2019-01-01'::date) AND (createdate <= '2019-01-31'::date))
119. 0.000 0.000 ↓ 0.0 22 1

Bitmap Heap Scan on stats_default_123264 s_1 (cost=0..0 rows=0 width=0) (actual rows=22 loops=1)

  • Filter: (searchid IS NOT NULL)
  • Heap Blocks: exact=7
120. 0.000 0.000 ↓ 0.0 39 1

Bitmap Index Scan on stats_default_123264_createdate_idx1 (cost=0..0 rows=0 width=0) (actual rows=39 loops=1)

  • Index Cond: ((createdate >= '2019-01-01'::date) AND (createdate <= '2019-01-31'::date))
121. 0.000 0.000 ↓ 0.0 1 1,354

Index Scan using stats_remoteaddr_id_144551 on stats_remoteaddr_144551 st2 (cost=0..0 rows=0 width=0) (actual rows=1 loops=1,354)

  • Index Cond: (id = s.id)
  • Filter: ((s.phpsessid)::text = (phpsessid)::text)
122. 0.000 0.000 ↓ 0.0 1 1,354

Index Scan using ip_ipv4_network_ip4r_130467 on ip_ipv4_130467 v4 (cost=0..0 rows=0 width=0) (actual rows=1 loops=1,354)

  • Index Cond: (network_ip4r >>= st2.remoteaddr)
123. 0.000 0.000 ↓ 0.0 249 1

Hash (cost=0..0 rows=0 width=0) (actual rows=249 loops=1)

124. 0.000 0.000 ↓ 0.0 249 1

Seq Scan on ip_locations_en_130468 le (cost=0..0 rows=0 width=0) (actual rows=249 loops=1)