explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fYph

Settings
# exclusive inclusive rows x rows loops node
1. 0.667 620.721 ↑ 4.5 650 1

Sort (cost=131,348.83..131,356.18 rows=2,939 width=117) (actual time=620.671..620.721 rows=650 loops=1)

  • Sort Key: t.fk_promo_id DESC
  • Sort Method: quicksort Memory: 137kB
  • Buffers: shared hit=427270
2. 8.706 620.054 ↑ 4.5 650 1

Nested Loop (cost=30,982.67..131,179.53 rows=2,939 width=117) (actual time=103.962..620.054 rows=650 loops=1)

  • Buffers: shared hit=427270
3. 22.681 186.396 ↓ 1.0 106,238 1

Hash Join (cost=30,982.24..38,477.25 rows=102,057 width=28) (actual time=103.614..186.396 rows=106,238 loops=1)

  • Hash Cond: (t.fk_promo_id = pr.promo_id)
  • Buffers: shared hit=1361
4. 53.702 163.676 ↑ 2.2 106,238 1

WindowAgg (cost=30,978.24..35,565.06 rows=229,341 width=24) (actual time=103.557..163.676 rows=106,238 loops=1)

  • Buffers: shared hit=1359
5. 26.014 109.974 ↑ 2.2 106,238 1

Sort (cost=30,978.24..31,551.59 rows=229,341 width=12) (actual time=103.543..109.974 rows=106,238 loops=1)

  • Sort Key: t.fk_promo_id, t.votes DESC
  • Sort Method: quicksort Memory: 8052kB
  • Buffers: shared hit=1359
6. 22.048 83.960 ↑ 2.2 106,238 1

Hash Join (cost=4,816.81..10,558.71 rows=229,341 width=12) (actual time=40.381..83.960 rows=106,238 loops=1)

  • Hash Cond: (t.fk_to_user_id = votetable.fk_to_user_id)
  • Buffers: shared hit=1359
7. 8.051 21.556 ↑ 2.2 106,238 1

Append (cost=0.00..5,127.11 rows=229,341 width=12) (actual time=0.006..21.556 rows=106,238 loops=1)

  • Buffers: shared hit=881
8. 0.011 0.011 ↑ 68.0 20 1

Seq Scan on user_votes_1 t (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.011 rows=20 loops=1)

  • Buffers: shared hit=1
9. 0.016 0.016 ↑ 68.0 20 1

Seq Scan on user_votes_2 t_1 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.015..0.016 rows=20 loops=1)

  • Buffers: shared hit=1
10. 0.009 0.009 ↑ 68.0 20 1

Seq Scan on user_votes_3 t_2 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.007..0.009 rows=20 loops=1)

  • Buffers: shared hit=1
11. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on user_votes_4 t_3 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.002..0.002 rows=0 loops=1)

12. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on user_votes_5 t_4 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.002..0.002 rows=0 loops=1)

13. 0.007 0.007 ↑ 68.0 20 1

Seq Scan on user_votes_6 t_5 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
14. 0.010 0.010 ↑ 68.0 20 1

Seq Scan on user_votes_7 t_6 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.008..0.010 rows=20 loops=1)

  • Buffers: shared hit=1
15. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on user_votes_8 t_7 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.002..0.002 rows=0 loops=1)

16. 0.006 0.006 ↑ 136.0 10 1

Seq Scan on user_votes_9 t_8 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.006 rows=10 loops=1)

  • Buffers: shared hit=1
17. 0.007 0.007 ↑ 68.0 20 1

Seq Scan on user_votes_12 t_9 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
18. 0.009 0.009 ↑ 68.0 20 1

Seq Scan on user_votes_13 t_10 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.008..0.009 rows=20 loops=1)

  • Buffers: shared hit=1
19. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_14 t_11 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
20. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_15 t_12 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
21. 0.007 0.007 ↑ 68.0 20 1

Seq Scan on user_votes_16 t_13 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
22. 0.009 0.009 ↑ 68.0 20 1

Seq Scan on user_votes_17 t_14 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.007..0.009 rows=20 loops=1)

  • Buffers: shared hit=1
23. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_18 t_15 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
24. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_19 t_16 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
25. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_20 t_17 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
26. 0.009 0.009 ↑ 68.0 20 1

Seq Scan on user_votes_21 t_18 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.007..0.009 rows=20 loops=1)

  • Buffers: shared hit=1
27. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_22 t_19 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
28. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_23 t_20 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
29. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_24 t_21 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
30. 0.009 0.009 ↑ 68.0 20 1

Seq Scan on user_votes_25 t_22 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.007..0.009 rows=20 loops=1)

  • Buffers: shared hit=1
31. 0.007 0.007 ↑ 68.0 20 1

Seq Scan on user_votes_26 t_23 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
32. 0.007 0.007 ↑ 68.0 20 1

Seq Scan on user_votes_27 t_24 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
33. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_28 t_25 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
34. 0.010 0.010 ↑ 68.0 20 1

Seq Scan on user_votes_29 t_26 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.008..0.010 rows=20 loops=1)

  • Buffers: shared hit=1
35. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_30 t_27 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
36. 0.007 0.007 ↑ 68.0 20 1

Seq Scan on user_votes_31 t_28 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
37. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_32 t_29 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
38. 0.009 0.009 ↑ 68.0 20 1

Seq Scan on user_votes_33 t_30 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.007..0.009 rows=20 loops=1)

  • Buffers: shared hit=1
39. 0.013 0.013 ↑ 68.0 20 1

Seq Scan on user_votes_34 t_31 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.007..0.013 rows=20 loops=1)

  • Buffers: shared hit=1
40. 0.011 0.011 ↑ 68.0 20 1

Seq Scan on user_votes_35 t_32 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.007..0.011 rows=20 loops=1)

  • Buffers: shared hit=1
41. 0.010 0.010 ↑ 68.0 20 1

Seq Scan on user_votes_36 t_33 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.006..0.010 rows=20 loops=1)

  • Buffers: shared hit=1
42. 0.013 0.013 ↑ 68.0 20 1

Seq Scan on user_votes_37 t_34 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.009..0.013 rows=20 loops=1)

  • Buffers: shared hit=1
43. 0.010 0.010 ↑ 68.0 20 1

Seq Scan on user_votes_38 t_35 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.006..0.010 rows=20 loops=1)

  • Buffers: shared hit=1
44. 0.010 0.010 ↑ 68.0 20 1

Seq Scan on user_votes_39 t_36 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.006..0.010 rows=20 loops=1)

  • Buffers: shared hit=1
45. 0.011 0.011 ↑ 68.0 20 1

Seq Scan on user_votes_40 t_37 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.006..0.011 rows=20 loops=1)

  • Buffers: shared hit=1
46. 0.015 0.015 ↑ 68.0 20 1

Seq Scan on user_votes_41 t_38 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.010..0.015 rows=20 loops=1)

  • Buffers: shared hit=1
47. 0.010 0.010 ↑ 68.0 20 1

Seq Scan on user_votes_42 t_39 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.006..0.010 rows=20 loops=1)

  • Buffers: shared hit=1
48. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_43 t_40 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
49. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_44 t_41 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
50. 0.009 0.009 ↑ 68.0 20 1

Seq Scan on user_votes_45 t_42 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.007..0.009 rows=20 loops=1)

  • Buffers: shared hit=1
51. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_46 t_43 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
52. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_47 t_44 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
53. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_48 t_45 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
54. 0.010 0.010 ↑ 68.0 20 1

Seq Scan on user_votes_49 t_46 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.008..0.010 rows=20 loops=1)

  • Buffers: shared hit=1
55. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_55 t_47 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
56. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_56 t_48 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
57. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_57 t_49 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
58. 0.008 0.008 ↑ 68.0 20 1

Seq Scan on user_votes_58 t_50 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.006..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
59. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_59 t_51 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
60. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_60 t_52 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
61. 0.008 0.008 ↑ 68.0 20 1

Seq Scan on user_votes_61 t_53 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.006..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
62. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_62 t_54 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
63. 0.007 0.007 ↑ 68.0 20 1

Seq Scan on user_votes_63 t_55 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
64. 0.007 0.007 ↑ 68.0 20 1

Seq Scan on user_votes_64 t_56 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
65. 0.008 0.008 ↑ 68.0 20 1

Seq Scan on user_votes_65 t_57 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.006..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
66. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_66 t_58 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
67. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_67 t_59 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
68. 0.006 0.006 ↑ 71.6 19 1

Seq Scan on user_votes_68 t_60 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=19 loops=1)

  • Buffers: shared hit=1
69. 0.008 0.008 ↑ 68.0 20 1

Seq Scan on user_votes_69 t_61 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.006..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
70. 0.007 0.007 ↑ 68.0 20 1

Seq Scan on user_votes_70 t_62 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
71. 0.006 0.006 ↑ 71.6 19 1

Seq Scan on user_votes_71 t_63 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=19 loops=1)

  • Buffers: shared hit=1
72. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_72 t_64 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
73. 0.008 0.008 ↑ 68.0 20 1

Seq Scan on user_votes_73 t_65 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.006..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
74. 0.006 0.006 ↑ 71.6 19 1

Seq Scan on user_votes_74 t_66 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=19 loops=1)

  • Buffers: shared hit=1
75. 0.006 0.006 ↑ 71.6 19 1

Seq Scan on user_votes_75 t_67 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=19 loops=1)

  • Buffers: shared hit=1
76. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_76 t_68 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
77. 0.008 0.008 ↑ 68.0 20 1

Seq Scan on user_votes_77 t_69 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.007..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
78. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_78 t_70 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
79. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_79 t_71 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
80. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_80 t_72 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
81. 0.008 0.008 ↑ 68.0 20 1

Seq Scan on user_votes_81 t_73 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.006..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
82. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_82 t_74 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
83. 0.007 0.007 ↑ 68.0 20 1

Seq Scan on user_votes_83 t_75 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
84. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_84 t_76 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
85. 0.009 0.009 ↑ 68.0 20 1

Seq Scan on user_votes_85 t_77 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.007..0.009 rows=20 loops=1)

  • Buffers: shared hit=1
86. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_86 t_78 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
87. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_87 t_79 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
88. 0.005 0.005 ↑ 68.0 20 1

Seq Scan on user_votes_88 t_80 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
89. 0.008 0.008 ↑ 68.0 20 1

Seq Scan on user_votes_89 t_81 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.006..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
90. 0.019 0.019 ↑ 68.0 20 1

Seq Scan on user_votes_90 t_82 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.016..0.019 rows=20 loops=1)

  • Buffers: shared hit=1
91. 0.008 0.008 ↑ 68.0 20 1

Seq Scan on user_votes_91 t_83 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.005..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
92. 0.008 0.008 ↑ 68.0 20 1

Seq Scan on user_votes_92 t_84 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.006..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
93. 0.008 0.008 ↑ 68.0 20 1

Seq Scan on user_votes_93 t_85 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.006..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
94. 0.006 0.006 ↑ 68.0 20 1

Seq Scan on user_votes_94 t_86 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
95. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on user_votes_95 t_87 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.002..0.002 rows=0 loops=1)

96. 12.836 12.836 ↑ 1.0 104,572 1

Seq Scan on user_votes_96 t_88 (cost=0.00..1,880.01 rows=108,301 width=12) (actual time=0.007..12.836 rows=104,572 loops=1)

  • Buffers: shared hit=797
97. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on user_votes_97 t_89 (cost=0.00..23.60 rows=1,360 width=12) (actual time=0.013..0.013 rows=0 loops=1)

98. 2.011 40.356 ↓ 71.6 14,321 1

Hash (cost=4,814.31..4,814.31 rows=200 width=4) (actual time=40.356..40.356 rows=14,321 loops=1)

  • Buckets: 16384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 632kB
  • Buffers: shared hit=478
99. 1.354 38.345 ↓ 71.6 14,321 1

Subquery Scan on votetable (cost=4,762.64..4,814.31 rows=200 width=4) (actual time=27.737..38.345 rows=14,321 loops=1)

  • Buffers: shared hit=478
100. 3.277 36.991 ↓ 71.6 14,321 1

Finalize GroupAggregate (cost=4,762.64..4,812.31 rows=200 width=12) (actual time=27.736..36.991 rows=14,321 loops=1)

  • Group Key: v_88.fk_to_user_id
  • Buffers: shared hit=478
101. 0.000 33.714 ↓ 64.6 25,822 1

Gather Merge (cost=4,762.64..4,809.31 rows=400 width=4) (actual time=27.728..33.714 rows=25,822 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=895
102. 9.231 56.742 ↓ 43.0 8,607 3

Sort (cost=3,762.62..3,763.12 rows=200 width=4) (actual time=17.927..18.914 rows=8,607 loops=3)

  • Sort Key: v_88.fk_to_user_id
  • Sort Method: quicksort Memory: 900kB
  • Worker 0: Sort Method: quicksort Memory: 559kB
  • Worker 1: Sort Method: quicksort Memory: 521kB
  • Buffers: shared hit=895
103. 25.458 47.511 ↓ 43.0 8,607 3

Partial HashAggregate (cost=3,752.97..3,754.97 rows=200 width=4) (actual time=14.622..15.837 rows=8,607 loops=3)

  • Group Key: v_88.fk_to_user_id
  • Buffers: shared hit=881
104. 8.515 22.053 ↑ 2.7 35,413 3

Parallel Append (cost=0.00..3,514.00 rows=95,588 width=4) (actual time=0.018..7.351 rows=35,413 loops=3)

  • Buffers: shared hit=881
105. 13.215 13.215 ↑ 1.8 34,857 3

Parallel Seq Scan on user_votes_96 v_88 (cost=0.00..1,434.06 rows=63,706 width=4) (actual time=0.017..4.405 rows=34,857 loops=3)

  • Buffers: shared hit=797
106. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_1 v (cost=0.00..18.00 rows=800 width=4) (actual time=0.001..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
107. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_2 v_1 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
108. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_3 v_2 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
109. 0.000 0.000 ↓ 0.0 0 1

Parallel Seq Scan on user_votes_4 v_3 (cost=0.00..18.00 rows=800 width=4) (actual time=0.000..0.000 rows=0 loops=1)

110. 0.000 0.000 ↓ 0.0 0 1

Parallel Seq Scan on user_votes_5 v_4 (cost=0.00..18.00 rows=800 width=4) (actual time=0.000..0.000 rows=0 loops=1)

111. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_6 v_5 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
112. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_7 v_6 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
113. 0.000 0.000 ↓ 0.0 0 1

Parallel Seq Scan on user_votes_8 v_7 (cost=0.00..18.00 rows=800 width=4) (actual time=0.000..0.000 rows=0 loops=1)

114. 0.002 0.002 ↑ 80.0 10 1

Parallel Seq Scan on user_votes_9 v_8 (cost=0.00..18.00 rows=800 width=4) (actual time=0.001..0.002 rows=10 loops=1)

  • Buffers: shared hit=1
115. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_12 v_9 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
116. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_13 v_10 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
117. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_14 v_11 (cost=0.00..18.00 rows=800 width=4) (actual time=0.003..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
118. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_15 v_12 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
119. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_16 v_13 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
120. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_17 v_14 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
121. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_18 v_15 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
122. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_19 v_16 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
123. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_20 v_17 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
124. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_21 v_18 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
125. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_22 v_19 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
126. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_23 v_20 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
127. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_24 v_21 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
128. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_25 v_22 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
129. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_26 v_23 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
130. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_27 v_24 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
131. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_28 v_25 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
132. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_29 v_26 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
133. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_30 v_27 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
134. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_31 v_28 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
135. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_32 v_29 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
136. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_33 v_30 (cost=0.00..18.00 rows=800 width=4) (actual time=0.003..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
137. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_34 v_31 (cost=0.00..18.00 rows=800 width=4) (actual time=0.003..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
138. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_35 v_32 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
139. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_36 v_33 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
140. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_37 v_34 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
141. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_38 v_35 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
142. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_39 v_36 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
143. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_40 v_37 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
144. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_41 v_38 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
145. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_42 v_39 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
146. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_43 v_40 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
147. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_44 v_41 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
148. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_45 v_42 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
149. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_46 v_43 (cost=0.00..18.00 rows=800 width=4) (actual time=0.003..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
150. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_47 v_44 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
151. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_48 v_45 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
152. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_49 v_46 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
153. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_55 v_47 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
154. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_56 v_48 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
155. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_57 v_49 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
156. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_58 v_50 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
157. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_59 v_51 (cost=0.00..18.00 rows=800 width=4) (actual time=0.003..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
158. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_60 v_52 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
159. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_61 v_53 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
160. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_62 v_54 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
161. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_63 v_55 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
162. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_64 v_56 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
163. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_65 v_57 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
164. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_66 v_58 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
165. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_67 v_59 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
166. 0.004 0.004 ↑ 42.1 19 1

Parallel Seq Scan on user_votes_68 v_60 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=19 loops=1)

  • Buffers: shared hit=1
167. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_69 v_61 (cost=0.00..18.00 rows=800 width=4) (actual time=0.003..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
168. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_70 v_62 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
169. 0.003 0.003 ↑ 42.1 19 1

Parallel Seq Scan on user_votes_71 v_63 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=19 loops=1)

  • Buffers: shared hit=1
170. 0.006 0.006 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_72 v_64 (cost=0.00..18.00 rows=800 width=4) (actual time=0.003..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
171. 0.006 0.006 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_73 v_65 (cost=0.00..18.00 rows=800 width=4) (actual time=0.003..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
172. 0.004 0.004 ↑ 42.1 19 1

Parallel Seq Scan on user_votes_74 v_66 (cost=0.00..18.00 rows=800 width=4) (actual time=0.003..0.004 rows=19 loops=1)

  • Buffers: shared hit=1
173. 0.003 0.003 ↑ 42.1 19 1

Parallel Seq Scan on user_votes_75 v_67 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=19 loops=1)

  • Buffers: shared hit=1
174. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_76 v_68 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
175. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_77 v_69 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
176. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_78 v_70 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
177. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_79 v_71 (cost=0.00..18.00 rows=800 width=4) (actual time=0.003..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
178. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_80 v_72 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
179. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_81 v_73 (cost=0.00..18.00 rows=800 width=4) (actual time=0.003..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
180. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_82 v_74 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
181. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_83 v_75 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
182. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_84 v_76 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
183. 0.011 0.011 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_85 v_77 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.011 rows=20 loops=1)

  • Buffers: shared hit=1
184. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_86 v_78 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
185. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_87 v_79 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
186. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_88 v_80 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
187. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_89 v_81 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
188. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_90 v_82 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
189. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_91 v_83 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
190. 0.003 0.003 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_92 v_84 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
191. 0.004 0.004 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_93 v_85 (cost=0.00..18.00 rows=800 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
192. 0.007 0.007 ↑ 40.0 20 1

Parallel Seq Scan on user_votes_94 v_86 (cost=0.00..18.00 rows=800 width=4) (actual time=0.005..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
193. 0.000 0.000 ↓ 0.0 0 1

Parallel Seq Scan on user_votes_95 v_87 (cost=0.00..18.00 rows=800 width=4) (actual time=0.000..0.000 rows=0 loops=1)

194. 0.000 0.000 ↓ 0.0 0 1

Parallel Seq Scan on user_votes_97 v_89 (cost=0.00..18.00 rows=800 width=4) (actual time=0.000..0.000 rows=0 loops=1)

195. 0.016 0.039 ↑ 1.0 89 1

Hash (cost=2.89..2.89 rows=89 width=12) (actual time=0.039..0.039 rows=89 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=2
196. 0.023 0.023 ↑ 1.0 89 1

Seq Scan on promos pr (cost=0.00..2.89 rows=89 width=12) (actual time=0.013..0.023 rows=89 loops=1)

  • Buffers: shared hit=2
197. 424.952 424.952 ↓ 0.0 0 106,238

Index Scan using pk_users on users u (cost=0.43..0.91 rows=1 width=93) (actual time=0.004..0.004 rows=0 loops=106,238)

  • Index Cond: (user_id = t.fk_to_user_id)
  • Filter: (user_name ~~* '%pe%'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=425909
Planning time : 9.142 ms