explain.depesz.com

PostgreSQL's explain analyze made readable

Result: flZe

Settings
# exclusive inclusive rows x rows loops node
1. 2.402 8,174.263 ↓ 13.0 415 1

Nested Loop (cost=156,318.71..180,061.47 rows=32 width=119) (actual time=8,026.865..8,174.263 rows=415 loops=1)

  • Join Filter: (t.fk_promo_id = pr.promo_id)
  • Rows Removed by Join Filter: 38595
2. 0.065 0.065 ↓ 1.0 94 1

Index Scan Backward using pk_promo on promos pr (cost=0.14..5.84 rows=93 width=12) (actual time=0.022..0.065 rows=94 loops=1)

3. 1.815 8,171.796 ↓ 6.1 415 94

Materialize (cost=156,318.57..179,960.94 rows=68 width=111) (actual time=72.767..86.934 rows=415 loops=94)

4. 60.850 8,169.981 ↓ 6.1 415 1

Hash Join (cost=156,318.57..179,960.60 rows=68 width=111) (actual time=6,840.123..8,169.981 rows=415 loops=1)

  • Hash Cond: (t.fk_to_user_id = u.user_id)
5. 1,301.834 7,581.739 ↑ 1.2 628,859 1

WindowAgg (cost=107,717.76..122,210.96 rows=724,660 width=20) (actual time=6,157.134..7,581.739 rows=628,859 loops=1)

6. 338.799 6,279.905 ↑ 1.2 628,859 1

Sort (cost=107,717.76..109,529.41 rows=724,660 width=12) (actual time=6,157.118..6,279.905 rows=628,859 loops=1)

  • Sort Key: t.fk_promo_id, t.votes DESC
  • Sort Method: external merge Disk: 13624kB
7. 317.363 5,941.106 ↑ 1.2 628,859 1

Nested Loop (cost=15,331.35..29,928.23 rows=724,660 width=12) (actual time=204.787..5,941.106 rows=628,859 loops=1)

8. 23.865 220.352 ↓ 203.1 40,627 1

Sort (cost=15,331.20..15,331.70 rows=200 width=12) (actual time=204.425..220.352 rows=40,627 loops=1)

  • Sort Key: (sum(v_93.votes)) DESC
  • Sort Method: quicksort Memory: 2994kB
9. 11.047 196.487 ↓ 203.1 40,627 1

Finalize GroupAggregate (cost=15,272.89..15,323.56 rows=200 width=12) (actual time=165.869..196.487 rows=40,627 loops=1)

  • Group Key: v_93.fk_to_user_id
10. 34.125 185.440 ↓ 151.5 60,606 1

Gather Merge (cost=15,272.89..15,319.56 rows=400 width=12) (actual time=165.856..185.440 rows=60,606 loops=1)

  • Workers Planned: 2
  • Workers Launched: 1
11. 12.006 151.315 ↓ 151.5 30,303 2 / 2

Sort (cost=14,272.86..14,273.36 rows=200 width=12) (actual time=146.489..151.315 rows=30,303 loops=2)

  • Sort Key: v_93.fk_to_user_id
  • Sort Method: quicksort Memory: 2251kB
  • Worker 0: Sort Method: quicksort Memory: 2127kB
12. 74.823 139.309 ↓ 151.5 30,303 2 / 2

Partial HashAggregate (cost=14,263.22..14,265.22 rows=200 width=12) (actual time=133.608..139.309 rows=30,303 loops=2)

  • Group Key: v_93.fk_to_user_id
13. 19.059 64.486 ↓ 1.0 314,430 2 / 2

Parallel Append (cost=0.00..12,753.52 rows=301,941 width=8) (actual time=0.013..64.486 rows=314,430 loops=2)

14. 28.283 28.283 ↓ 1.2 197,765 2 / 2

Parallel Seq Scan on user_votes_101 v_93 (cost=0.00..5,779.60 rows=167,060 width=8) (actual time=0.009..28.283 rows=197,765 loops=2)

15. 8.776 8.776 ↓ 1.7 133,874 1 / 2

Parallel Seq Scan on user_votes_100 v_92 (cost=0.00..2,099.36 rows=78,236 width=8) (actual time=0.007..17.552 rows=133,874 loops=1)

16. 8.071 8.071 ↓ 1.7 97,710 1 / 2

Parallel Seq Scan on user_votes_102 v_94 (cost=0.00..1,892.85 rows=56,985 width=8) (actual time=0.007..16.142 rows=97,710 loops=1)

17. 0.003 0.003 ↑ 30.0 20 1 / 2

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

18. 0.003 0.003 ↑ 30.0 20 1 / 2

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

19. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_3 v_2 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

20. 0.001 0.001 ↓ 0.0 0 1 / 2

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

21. 0.001 0.001 ↓ 0.0 0 1 / 2

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

22. 0.003 0.003 ↑ 30.0 20 1 / 2

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

23. 0.003 0.003 ↑ 30.0 20 1 / 2

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

24. 0.001 0.001 ↓ 0.0 0 1 / 2

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

25. 0.002 0.002 ↑ 60.0 10 1 / 2

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

26. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_12 v_9 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

27. 0.003 0.003 ↑ 30.0 20 1 / 2

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

28. 0.003 0.003 ↑ 30.0 20 1 / 2

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

29. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_15 v_12 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

30. 0.003 0.003 ↑ 30.0 20 1 / 2

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

31. 0.003 0.003 ↑ 30.0 20 1 / 2

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

32. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_18 v_15 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.005 rows=20 loops=1)

33. 0.003 0.003 ↑ 30.0 20 1 / 2

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

34. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_20 v_17 (cost=0.00..16.00 rows=600 width=8) (actual time=0.004..0.006 rows=20 loops=1)

35. 0.003 0.003 ↑ 30.0 20 1 / 2

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

36. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_22 v_19 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

37. 0.003 0.003 ↑ 30.0 20 1 / 2

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

38. 0.003 0.003 ↑ 30.0 20 1 / 2

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

39. 0.003 0.003 ↑ 30.0 20 1 / 2

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

40. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_26 v_23 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

41. 0.003 0.003 ↑ 30.0 20 1 / 2

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

42. 0.003 0.003 ↑ 30.0 20 1 / 2

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

43. 0.003 0.003 ↑ 30.0 20 1 / 2

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

44. 0.003 0.003 ↑ 30.0 20 1 / 2

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

45. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_31 v_28 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

46. 0.004 0.004 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_32 v_29 (cost=0.00..16.00 rows=600 width=8) (actual time=0.004..0.007 rows=20 loops=1)

47. 0.003 0.003 ↑ 30.0 20 1 / 2

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

48. 0.003 0.003 ↑ 30.0 20 1 / 2

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

49. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_35 v_32 (cost=0.00..16.00 rows=600 width=8) (actual time=0.004..0.006 rows=20 loops=1)

50. 0.003 0.003 ↑ 30.0 20 1 / 2

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

51. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_37 v_34 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

52. 0.003 0.003 ↑ 30.0 20 1 / 2

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

53. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_39 v_36 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

54. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_40 v_37 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

55. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_41 v_38 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.005 rows=20 loops=1)

56. 0.003 0.003 ↑ 30.0 20 1 / 2

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

57. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_43 v_40 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

58. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_44 v_41 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

59. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_45 v_42 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

60. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_46 v_43 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

61. 0.003 0.003 ↑ 30.0 20 1 / 2

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

62. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_48 v_45 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.005 rows=20 loops=1)

63. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_49 v_46 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.005 rows=20 loops=1)

64. 0.004 0.004 ↑ 30.0 20 1 / 2

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

65. 0.003 0.003 ↑ 30.0 20 1 / 2

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

66. 0.003 0.003 ↑ 30.0 20 1 / 2

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

67. 0.003 0.003 ↑ 30.0 20 1 / 2

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

68. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_59 v_51 (cost=0.00..16.00 rows=600 width=8) (actual time=0.004..0.006 rows=20 loops=1)

69. 0.004 0.004 ↑ 30.0 20 1 / 2

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

70. 0.004 0.004 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_61 v_53 (cost=0.00..16.00 rows=600 width=8) (actual time=0.005..0.007 rows=20 loops=1)

71. 0.004 0.004 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_62 v_54 (cost=0.00..16.00 rows=600 width=8) (actual time=0.005..0.008 rows=20 loops=1)

72. 0.004 0.004 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_63 v_55 (cost=0.00..16.00 rows=600 width=8) (actual time=0.005..0.007 rows=20 loops=1)

73. 0.003 0.003 ↑ 30.0 20 1 / 2

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

74. 0.004 0.004 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_65 v_57 (cost=0.00..16.00 rows=600 width=8) (actual time=0.005..0.007 rows=20 loops=1)

75. 0.033 0.033 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_66 v_58 (cost=0.00..16.00 rows=600 width=8) (actual time=0.063..0.066 rows=20 loops=1)

76. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_67 v_59 (cost=0.00..16.00 rows=600 width=8) (actual time=0.004..0.006 rows=20 loops=1)

77. 0.003 0.003 ↑ 31.6 19 1 / 2

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

78. 0.003 0.003 ↑ 30.0 20 1 / 2

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

79. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_70 v_62 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.005 rows=20 loops=1)

80. 0.003 0.003 ↑ 31.6 19 1 / 2

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

81. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_72 v_64 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

82. 0.003 0.003 ↑ 30.0 20 1 / 2

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

83. 0.003 0.003 ↑ 31.6 19 1 / 2

Parallel Seq Scan on user_votes_74 v_66 (cost=0.00..16.00 rows=600 width=8) (actual time=0.004..0.006 rows=19 loops=1)

84. 0.003 0.003 ↑ 31.6 19 1 / 2

Parallel Seq Scan on user_votes_75 v_67 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=19 loops=1)

85. 0.004 0.004 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_76 v_68 (cost=0.00..16.00 rows=600 width=8) (actual time=0.004..0.007 rows=20 loops=1)

86. 0.003 0.003 ↑ 30.0 20 1 / 2

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

87. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_78 v_70 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

88. 0.003 0.003 ↑ 30.0 20 1 / 2

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

89. 0.003 0.003 ↑ 31.6 19 1 / 2

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

90. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_81 v_73 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

91. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_82 v_74 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

92. 0.003 0.003 ↑ 30.0 20 1 / 2

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

93. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_84 v_76 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

94. 0.003 0.003 ↑ 30.0 20 1 / 2

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

95. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_86 v_78 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

96. 0.003 0.003 ↑ 30.0 20 1 / 2

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

97. 0.003 0.003 ↑ 30.0 20 1 / 2

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

98. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_89 v_81 (cost=0.00..16.00 rows=600 width=8) (actual time=0.004..0.006 rows=20 loops=1)

99. 0.003 0.003 ↑ 30.0 20 1 / 2

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

100. 0.003 0.003 ↑ 30.0 20 1 / 2

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

101. 0.003 0.003 ↑ 30.0 20 1 / 2

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

102. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_93 v_85 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

103. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_94 v_86 (cost=0.00..16.00 rows=600 width=8) (actual time=0.004..0.006 rows=20 loops=1)

104. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_95 v_87 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.005 rows=20 loops=1)

105. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_96 v_88 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

106. 0.003 0.003 ↑ 30.0 20 1 / 2

Parallel Seq Scan on user_votes_97 v_89 (cost=0.00..16.00 rows=600 width=8) (actual time=0.003..0.006 rows=20 loops=1)

107. 0.005 0.005 ↑ 30.0 20 1 / 2

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

108. 0.001 0.001 ↓ 0.0 0 1 / 2

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

109. 406.270 5,403.391 ↑ 34.3 15 40,627

Append (cost=0.15..67.83 rows=514 width=12) (actual time=0.107..0.133 rows=15 loops=40,627)

110. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_1_fk_to_user_id_idx on user_votes_1 t (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
111. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_2_fk_to_user_id_idx on user_votes_2 t_1 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
112. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_3_fk_to_user_id_idx on user_votes_3 t_2 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
113. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_4_fk_to_user_id_idx on user_votes_4 t_3 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
114. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_5_fk_to_user_id_idx on user_votes_5 t_4 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
115. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_6_fk_to_user_id_idx on user_votes_6 t_5 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
116. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_7_fk_to_user_id_idx on user_votes_7 t_6 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
117. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_8_fk_to_user_id_idx on user_votes_8 t_7 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
118. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_9_fk_to_user_id_idx on user_votes_9 t_8 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
119. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_12_fk_to_user_id_idx on user_votes_12 t_9 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
120. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_13_fk_to_user_id_idx on user_votes_13 t_10 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
121. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_14_fk_to_user_id_idx on user_votes_14 t_11 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
122. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_15_fk_to_user_id_idx on user_votes_15 t_12 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
123. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_16_fk_to_user_id_idx on user_votes_16 t_13 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
124. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_17_fk_to_user_id_idx on user_votes_17 t_14 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
125. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_18_fk_to_user_id_idx on user_votes_18 t_15 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
126. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_19_fk_to_user_id_idx on user_votes_19 t_16 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
127. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_20_fk_to_user_id_idx on user_votes_20 t_17 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
128. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_21_fk_to_user_id_idx on user_votes_21 t_18 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
129. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_22_fk_to_user_id_idx on user_votes_22 t_19 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
130. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_23_fk_to_user_id_idx on user_votes_23 t_20 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
131. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_24_fk_to_user_id_idx on user_votes_24 t_21 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
132. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_25_fk_to_user_id_idx on user_votes_25 t_22 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
133. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_26_fk_to_user_id_idx on user_votes_26 t_23 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
134. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_27_fk_to_user_id_idx on user_votes_27 t_24 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
135. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_28_fk_to_user_id_idx on user_votes_28 t_25 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
136. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_29_fk_to_user_id_idx on user_votes_29 t_26 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
137. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_30_fk_to_user_id_idx on user_votes_30 t_27 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
138. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_31_fk_to_user_id_idx on user_votes_31 t_28 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
139. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_32_fk_to_user_id_idx on user_votes_32 t_29 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
140. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_33_fk_to_user_id_idx on user_votes_33 t_30 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
141. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_34_fk_to_user_id_idx on user_votes_34 t_31 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
142. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_35_fk_to_user_id_idx on user_votes_35 t_32 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
143. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_36_fk_to_user_id_idx on user_votes_36 t_33 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
144. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_37_fk_to_user_id_idx on user_votes_37 t_34 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
145. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_38_fk_to_user_id_idx on user_votes_38 t_35 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
146. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_39_fk_to_user_id_idx on user_votes_39 t_36 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
147. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_40_fk_to_user_id_idx on user_votes_40 t_37 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
148. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_41_fk_to_user_id_idx on user_votes_41 t_38 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
149. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_42_fk_to_user_id_idx on user_votes_42 t_39 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
150. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_43_fk_to_user_id_idx on user_votes_43 t_40 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
151. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_44_fk_to_user_id_idx on user_votes_44 t_41 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
152. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_45_fk_to_user_id_idx on user_votes_45 t_42 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
153. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_46_fk_to_user_id_idx on user_votes_46 t_43 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
154. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_47_fk_to_user_id_idx on user_votes_47 t_44 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
155. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_48_fk_to_user_id_idx on user_votes_48 t_45 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
156. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_49_fk_to_user_id_idx on user_votes_49 t_46 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
157. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_55_fk_to_user_id_idx on user_votes_55 t_47 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
158. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_56_fk_to_user_id_idx on user_votes_56 t_48 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
159. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_57_fk_to_user_id_idx on user_votes_57 t_49 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
160. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_58_fk_to_user_id_idx on user_votes_58 t_50 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
161. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_59_fk_to_user_id_idx on user_votes_59 t_51 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
162. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_60_fk_to_user_id_idx on user_votes_60 t_52 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
163. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_61_fk_to_user_id_idx on user_votes_61 t_53 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
164. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_62_fk_to_user_id_idx on user_votes_62 t_54 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
165. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_63_fk_to_user_id_idx on user_votes_63 t_55 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
166. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_64_fk_to_user_id_idx on user_votes_64 t_56 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
167. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_65_fk_to_user_id_idx on user_votes_65 t_57 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
168. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_66_fk_to_user_id_idx on user_votes_66 t_58 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
169. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_67_fk_to_user_id_idx on user_votes_67 t_59 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
170. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_68_fk_to_user_id_idx on user_votes_68 t_60 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
171. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_69_fk_to_user_id_idx on user_votes_69 t_61 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
172. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_70_fk_to_user_id_idx on user_votes_70 t_62 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
173. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_71_fk_to_user_id_idx on user_votes_71 t_63 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
174. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_72_fk_to_user_id_idx on user_votes_72 t_64 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
175. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_73_fk_to_user_id_idx on user_votes_73 t_65 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
176. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_74_fk_to_user_id_idx on user_votes_74 t_66 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
177. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_75_fk_to_user_id_idx on user_votes_75 t_67 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
178. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_76_fk_to_user_id_idx on user_votes_76 t_68 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
179. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_77_fk_to_user_id_idx on user_votes_77 t_69 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
180. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_78_fk_to_user_id_idx on user_votes_78 t_70 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
181. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_79_fk_to_user_id_idx on user_votes_79 t_71 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
182. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_80_fk_to_user_id_idx on user_votes_80 t_72 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
183. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_81_fk_to_user_id_idx on user_votes_81 t_73 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
184. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_82_fk_to_user_id_idx on user_votes_82 t_74 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
185. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_83_fk_to_user_id_idx on user_votes_83 t_75 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
186. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_84_fk_to_user_id_idx on user_votes_84 t_76 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
187. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_85_fk_to_user_id_idx on user_votes_85 t_77 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
188. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_86_fk_to_user_id_idx on user_votes_86 t_78 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
189. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_87_fk_to_user_id_idx on user_votes_87 t_79 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
190. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_88_fk_to_user_id_idx on user_votes_88 t_80 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
191. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_89_fk_to_user_id_idx on user_votes_89 t_81 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
192. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_90_fk_to_user_id_idx on user_votes_90 t_82 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
193. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_91_fk_to_user_id_idx on user_votes_91 t_83 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
194. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_92_fk_to_user_id_idx on user_votes_92 t_84 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
195. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_93_fk_to_user_id_idx on user_votes_93 t_85 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
196. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_94_fk_to_user_id_idx on user_votes_94 t_86 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
197. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_95_fk_to_user_id_idx on user_votes_95 t_87 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
198. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_96_fk_to_user_id_idx on user_votes_96 t_88 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
199. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_97_fk_to_user_id_idx on user_votes_97 t_89 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
200. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_98_fk_to_user_id_idx on user_votes_98 t_90 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
201. 40.627 40.627 ↓ 0.0 0 40,627

Index Scan using user_votes_99_fk_to_user_id_idx on user_votes_99 t_91 (cost=0.15..0.30 rows=5 width=12) (actual time=0.001..0.001 rows=0 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
202. 325.016 325.016 ↑ 4.7 3 40,627

Index Scan using user_votes_100_fk_to_user_id_idx on user_votes_100 t_92 (cost=0.42..8.79 rows=14 width=12) (actual time=0.004..0.008 rows=3 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
203. 690.659 690.659 ↑ 3.0 10 40,627

Index Scan using user_votes_101_fk_to_user_id_idx on user_votes_101 t_93 (cost=0.42..20.98 rows=30 width=12) (actual time=0.006..0.017 rows=10 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
204. 243.762 243.762 ↑ 5.0 2 40,627

Index Scan using user_votes_102_fk_to_user_id_idx on user_votes_102 t_94 (cost=0.29..7.59 rows=10 width=12) (actual time=0.004..0.006 rows=2 loops=40,627)

  • Index Cond: (fk_to_user_id = v_93.fk_to_user_id)
205. 0.309 527.392 ↓ 1.7 256 1

Hash (cost=48,598.97..48,598.97 rows=147 width=95) (actual time=527.391..527.392 rows=256 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
206. 7.652 527.083 ↓ 1.7 256 1

Gather (cost=1,000.00..48,598.97 rows=147 width=95) (actual time=6.156..527.083 rows=256 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
207. 519.431 519.431 ↓ 1.4 85 3 / 3

Parallel Seq Scan on users u (cost=0.00..47,584.27 rows=61 width=95) (actual time=2.468..519.431 rows=85 loops=3)

  • Filter: (lower(user_name) ~~ '%cherry%'::text)
  • Rows Removed by Filter: 518969