explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Oty

Settings
# exclusive inclusive rows x rows loops node
1. 0.953 34.488 ↑ 620,971.9 1,022 1

Merge Right Join (cost=11.92..17,805,265.24 rows=634,633,326 width=447) (actual time=0.663..34.488 rows=1,022 loops=1)

  • Merge Cond: (igr.game_round_id = gr.id)
2. 0.459 3.899 ↑ 1.3 4,374 1

Merge Append (cost=2.20..638.68 rows=5,790 width=96) (actual time=0.056..3.899 rows=4,374 loops=1)

  • Sort Key: igr.game_round_id
3. 0.006 0.006 ↓ 0.0 0 1

Index Scan using isoftbet_game_round_detail_2020_01_game_round_id_idx on isoftbet_game_round_detail_2020_01 igr (cost=0.14..14.04 rows=120 width=210) (actual time=0.006..0.006 rows=0 loops=1)

4. 0.006 0.006 ↓ 0.0 0 1

Index Scan using isoftbet_game_round_detail_2020_02_game_round_id_idx on isoftbet_game_round_detail_2020_02 igr_1 (cost=0.14..14.04 rows=120 width=210) (actual time=0.006..0.006 rows=0 loops=1)

5. 0.003 0.003 ↓ 0.0 0 1

Index Scan using isoftbet_game_round_detail_2020_03_game_round_id_idx on isoftbet_game_round_detail_2020_03 igr_2 (cost=0.14..14.04 rows=120 width=210) (actual time=0.003..0.003 rows=0 loops=1)

6. 0.002 0.002 ↓ 0.0 0 1

Index Scan using isoftbet_game_round_detail_2020_04_game_round_id_idx on isoftbet_game_round_detail_2020_04 igr_3 (cost=0.14..14.04 rows=120 width=210) (actual time=0.002..0.002 rows=0 loops=1)

7. 0.002 0.002 ↓ 0.0 0 1

Index Scan using isoftbet_game_round_detail_2020_05_game_round_id_idx on isoftbet_game_round_detail_2020_05 igr_4 (cost=0.14..14.04 rows=120 width=210) (actual time=0.002..0.002 rows=0 loops=1)

8. 0.002 0.002 ↓ 0.0 0 1

Index Scan using isoftbet_game_round_detail_2020_06_game_round_id_idx on isoftbet_game_round_detail_2020_06 igr_5 (cost=0.14..14.04 rows=120 width=210) (actual time=0.002..0.002 rows=0 loops=1)

9. 0.002 0.002 ↓ 0.0 0 1

Index Scan using isoftbet_game_round_detail_2020_07_game_round_id_idx on isoftbet_game_round_detail_2020_07 igr_6 (cost=0.14..14.04 rows=120 width=210) (actual time=0.002..0.002 rows=0 loops=1)

10. 0.688 0.688 ↑ 1.2 942 1

Index Scan using isoftbet_game_round_detail_2020_08_game_round_id_idx on isoftbet_game_round_detail_2020_08 igr_7 (cost=0.28..73.99 rows=1,101 width=62) (actual time=0.012..0.688 rows=942 loops=1)

11. 2.722 2.722 ↑ 1.0 3,433 1

Index Scan using isoftbet_game_round_detail_2020_09_game_round_id_idx on isoftbet_game_round_detail_2020_09 igr_8 (cost=0.28..291.31 rows=3,489 width=67) (actual time=0.011..2.722 rows=3,433 loops=1)

12. 0.003 0.003 ↓ 0.0 0 1

Index Scan using isoftbet_game_round_detail_2020_10_game_round_id_idx on isoftbet_game_round_detail_2020_10 igr_9 (cost=0.14..14.04 rows=120 width=210) (actual time=0.002..0.003 rows=0 loops=1)

13. 0.002 0.002 ↓ 0.0 0 1

Index Scan using isoftbet_game_round_detail_2020_11_game_round_id_idx on isoftbet_game_round_detail_2020_11 igr_10 (cost=0.14..14.04 rows=120 width=210) (actual time=0.002..0.002 rows=0 loops=1)

14. 0.002 0.002 ↓ 0.0 0 1

Index Scan using isoftbet_game_round_detail_2020_12_game_round_id_idx on isoftbet_game_round_detail_2020_12 igr_11 (cost=0.14..14.04 rows=120 width=210) (actual time=0.002..0.002 rows=0 loops=1)

15. 0.254 29.636 ↑ 21,470.8 1,021 1

Materialize (cost=9.73..407,001.11 rows=21,921,701 width=569) (actual time=0.564..29.636 rows=1,021 loops=1)

16. 0.268 29.382 ↑ 54,396.3 403 1

Merge Left Join (cost=9.73..352,196.85 rows=21,921,701 width=569) (actual time=0.562..29.382 rows=403 loops=1)

  • Merge Cond: (gr.id = pgr.game_round_id)
17. 0.176 27.334 ↑ 2,650.9 403 1

Merge Left Join (cost=7.51..20,337.01 rows=1,068,309 width=532) (actual time=0.476..27.334 rows=403 loops=1)

  • Merge Cond: (gr.id = ygr.game_round_id)
18. 1.420 26.463 ↑ 241.8 403 1

Merge Left Join (cost=5.43..3,821.85 rows=97,429 width=394) (actual time=0.428..26.463 rows=403 loops=1)

  • Merge Cond: (gr.id = ngr.game_round_id)
19. 0.467 13.179 ↑ 3.5 392 1

Nested Loop (cost=3.22..1,128.95 rows=1,356 width=364) (actual time=0.233..13.179 rows=392 loops=1)

20. 0.173 9.576 ↓ 5.4 392 1

Nested Loop (cost=3.07..889.16 rows=72 width=380) (actual time=0.192..9.576 rows=392 loops=1)

21. 0.173 9.011 ↓ 5.4 392 1

Nested Loop (cost=2.93..877.48 rows=72 width=385) (actual time=0.186..9.011 rows=392 loops=1)

22. 0.174 8.446 ↓ 5.4 392 1

Nested Loop (cost=2.78..864.87 rows=72 width=369) (actual time=0.181..8.446 rows=392 loops=1)

23. 0.167 7.488 ↓ 5.4 392 1

Nested Loop (cost=2.50..807.58 rows=72 width=322) (actual time=0.172..7.488 rows=392 loops=1)

  • Join Filter: ((p.brand_id)::text = (b.id)::text)
  • Rows Removed by Join Filter: 8
24. 0.212 7.321 ↓ 2.7 392 1

Nested Loop (cost=2.50..802.56 rows=145 width=111) (actual time=0.157..7.321 rows=392 loops=1)

25. 0.073 6.325 ↓ 2.7 392 1

Merge Append (cost=2.23..704.05 rows=145 width=86) (actual time=0.145..6.325 rows=392 loops=1)

  • Sort Key: gr.id
26. 0.003 0.003 ↓ 0.0 0 1

Index Scan using pk_game_round_2020_01_id on game_round_2020_01 gr (cost=0.14..17.00 rows=1 width=282) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
27. 0.002 0.002 ↓ 0.0 0 1

Index Scan using pk_game_round_2020_02_id on game_round_2020_02 gr_1 (cost=0.14..17.00 rows=1 width=282) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
28. 0.002 0.002 ↓ 0.0 0 1

Index Scan using pk_game_round_2020_03_id on game_round_2020_03 gr_2 (cost=0.14..17.00 rows=1 width=282) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
29. 0.002 0.002 ↓ 0.0 0 1

Index Scan using pk_game_round_2020_04_id on game_round_2020_04 gr_3 (cost=0.14..17.00 rows=1 width=282) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
30. 0.001 0.001 ↓ 0.0 0 1

Index Scan using pk_game_round_2020_05_id on game_round_2020_05 gr_4 (cost=0.14..17.00 rows=1 width=282) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
31. 0.002 0.002 ↓ 0.0 0 1

Index Scan using pk_game_round_2020_06_id on game_round_2020_06 gr_5 (cost=0.14..17.00 rows=1 width=282) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
32. 0.002 0.002 ↓ 0.0 0 1

Index Scan using pk_game_round_2020_07_id on game_round_2020_07 gr_6 (cost=0.14..17.00 rows=1 width=282) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
33. 2.469 2.469 ↓ 2.8 94 1

Index Scan using pk_game_round_2020_08_id on game_round_2020_08 gr_7 (cost=0.28..227.98 rows=33 width=71) (actual time=0.057..2.469 rows=94 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
  • Rows Removed by Filter: 3,613
34. 3.763 3.763 ↓ 2.9 298 1

Index Scan using pk_game_round_2020_09_id on game_round_2020_09 gr_8 (cost=0.28..302.58 rows=102 width=71) (actual time=0.068..3.763 rows=298 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
  • Rows Removed by Filter: 5,222
35. 0.002 0.002 ↓ 0.0 0 1

Index Scan using pk_game_round_2020_10_id on game_round_2020_10 gr_9 (cost=0.14..17.00 rows=1 width=282) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
36. 0.002 0.002 ↓ 0.0 0 1

Index Scan using pk_game_round_2020_11_id on game_round_2020_11 gr_10 (cost=0.14..17.00 rows=1 width=282) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
37. 0.002 0.002 ↓ 0.0 0 1

Index Scan using pk_game_round_2020_12_id on game_round_2020_12 gr_11 (cost=0.14..17.00 rows=1 width=282) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
38. 0.784 0.784 ↑ 1.0 1 392

Index Scan using pk_player on player p (cost=0.28..0.68 rows=1 width=33) (actual time=0.002..0.002 rows=1 loops=392)

  • Index Cond: (id = gr.player_id)
39. 0.000 0.000 ↑ 2.0 1 392

Materialize (cost=0.00..1.03 rows=2 width=256) (actual time=0.000..0.000 rows=1 loops=392)

40. 0.014 0.014 ↓ 1.5 3 1

Seq Scan on brand b (cost=0.00..1.02 rows=2 width=256) (actual time=0.012..0.014 rows=3 loops=1)

41. 0.784 0.784 ↑ 1.0 1 392

Index Scan using pk_game on game g (cost=0.28..0.80 rows=1 width=63) (actual time=0.002..0.002 rows=1 loops=392)

  • Index Cond: (id = gr.game_id)
42. 0.392 0.392 ↑ 1.0 1 392

Index Scan using game_provider_pkey on game_provider gp (cost=0.15..0.18 rows=1 width=48) (actual time=0.001..0.001 rows=1 loops=392)

  • Index Cond: (id = g.game_provider_id)
43. 0.392 0.392 ↑ 1.0 1 392

Index Scan using game_subprovider_pkey on game_subprovider gsp (cost=0.14..0.16 rows=1 width=27) (actual time=0.001..0.001 rows=1 loops=392)

  • Index Cond: (id = g.game_subprovider_id)
44. 1.568 3.136 ↑ 12.0 1 392

Append (cost=0.15..3.21 rows=12 width=16) (actual time=0.006..0.008 rows=1 loops=392)

45. 0.000 0.000 ↓ 0.0 0 392

Index Only Scan using pk_game_session_2020_01_id on game_session_2020_01 gs (cost=0.15..0.25 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=392)

  • Index Cond: (id = gr.game_session_id)
  • Heap Fetches: 0
46. 0.000 0.000 ↓ 0.0 0 392

Index Only Scan using pk_game_session_2020_02_id on game_session_2020_02 gs_1 (cost=0.15..0.25 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=392)

  • Index Cond: (id = gr.game_session_id)
  • Heap Fetches: 0
47. 0.000 0.000 ↓ 0.0 0 392

Index Only Scan using pk_game_session_2020_03_id on game_session_2020_03 gs_2 (cost=0.15..0.25 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=392)

  • Index Cond: (id = gr.game_session_id)
  • Heap Fetches: 0
48. 0.000 0.000 ↓ 0.0 0 392

Index Only Scan using pk_game_session_2020_04_id on game_session_2020_04 gs_3 (cost=0.15..0.25 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=392)

  • Index Cond: (id = gr.game_session_id)
  • Heap Fetches: 0
49. 0.000 0.000 ↓ 0.0 0 392

Index Only Scan using pk_game_session_2020_05_id on game_session_2020_05 gs_4 (cost=0.15..0.25 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=392)

  • Index Cond: (id = gr.game_session_id)
  • Heap Fetches: 0
50. 0.000 0.000 ↓ 0.0 0 392

Index Only Scan using pk_game_session_2020_06_id on game_session_2020_06 gs_5 (cost=0.15..0.25 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=392)

  • Index Cond: (id = gr.game_session_id)
  • Heap Fetches: 0
51. 0.000 0.000 ↓ 0.0 0 392

Index Only Scan using pk_game_session_2020_07_id on game_session_2020_07 gs_6 (cost=0.15..0.25 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=392)

  • Index Cond: (id = gr.game_session_id)
  • Heap Fetches: 0
52. 0.392 0.392 ↓ 0.0 0 392

Index Only Scan using pk_game_session_2020_08_id on game_session_2020_08 gs_7 (cost=0.27..0.33 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=392)

  • Index Cond: (id = gr.game_session_id)
  • Heap Fetches: 20
53. 0.784 0.784 ↑ 1.0 1 392

Index Only Scan using pk_game_session_2020_09_id on game_session_2020_09 gs_8 (cost=0.28..0.34 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=392)

  • Index Cond: (id = gr.game_session_id)
  • Heap Fetches: 233
54. 0.392 0.392 ↓ 0.0 0 392

Index Only Scan using pk_game_session_2020_10_id on game_session_2020_10 gs_9 (cost=0.15..0.25 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=392)

  • Index Cond: (id = gr.game_session_id)
  • Heap Fetches: 0
55. 0.000 0.000 ↓ 0.0 0 392

Index Only Scan using pk_game_session_2020_11_id on game_session_2020_11 gs_10 (cost=0.15..0.25 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=392)

  • Index Cond: (id = gr.game_session_id)
  • Heap Fetches: 0
56. 0.000 0.000 ↓ 0.0 0 392

Index Only Scan using pk_game_session_2020_12_id on game_session_2020_12 gs_11 (cost=0.15..0.25 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=392)

  • Index Cond: (id = gr.game_session_id)
  • Heap Fetches: 0
57. 2.232 11.864 ↑ 1.1 12,929 1

Materialize (cost=2.21..1,264.00 rows=14,370 width=46) (actual time=0.041..11.864 rows=12,929 loops=1)

58. 1.361 9.632 ↑ 1.1 12,929 1

Merge Append (cost=2.21..1,228.08 rows=14,370 width=46) (actual time=0.040..9.632 rows=12,929 loops=1)

  • Sort Key: ngr.game_round_id
59. 0.002 0.002 ↓ 0.0 0 1

Index Scan using net_ent_game_round_detail_2020_01_game_round_id_idx on net_ent_game_round_detail_2020_01 ngr (cost=0.14..13.59 rows=90 width=72) (actual time=0.002..0.002 rows=0 loops=1)

60. 0.002 0.002 ↓ 0.0 0 1

Index Scan using net_ent_game_round_detail_2020_02_game_round_id_idx on net_ent_game_round_detail_2020_02 ngr_1 (cost=0.14..13.59 rows=90 width=72) (actual time=0.002..0.002 rows=0 loops=1)

61. 0.007 0.007 ↓ 0.0 0 1

Index Scan using net_ent_game_round_detail_2020_03_game_round_id_idx on net_ent_game_round_detail_2020_03 ngr_2 (cost=0.14..13.59 rows=90 width=72) (actual time=0.007..0.007 rows=0 loops=1)

62. 0.002 0.002 ↓ 0.0 0 1

Index Scan using net_ent_game_round_detail_2020_04_game_round_id_idx on net_ent_game_round_detail_2020_04 ngr_3 (cost=0.14..13.59 rows=90 width=72) (actual time=0.002..0.002 rows=0 loops=1)

63. 0.002 0.002 ↓ 0.0 0 1

Index Scan using net_ent_game_round_detail_2020_05_game_round_id_idx on net_ent_game_round_detail_2020_05 ngr_4 (cost=0.14..13.59 rows=90 width=72) (actual time=0.002..0.002 rows=0 loops=1)

64. 0.002 0.002 ↓ 0.0 0 1

Index Scan using net_ent_game_round_detail_2020_06_game_round_id_idx on net_ent_game_round_detail_2020_06 ngr_5 (cost=0.14..13.59 rows=90 width=72) (actual time=0.002..0.002 rows=0 loops=1)

65. 0.002 0.002 ↓ 0.0 0 1

Index Scan using net_ent_game_round_detail_2020_07_game_round_id_idx on net_ent_game_round_detail_2020_07 ngr_6 (cost=0.14..13.59 rows=90 width=72) (actual time=0.002..0.002 rows=0 loops=1)

66. 3.502 3.502 ↑ 1.0 5,541 1

Index Scan using net_ent_game_round_detail_2020_08_game_round_id_idx on net_ent_game_round_detail_2020_08 ngr_7 (cost=0.28..327.77 rows=5,626 width=44) (actual time=0.008..3.502 rows=5,541 loops=1)

67. 4.744 4.744 ↑ 1.1 7,389 1

Index Scan using net_ent_game_round_detail_2020_09_game_round_id_idx on net_ent_game_round_detail_2020_09 ngr_8 (cost=0.28..434.74 rows=7,844 width=44) (actual time=0.007..4.744 rows=7,389 loops=1)

68. 0.002 0.002 ↓ 0.0 0 1

Index Scan using net_ent_game_round_detail_2020_10_game_round_id_idx on net_ent_game_round_detail_2020_10 ngr_9 (cost=0.14..13.59 rows=90 width=72) (actual time=0.002..0.002 rows=0 loops=1)

69. 0.002 0.002 ↓ 0.0 0 1

Index Scan using net_ent_game_round_detail_2020_11_game_round_id_idx on net_ent_game_round_detail_2020_11 ngr_10 (cost=0.14..13.59 rows=90 width=72) (actual time=0.002..0.002 rows=0 loops=1)

70. 0.002 0.002 ↓ 0.0 0 1

Index Scan using net_ent_game_round_detail_2020_12_game_round_id_idx on net_ent_game_round_detail_2020_12 ngr_11 (cost=0.14..13.59 rows=90 width=72) (actual time=0.001..0.002 rows=0 loops=1)

71. 0.113 0.695 ↑ 4.0 555 1

Materialize (cost=2.08..252.43 rows=2,193 width=154) (actual time=0.034..0.695 rows=555 loops=1)

72. 0.085 0.582 ↑ 4.0 555 1

Merge Append (cost=2.08..246.95 rows=2,193 width=154) (actual time=0.034..0.582 rows=555 loops=1)

  • Sort Key: ygr.game_round_id
73. 0.002 0.002 ↓ 0.0 0 1

Index Scan using yggdrasil_game_round_detail_2020_01_game_round_id_idx on yggdrasil_game_round_detail_2020_01 ygr (cost=0.14..14.79 rows=170 width=182) (actual time=0.002..0.002 rows=0 loops=1)

74. 0.002 0.002 ↓ 0.0 0 1

Index Scan using yggdrasil_game_round_detail_2020_02_game_round_id_idx on yggdrasil_game_round_detail_2020_02 ygr_1 (cost=0.14..14.79 rows=170 width=182) (actual time=0.002..0.002 rows=0 loops=1)

75. 0.002 0.002 ↓ 0.0 0 1

Index Scan using yggdrasil_game_round_detail_2020_03_game_round_id_idx on yggdrasil_game_round_detail_2020_03 ygr_2 (cost=0.14..14.79 rows=170 width=182) (actual time=0.002..0.002 rows=0 loops=1)

76. 0.002 0.002 ↓ 0.0 0 1

Index Scan using yggdrasil_game_round_detail_2020_04_game_round_id_idx on yggdrasil_game_round_detail_2020_04 ygr_3 (cost=0.14..14.79 rows=170 width=182) (actual time=0.002..0.002 rows=0 loops=1)

77. 0.002 0.002 ↓ 0.0 0 1

Index Scan using yggdrasil_game_round_detail_2020_05_game_round_id_idx on yggdrasil_game_round_detail_2020_05 ygr_4 (cost=0.14..14.79 rows=170 width=182) (actual time=0.002..0.002 rows=0 loops=1)

78. 0.002 0.002 ↓ 0.0 0 1

Index Scan using yggdrasil_game_round_detail_2020_06_game_round_id_idx on yggdrasil_game_round_detail_2020_06 ygr_5 (cost=0.14..14.79 rows=170 width=182) (actual time=0.002..0.002 rows=0 loops=1)

79. 0.001 0.001 ↓ 0.0 0 1

Index Scan using yggdrasil_game_round_detail_2020_07_game_round_id_idx on yggdrasil_game_round_detail_2020_07 ygr_6 (cost=0.14..14.79 rows=170 width=182) (actual time=0.001..0.001 rows=0 loops=1)

80. 0.183 0.183 ↓ 1.4 187 1

Index Scan using yggdrasil_game_round_detail_2020_08_game_round_id_idx on yggdrasil_game_round_detail_2020_08 ygr_7 (cost=0.14..12.08 rows=136 width=56) (actual time=0.007..0.183 rows=187 loops=1)

81. 0.295 0.295 ↓ 1.0 369 1

Index Scan using yggdrasil_game_round_detail_2020_09_game_round_id_idx on yggdrasil_game_round_detail_2020_09 ygr_8 (cost=0.27..36.42 rows=357 width=55) (actual time=0.008..0.295 rows=369 loops=1)

82. 0.002 0.002 ↓ 0.0 0 1

Index Scan using yggdrasil_game_round_detail_2020_10_game_round_id_idx on yggdrasil_game_round_detail_2020_10 ygr_9 (cost=0.14..14.79 rows=170 width=182) (actual time=0.002..0.002 rows=0 loops=1)

83. 0.002 0.002 ↓ 0.0 0 1

Index Scan using yggdrasil_game_round_detail_2020_11_game_round_id_idx on yggdrasil_game_round_detail_2020_11 ygr_10 (cost=0.14..14.79 rows=170 width=182) (actual time=0.001..0.002 rows=0 loops=1)

84. 0.002 0.002 ↓ 0.0 0 1

Index Scan using yggdrasil_game_round_detail_2020_12_game_round_id_idx on yggdrasil_game_round_detail_2020_12 ygr_11 (cost=0.14..14.79 rows=170 width=182) (actual time=0.002..0.002 rows=0 loops=1)

85. 0.310 1.780 ↑ 2.3 1,770 1

Materialize (cost=2.22..373.82 rows=4,104 width=53) (actual time=0.060..1.780 rows=1,770 loops=1)

86. 0.204 1.470 ↑ 2.3 1,770 1

Merge Append (cost=2.22..363.56 rows=4,104 width=53) (actual time=0.058..1.470 rows=1,770 loops=1)

  • Sort Key: pgr.game_round_id
87. 0.002 0.002 ↓ 0.0 0 1

Index Scan using play_and_go_game_round_detail_game_round_id_provider_game_s_idx on play_and_go_game_round_detail_2020_01 pgr (cost=0.14..15.85 rows=240 width=60) (actual time=0.002..0.002 rows=0 loops=1)

88. 0.002 0.002 ↓ 0.0 0 1

Index Scan using play_and_go_game_round_detail_game_round_id_provider_game__idx1 on play_and_go_game_round_detail_2020_02 pgr_1 (cost=0.14..15.85 rows=240 width=60) (actual time=0.002..0.002 rows=0 loops=1)

89. 0.002 0.002 ↓ 0.0 0 1

Index Scan using play_and_go_game_round_detail_game_round_id_provider_game__idx2 on play_and_go_game_round_detail_2020_03 pgr_2 (cost=0.14..15.85 rows=240 width=60) (actual time=0.002..0.002 rows=0 loops=1)

90. 0.002 0.002 ↓ 0.0 0 1

Index Scan using play_and_go_game_round_detail_game_round_id_provider_game__idx3 on play_and_go_game_round_detail_2020_04 pgr_3 (cost=0.14..15.85 rows=240 width=60) (actual time=0.002..0.002 rows=0 loops=1)

91. 0.011 0.011 ↓ 0.0 0 1

Index Scan using play_and_go_game_round_detail_game_round_id_provider_game__idx4 on play_and_go_game_round_detail_2020_05 pgr_4 (cost=0.14..15.85 rows=240 width=60) (actual time=0.011..0.011 rows=0 loops=1)

92. 0.002 0.002 ↓ 0.0 0 1

Index Scan using play_and_go_game_round_detail_game_round_id_provider_game__idx5 on play_and_go_game_round_detail_2020_06 pgr_5 (cost=0.14..15.85 rows=240 width=60) (actual time=0.002..0.002 rows=0 loops=1)

93. 0.001 0.001 ↓ 0.0 0 1

Index Scan using play_and_go_game_round_detail_game_round_id_provider_game__idx6 on play_and_go_game_round_detail_2020_07 pgr_6 (cost=0.14..15.85 rows=240 width=60) (actual time=0.001..0.001 rows=0 loops=1)

94. 0.734 0.734 ↓ 1.0 1,094 1

Index Scan using play_and_go_game_round_detail_2020_08_game_round_id_idx on play_and_go_game_round_detail_2020_08 pgr_7 (cost=0.28..61.28 rows=1,060 width=44) (actual time=0.009..0.734 rows=1,094 loops=1)

95. 0.504 0.504 ↓ 1.1 677 1

Index Scan using play_and_go_game_round_detail_2020_09_game_round_id_idx on play_and_go_game_round_detail_2020_09 pgr_8 (cost=0.28..49.53 rows=644 width=44) (actual time=0.019..0.504 rows=677 loops=1)

96. 0.002 0.002 ↓ 0.0 0 1

Index Scan using play_and_go_game_round_detail_game_round_id_provider_game__idx9 on play_and_go_game_round_detail_2020_10 pgr_9 (cost=0.14..15.85 rows=240 width=60) (actual time=0.002..0.002 rows=0 loops=1)

97. 0.002 0.002 ↓ 0.0 0 1

Index Scan using play_and_go_game_round_detai_game_round_id_provider_game__idx10 on play_and_go_game_round_detail_2020_11 pgr_10 (cost=0.14..15.85 rows=240 width=60) (actual time=0.002..0.002 rows=0 loops=1)

98. 0.002 0.002 ↓ 0.0 0 1

Index Scan using play_and_go_game_round_detai_game_round_id_provider_game__idx11 on play_and_go_game_round_detail_2020_12 pgr_11 (cost=0.14..15.85 rows=240 width=60) (actual time=0.002..0.002 rows=0 loops=1)

Planning time : 6.758 ms
Execution time : 35.081 ms