explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oUBw

Settings
# exclusive inclusive rows x rows loops node
1. 16.602 632.891 ↓ 0.0 0 1

Subquery Scan on x (cost=50,048.80..61,619.21 rows=551 width=20) (actual time=632.891..632.891 rows=0 loops=1)

  • Filter: ((x.pos <= 3) AND (x.fk_to_user_id = 9861752))
  • Rows Removed by Filter: 240427
  • Buffers: shared hit=3526, temp read=234641 written=1410
2. 394.057 616.289 ↑ 1.4 240,427 1

WindowAgg (cost=50,048.80..56,660.46 rows=330,583 width=24) (actual time=195.552..616.289 rows=240,427 loops=1)

  • Buffers: shared hit=3526, temp read=234641 written=1410
3. 66.126 222.232 ↑ 1.4 240,427 1

Sort (cost=50,048.80..50,875.26 rows=330,583 width=12) (actual time=195.541..222.232 rows=240,427 loops=1)

  • Sort Key: t.fk_promo_id, t.votes DESC
  • Sort Method: external merge Disk: 5208kB
  • Buffers: shared hit=3526, temp read=651 written=656
4. 46.267 156.106 ↑ 1.4 240,427 1

Hash Join (cost=7,314.52..16,432.43 rows=330,583 width=12) (actual time=64.962..156.106 rows=240,427 loops=1)

  • Hash Cond: (t.fk_to_user_id = votetable.fk_to_user_id)
  • Buffers: shared hit=3526
5. 15.407 44.899 ↑ 1.4 240,427 1

Append (cost=0.00..8,231.75 rows=330,583 width=12) (actual time=0.013..44.899 rows=240,427 loops=1)

  • Buffers: shared hit=2441
6. 0.017 0.017 ↑ 51.0 20 1

Seq Scan on user_votes_1 t (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.012..0.017 rows=20 loops=1)

  • Buffers: shared hit=1
7. 0.012 0.012 ↑ 51.0 20 1

Seq Scan on user_votes_2 t_1 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.011..0.012 rows=20 loops=1)

  • Buffers: shared hit=1
8. 0.006 0.006 ↑ 51.0 20 1

Seq Scan on user_votes_3 t_2 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

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

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

10. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on user_votes_5 t_4 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.001..0.001 rows=0 loops=1)

11. 0.008 0.008 ↑ 51.0 20 1

Seq Scan on user_votes_6 t_5 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.006..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
12. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_7 t_6 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

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

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

14. 0.004 0.004 ↑ 102.0 10 1

Seq Scan on user_votes_9 t_8 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.004 rows=10 loops=1)

  • Buffers: shared hit=1
15. 0.006 0.006 ↑ 51.0 20 1

Seq Scan on user_votes_12 t_9 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
16. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_13 t_10 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
17. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_14 t_11 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
18. 0.007 0.007 ↑ 51.0 20 1

Seq Scan on user_votes_15 t_12 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.005..0.007 rows=20 loops=1)

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

Seq Scan on user_votes_16 t_13 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
20. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_17 t_14 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
21. 0.006 0.006 ↑ 51.0 20 1

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

  • Buffers: shared hit=1
22. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_19 t_16 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
23. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_20 t_17 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

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

Seq Scan on user_votes_21 t_18 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
25. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_22 t_19 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
26. 0.007 0.007 ↑ 51.0 20 1

Seq Scan on user_votes_23 t_20 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.006..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
27. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_24 t_21 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

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

Seq Scan on user_votes_25 t_22 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
29. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_26 t_23 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
30. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_27 t_24 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
31. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_28 t_25 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
32. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_29 t_26 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
33. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_30 t_27 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
34. 0.007 0.007 ↑ 51.0 20 1

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

  • Buffers: shared hit=1
35. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_32 t_29 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
36. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_33 t_30 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
37. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_34 t_31 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
38. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_35 t_32 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
39. 0.006 0.006 ↑ 51.0 20 1

Seq Scan on user_votes_36 t_33 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
40. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_37 t_34 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
41. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_38 t_35 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
42. 0.008 0.008 ↑ 51.0 20 1

Seq Scan on user_votes_39 t_36 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.006..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
43. 0.006 0.006 ↑ 51.0 20 1

Seq Scan on user_votes_40 t_37 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
44. 0.006 0.006 ↑ 51.0 20 1

Seq Scan on user_votes_41 t_38 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
45. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_42 t_39 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
46. 0.006 0.006 ↑ 51.0 20 1

Seq Scan on user_votes_43 t_40 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
47. 0.012 0.012 ↑ 51.0 20 1

Seq Scan on user_votes_44 t_41 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.010..0.012 rows=20 loops=1)

  • Buffers: shared hit=1
48. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_45 t_42 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
49. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_46 t_43 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
50. 0.007 0.007 ↑ 51.0 20 1

Seq Scan on user_votes_47 t_44 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.005..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
51. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_48 t_45 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
52. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_49 t_46 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

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

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

  • Buffers: shared hit=1
54. 0.006 0.006 ↑ 51.0 20 1

Seq Scan on user_votes_56 t_48 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

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

Seq Scan on user_votes_57 t_49 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
56. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_58 t_50 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
57. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_59 t_51 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
58. 0.007 0.007 ↑ 51.0 20 1

Seq Scan on user_votes_60 t_52 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.005..0.007 rows=20 loops=1)

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

Seq Scan on user_votes_61 t_53 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

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

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

  • Buffers: shared hit=1
61. 0.006 0.006 ↑ 51.0 20 1

Seq Scan on user_votes_63 t_55 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
62. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_64 t_56 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
63. 0.006 0.006 ↑ 51.0 20 1

Seq Scan on user_votes_65 t_57 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
64. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_66 t_58 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
65. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_67 t_59 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
66. 0.007 0.007 ↑ 53.7 19 1

Seq Scan on user_votes_68 t_60 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.005..0.007 rows=19 loops=1)

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

Seq Scan on user_votes_69 t_61 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
68. 0.006 0.006 ↑ 51.0 20 1

Seq Scan on user_votes_70 t_62 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
69. 0.005 0.005 ↑ 53.7 19 1

Seq Scan on user_votes_71 t_63 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=19 loops=1)

  • Buffers: shared hit=1
70. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_72 t_64 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
71. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_73 t_65 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
72. 0.005 0.005 ↑ 53.7 19 1

Seq Scan on user_votes_74 t_66 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=19 loops=1)

  • Buffers: shared hit=1
73. 0.005 0.005 ↑ 53.7 19 1

Seq Scan on user_votes_75 t_67 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=19 loops=1)

  • Buffers: shared hit=1
74. 0.007 0.007 ↑ 51.0 20 1

Seq Scan on user_votes_76 t_68 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.006..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
75. 0.006 0.006 ↑ 51.0 20 1

Seq Scan on user_votes_77 t_69 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

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

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

  • Buffers: shared hit=1
77. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_79 t_71 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
78. 0.006 0.006 ↑ 53.7 19 1

Seq Scan on user_votes_80 t_72 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=19 loops=1)

  • Buffers: shared hit=1
79. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_81 t_73 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
80. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_82 t_74 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
81. 0.007 0.007 ↑ 51.0 20 1

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

  • Buffers: shared hit=1
82. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_84 t_76 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
83. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_85 t_77 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
84. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_86 t_78 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
85. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_87 t_79 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
86. 0.005 0.005 ↑ 51.0 20 1

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

  • Buffers: shared hit=1
87. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_89 t_81 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

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

Seq Scan on user_votes_90 t_82 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

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

Seq Scan on user_votes_91 t_83 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.006..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
90. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_92 t_84 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
91. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_93 t_85 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
92. 0.006 0.006 ↑ 51.0 20 1

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

  • Buffers: shared hit=1
93. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_95 t_87 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.005 rows=20 loops=1)

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

Seq Scan on user_votes_96 t_88 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

  • Buffers: shared hit=1
95. 0.005 0.005 ↑ 51.0 20 1

Seq Scan on user_votes_97 t_89 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
96. 0.006 0.006 ↑ 51.0 20 1

Seq Scan on user_votes_98 t_90 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.004..0.006 rows=20 loops=1)

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

Seq Scan on user_votes_99 t_91 (cost=0.00..20.20 rows=1,020 width=12) (actual time=0.003..0.003 rows=0 loops=1)

98. 15.366 15.366 ↓ 1.0 133,874 1

Seq Scan on user_votes_100 t_92 (cost=0.00..2,647.01 rows=133,001 width=12) (actual time=0.005..15.366 rows=133,874 loops=1)

  • Buffers: shared hit=1317
99. 13.603 13.603 ↓ 1.0 104,808 1

Seq Scan on user_votes_101 t_93 (cost=0.00..2,073.42 rows=103,742 width=12) (actual time=0.021..13.603 rows=104,808 loops=1)

  • Buffers: shared hit=1036
100. 3.021 64.940 ↓ 117.5 23,493 1

Hash (cost=7,312.02..7,312.02 rows=200 width=4) (actual time=64.940..64.940 rows=23,493 loops=1)

  • Buckets: 32768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1082kB
  • Buffers: shared hit=1085
101. 1.954 61.919 ↓ 117.5 23,493 1

Subquery Scan on votetable (cost=7,260.35..7,312.02 rows=200 width=4) (actual time=45.935..61.919 rows=23,493 loops=1)

  • Buffers: shared hit=1085
102. 5.459 59.965 ↓ 117.5 23,493 1

Finalize GroupAggregate (cost=7,260.35..7,310.02 rows=200 width=12) (actual time=45.935..59.965 rows=23,493 loops=1)

  • Group Key: v_92.fk_to_user_id
  • Buffers: shared hit=1085
103. 17.427 54.506 ↓ 106.7 42,669 1

Gather Merge (cost=7,260.35..7,307.02 rows=400 width=4) (actual time=45.912..54.506 rows=42,669 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=2455
104. 4.688 37.079 ↓ 71.1 14,223 3 / 3

Sort (cost=6,260.32..6,260.82 rows=200 width=4) (actual time=35.458..37.079 rows=14,223 loops=3)

  • Sort Key: v_92.fk_to_user_id
  • Sort Method: quicksort Memory: 1550kB
  • Worker 0: Sort Method: quicksort Memory: 983kB
  • Worker 1: Sort Method: quicksort Memory: 1004kB
  • Buffers: shared hit=2455
105. 16.611 32.391 ↓ 71.1 14,223 3 / 3

Partial HashAggregate (cost=6,250.68..6,252.68 rows=200 width=4) (actual time=30.295..32.391 rows=14,223 loops=3)

  • Group Key: v_92.fk_to_user_id
  • Buffers: shared hit=2441
106. 5.248 15.780 ↑ 1.7 80,142 3 / 3

Parallel Append (cost=0.00..5,906.32 rows=137,743 width=4) (actual time=0.017..15.780 rows=80,142 loops=3)

  • Buffers: shared hit=2441
107. 5.603 5.603 ↑ 1.8 44,625 3 / 3

Parallel Seq Scan on user_votes_100 v_92 (cost=0.00..2,099.36 rows=78,236 width=4) (actual time=0.011..5.603 rows=44,625 loops=3)

  • Buffers: shared hit=1317
108. 4.808 4.808 ↑ 1.2 52,404 2 / 3

Parallel Seq Scan on user_votes_101 v_93 (cost=0.00..1,646.25 rows=61,025 width=4) (actual time=0.014..7.212 rows=52,404 loops=2)

  • Buffers: shared hit=1036
109. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_1 v (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
110. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
111. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
112. 0.000 0.000 ↓ 0.0 0 1 / 3

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

113. 0.000 0.000 ↓ 0.0 0 1 / 3

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

114. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_6 v_5 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
115. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_7 v_6 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
116. 0.000 0.000 ↓ 0.0 0 1 / 3

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

117. 0.001 0.001 ↑ 60.0 10 1 / 3

Parallel Seq Scan on user_votes_9 v_8 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=10 loops=1)

  • Buffers: shared hit=1
118. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
119. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
120. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
121. 0.002 0.002 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_15 v_12 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
122. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
123. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_17 v_14 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
124. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_18 v_15 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
125. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_19 v_16 (cost=0.00..16.00 rows=600 width=4) (actual time=0.003..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
126. 0.008 0.008 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_20 v_17 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.023 rows=20 loops=1)

  • Buffers: shared hit=1
127. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_21 v_18 (cost=0.00..16.00 rows=600 width=4) (actual time=0.003..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
128. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
129. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_23 v_20 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
130. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
131. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_25 v_22 (cost=0.00..16.00 rows=600 width=4) (actual time=0.003..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
132. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
133. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_27 v_24 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
134. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
135. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
136. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_30 v_27 (cost=0.00..16.00 rows=600 width=4) (actual time=0.003..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
137. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
138. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_32 v_29 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
139. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
140. 0.002 0.002 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_34 v_31 (cost=0.00..16.00 rows=600 width=4) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
141. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_35 v_32 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
142. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
143. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
144. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
145. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
146. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_40 v_37 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
147. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
148. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
149. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
150. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_44 v_41 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
151. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
152. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_46 v_43 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
153. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_47 v_44 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
154. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
155. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
156. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_55 v_47 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
157. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_56 v_48 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
158. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
159. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
160. 0.002 0.002 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_59 v_51 (cost=0.00..16.00 rows=600 width=4) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
161. 0.002 0.002 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_60 v_52 (cost=0.00..16.00 rows=600 width=4) (actual time=0.004..0.007 rows=20 loops=1)

  • Buffers: shared hit=1
162. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
163. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_62 v_54 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
164. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
165. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_64 v_56 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
166. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_65 v_57 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
167. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_66 v_58 (cost=0.00..16.00 rows=600 width=4) (actual time=0.003..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
168. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
169. 0.001 0.001 ↑ 31.6 19 1 / 3

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

  • Buffers: shared hit=1
170. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_69 v_61 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
171. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
172. 0.001 0.001 ↑ 31.6 19 1 / 3

Parallel Seq Scan on user_votes_71 v_63 (cost=0.00..16.00 rows=600 width=4) (actual time=0.003..0.004 rows=19 loops=1)

  • Buffers: shared hit=1
173. 0.002 0.002 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_72 v_64 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
174. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_73 v_65 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
175. 0.001 0.001 ↑ 31.6 19 1 / 3

Parallel Seq Scan on user_votes_74 v_66 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=19 loops=1)

  • Buffers: shared hit=1
176. 0.001 0.001 ↑ 31.6 19 1 / 3

Parallel Seq Scan on user_votes_75 v_67 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=19 loops=1)

  • Buffers: shared hit=1
177. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_76 v_68 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
178. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_77 v_69 (cost=0.00..16.00 rows=600 width=4) (actual time=0.003..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
179. 0.002 0.002 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_78 v_70 (cost=0.00..16.00 rows=600 width=4) (actual time=0.004..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
180. 0.002 0.002 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_79 v_71 (cost=0.00..16.00 rows=600 width=4) (actual time=0.003..0.005 rows=20 loops=1)

  • Buffers: shared hit=1
181. 0.001 0.001 ↑ 31.6 19 1 / 3

Parallel Seq Scan on user_votes_80 v_72 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=19 loops=1)

  • Buffers: shared hit=1
182. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_81 v_73 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
183. 0.004 0.004 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_82 v_74 (cost=0.00..16.00 rows=600 width=4) (actual time=0.009..0.011 rows=20 loops=1)

  • Buffers: shared hit=1
184. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_83 v_75 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
185. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
186. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_85 v_77 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
187. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
188. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_87 v_79 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
189. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_88 v_80 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
190. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_89 v_81 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
191. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_90 v_82 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
192. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
193. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
194. 0.001 0.001 ↑ 30.0 20 1 / 3

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

  • Buffers: shared hit=1
195. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_94 v_86 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.003 rows=20 loops=1)

  • Buffers: shared hit=1
196. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_95 v_87 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
197. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_96 v_88 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
198. 0.001 0.001 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_97 v_89 (cost=0.00..16.00 rows=600 width=4) (actual time=0.002..0.004 rows=20 loops=1)

  • Buffers: shared hit=1
199. 0.003 0.003 ↑ 30.0 20 1 / 3

Parallel Seq Scan on user_votes_98 v_90 (cost=0.00..16.00 rows=600 width=4) (actual time=0.006..0.008 rows=20 loops=1)

  • Buffers: shared hit=1
200. 0.001 0.001 ↓ 0.0 0 1 / 3

Parallel Seq Scan on user_votes_99 v_91 (cost=0.00..16.00 rows=600 width=4) (actual time=0.001..0.002 rows=0 loops=1)