explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3gkm

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

Unique (cost=1,492.65..1,492.72 rows=7 width=53) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=1,492.65..1,492.66 rows=7 width=53) (actual rows= loops=)

  • Sort Key: e."Id", e."Title", (LEAST(r.score, (CASE WHEN (r.score_reduction IS NULL) THEN e."MaxScore" ELSE GREATEST((e."MaxScore" - r.score_reduction), 0) END)::bigint))
3. 0.000 0.000 ↓ 0.0

Group (cost=1,492.41..1,492.55 rows=7 width=53) (actual rows= loops=)

  • Group Key: e."Id", r.score, r.score_reduction
4. 0.000 0.000 ↓ 0.0

Sort (cost=1,492.41..1,492.43 rows=7 width=49) (actual rows= loops=)

  • Sort Key: e."Id", r.score, r.score_reduction
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=377.70..1,492.31 rows=7 width=49) (actual rows= loops=)

  • Hash Cond: (r.exercise_id = e."Id")
6. 0.000 0.000 ↓ 0.0

Append (cost=0.43..1,112.71 rows=887 width=20) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_1_chunk_new_responses_user_id_start_time_idx on _hyper_1_1_chunk r (cost=0.43..39.52 rows=34 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
8. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_2_chunk_new_responses_user_id_start_time_idx on _hyper_1_2_chunk r_1 (cost=0.42..8.22 rows=6 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
9. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_3_chunk_new_responses_user_id_start_time_idx on _hyper_1_3_chunk r_2 (cost=0.14..2.36 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
10. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_4_chunk_new_responses_user_id_start_time_idx on _hyper_1_4_chunk r_3 (cost=0.14..2.36 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
11. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_5_chunk_new_responses_user_id_start_time_idx on _hyper_1_5_chunk r_4 (cost=0.14..2.36 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
12. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_6_chunk_new_responses_user_id_start_time_idx on _hyper_1_6_chunk r_5 (cost=0.29..3.52 rows=2 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
13. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_7_chunk_new_responses_user_id_start_time_idx on _hyper_1_7_chunk r_6 (cost=0.29..5.83 rows=4 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
14. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_8_chunk_new_responses_user_id_start_time_idx on _hyper_1_8_chunk r_7 (cost=0.29..4.73 rows=3 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
15. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_9_chunk_new_responses_user_id_start_time_idx on _hyper_1_9_chunk r_8 (cost=0.29..5.85 rows=4 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
16. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_10_chunk_new_responses_user_id_start_time_idx on _hyper_1_10_chunk r_9 (cost=0.28..3.61 rows=2 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
17. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_11_chunk_new_responses_user_id_start_time_idx on _hyper_1_11_chunk r_10 (cost=0.29..5.85 rows=4 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
18. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_12_chunk_new_responses_user_id_start_time_idx on _hyper_1_12_chunk r_11 (cost=0.29..5.86 rows=4 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
19. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_13_chunk_new_responses_user_id_start_time_idx on _hyper_1_13_chunk r_12 (cost=0.42..8.22 rows=6 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
20. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_14_chunk_new_responses_user_id_start_time_idx on _hyper_1_14_chunk r_13 (cost=0.29..6.98 rows=5 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
21. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_15_chunk_new_responses_user_id_start_time_idx on _hyper_1_15_chunk r_14 (cost=0.29..6.98 rows=5 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
22. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_16_chunk_new_responses_user_id_start_time_idx on _hyper_1_16_chunk r_15 (cost=0.28..2.50 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
23. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_17_chunk_new_responses_user_id_start_time_idx on _hyper_1_17_chunk r_16 (cost=0.28..2.50 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
24. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_18_chunk_new_responses_user_id_start_time_idx on _hyper_1_18_chunk r_17 (cost=0.29..5.65 rows=4 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
25. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_19_chunk_new_responses_user_id_start_time_idx on _hyper_1_19_chunk r_18 (cost=0.42..11.51 rows=9 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
26. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_20_chunk_new_responses_user_id_start_time_idx on _hyper_1_20_chunk r_19 (cost=0.42..10.46 rows=8 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
27. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_21_chunk_new_responses_user_id_start_time_idx on _hyper_1_21_chunk r_20 (cost=0.42..11.58 rows=9 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
28. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_22_chunk_new_responses_user_id_start_time_idx on _hyper_1_22_chunk r_21 (cost=0.29..6.96 rows=5 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
29. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_23_chunk_new_responses_user_id_start_time_idx on _hyper_1_23_chunk r_22 (cost=0.42..10.46 rows=8 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
30. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_24_chunk_new_responses_user_id_start_time_idx on _hyper_1_24_chunk r_23 (cost=0.42..10.46 rows=8 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
31. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_25_chunk_new_responses_user_id_start_time_idx on _hyper_1_25_chunk r_24 (cost=0.42..10.43 rows=8 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
32. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_26_chunk_new_responses_user_id_start_time_idx on _hyper_1_26_chunk r_25 (cost=0.42..10.45 rows=8 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
33. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_27_chunk_new_responses_user_id_start_time_idx on _hyper_1_27_chunk r_26 (cost=0.42..10.46 rows=8 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
34. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_28_chunk_new_responses_user_id_start_time_idx on _hyper_1_28_chunk r_27 (cost=0.29..3.59 rows=2 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
35. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_29_chunk_new_responses_user_id_start_time_idx on _hyper_1_29_chunk r_28 (cost=0.28..2.50 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
36. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_30_chunk_new_responses_user_id_start_time_idx on _hyper_1_30_chunk r_29 (cost=0.42..6.96 rows=5 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
37. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_31_chunk_new_responses_user_id_start_time_idx on _hyper_1_31_chunk r_30 (cost=0.42..17.02 rows=14 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
38. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_32_chunk_new_responses_user_id_start_time_idx on _hyper_1_32_chunk r_31 (cost=0.42..13.81 rows=11 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
39. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_33_chunk_new_responses_user_id_start_time_idx on _hyper_1_33_chunk r_32 (cost=0.42..17.17 rows=14 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
40. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_34_chunk_new_responses_user_id_start_time_idx on _hyper_1_34_chunk r_33 (cost=0.42..9.34 rows=7 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
41. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_35_chunk_new_responses_user_id_start_time_idx on _hyper_1_35_chunk r_34 (cost=0.42..12.69 rows=10 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
42. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_36_chunk_new_responses_user_id_start_time_idx on _hyper_1_36_chunk r_35 (cost=0.42..13.81 rows=11 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
43. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_37_chunk_new_responses_user_id_start_time_idx on _hyper_1_37_chunk r_36 (cost=0.42..12.69 rows=10 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
44. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_38_chunk_new_responses_user_id_start_time_idx on _hyper_1_38_chunk r_37 (cost=0.42..13.81 rows=11 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
45. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_39_chunk_new_responses_user_id_start_time_idx on _hyper_1_39_chunk r_38 (cost=0.42..12.69 rows=10 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
46. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_40_chunk_new_responses_user_id_start_time_idx on _hyper_1_40_chunk r_39 (cost=0.29..5.78 rows=4 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
47. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_41_chunk_new_responses_user_id_start_time_idx on _hyper_1_41_chunk r_40 (cost=0.28..2.50 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
48. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_42_chunk_new_responses_user_id_start_time_idx on _hyper_1_42_chunk r_41 (cost=0.41..7.08 rows=5 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
49. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_43_chunk_new_responses_user_id_start_time_idx on _hyper_1_43_chunk r_42 (cost=0.42..19.22 rows=16 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
50. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_44_chunk_new_responses_user_id_start_time_idx on _hyper_1_44_chunk r_43 (cost=0.42..21.61 rows=18 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
51. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_45_chunk_new_responses_user_id_start_time_idx on _hyper_1_45_chunk r_44 (cost=0.42..18.29 rows=15 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
52. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_46_chunk_new_responses_user_id_start_time_idx on _hyper_1_46_chunk r_45 (cost=0.42..14.92 rows=12 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
53. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_47_chunk_new_responses_user_id_start_time_idx on _hyper_1_47_chunk r_46 (cost=0.42..12.70 rows=10 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
54. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_48_chunk_new_responses_user_id_start_time_idx on _hyper_1_48_chunk r_47 (cost=0.42..19.38 rows=16 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
55. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_49_chunk_new_responses_user_id_start_time_idx on _hyper_1_49_chunk r_48 (cost=0.42..18.29 rows=15 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
56. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_50_chunk_new_responses_user_id_start_time_idx on _hyper_1_50_chunk r_49 (cost=0.42..14.93 rows=12 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
57. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_51_chunk_new_responses_user_id_start_time_idx on _hyper_1_51_chunk r_50 (cost=0.42..17.17 rows=14 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
58. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_52_chunk_new_responses_user_id_start_time_idx on _hyper_1_52_chunk r_51 (cost=0.42..8.13 rows=6 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
59. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_53_chunk_new_responses_user_id_start_time_idx on _hyper_1_53_chunk r_52 (cost=0.29..3.62 rows=2 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
60. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_54_chunk_new_responses_user_id_start_time_idx on _hyper_1_54_chunk r_53 (cost=0.29..4.73 rows=3 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
61. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_55_chunk_new_responses_user_id_start_time_idx on _hyper_1_55_chunk r_54 (cost=0.42..21.41 rows=18 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
62. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_56_chunk_new_responses_user_id_start_time_idx on _hyper_1_56_chunk r_55 (cost=0.43..26.09 rows=22 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
63. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_57_chunk_new_responses_user_id_start_time_idx on _hyper_1_57_chunk r_56 (cost=0.42..20.52 rows=17 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
64. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_58_chunk_new_responses_user_id_start_time_idx on _hyper_1_58_chunk r_57 (cost=0.42..23.87 rows=20 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
65. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_59_chunk_new_responses_user_id_start_time_idx on _hyper_1_59_chunk r_58 (cost=0.42..12.69 rows=10 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
66. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_60_chunk_new_responses_user_id_start_time_idx on _hyper_1_60_chunk r_59 (cost=0.42..23.87 rows=20 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
67. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_61_chunk_new_responses_user_id_start_time_idx on _hyper_1_61_chunk r_60 (cost=0.42..19.40 rows=16 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
68. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_62_chunk_new_responses_user_id_start_time_idx on _hyper_1_62_chunk r_61 (cost=0.42..19.40 rows=16 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
69. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_63_chunk_new_responses_user_id_start_time_idx on _hyper_1_63_chunk r_62 (cost=0.42..19.40 rows=16 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
70. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_64_chunk_new_responses_user_id_start_time_idx on _hyper_1_64_chunk r_63 (cost=0.42..13.76 rows=11 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
71. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_65_chunk_new_responses_user_id_start_time_idx on _hyper_1_65_chunk r_64 (cost=0.29..6.91 rows=5 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
72. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_66_chunk_new_responses_user_id_start_time_idx on _hyper_1_66_chunk r_65 (cost=0.29..5.84 rows=4 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
73. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_67_chunk_new_responses_user_id_start_time_idx on _hyper_1_67_chunk r_66 (cost=0.43..22.51 rows=19 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
74. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_68_chunk_new_responses_user_id_start_time_idx on _hyper_1_68_chunk r_67 (cost=0.43..33.92 rows=29 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
75. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_69_chunk_new_responses_user_id_start_time_idx on _hyper_1_69_chunk r_68 (cost=0.43..24.99 rows=21 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
76. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_70_chunk_new_responses_user_id_start_time_idx on _hyper_1_70_chunk r_69 (cost=0.43..29.46 rows=25 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
77. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_71_chunk_new_responses_user_id_start_time_idx on _hyper_1_71_chunk r_70 (cost=0.42..10.42 rows=8 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
78. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_72_chunk_new_responses_user_id_start_time_idx on _hyper_1_72_chunk r_71 (cost=0.43..32.80 rows=28 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
79. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_73_chunk_new_responses_user_id_start_time_idx on _hyper_1_73_chunk r_72 (cost=0.43..24.99 rows=21 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
80. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_74_chunk_new_responses_user_id_start_time_idx on _hyper_1_74_chunk r_73 (cost=0.43..27.22 rows=23 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
81. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_75_chunk_new_responses_user_id_start_time_idx on _hyper_1_75_chunk r_74 (cost=0.42..21.64 rows=18 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
82. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_76_chunk_new_responses_user_id_start_time_idx on _hyper_1_76_chunk r_75 (cost=0.42..18.25 rows=15 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
83. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_77_chunk_new_responses_user_id_start_time_idx on _hyper_1_77_chunk r_76 (cost=0.29..8.04 rows=6 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
84. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_78_chunk_new_responses_user_id_start_time_idx on _hyper_1_78_chunk r_77 (cost=0.29..6.96 rows=5 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
85. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_79_chunk_new_responses_user_id_start_time_idx on _hyper_1_79_chunk r_78 (cost=0.43..24.85 rows=21 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
86. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_80_chunk_new_responses_user_id_start_time_idx on _hyper_1_80_chunk r_79 (cost=0.43..39.50 rows=34 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
87. 0.000 0.000 ↓ 0.0

Index Scan using _hyper_1_81_chunk_new_responses_user_id_start_time_idx on _hyper_1_81_chunk r_80 (cost=0.43..29.45 rows=25 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1991541)
88. 0.000 0.000 ↓ 0.0

Hash (cost=372.45..372.45 rows=386 width=37) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "Exercises" e (cost=6.71..372.45 rows=386 width=37) (actual rows= loops=)

  • Recheck Cond: ("ContexCategoryId" = '007ac591-344c-46b6-825f-6411cd3290ed'::bpchar)
90. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "public_Exercises_ContexCategoryId2_idx" (cost=0.00..6.61 rows=386 width=0) (actual rows= loops=)

  • Index Cond: ("ContexCategoryId" = '007ac591-344c-46b6-825f-6411cd3290ed'::bpchar)