explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QDALo

Settings
# exclusive inclusive rows x rows loops node
1. 13.793 2,999.691 ↑ 45,202,750,536,398.5 7,098 1

Nested Loop Left Join (cost=3.66..4,139,198,424,258,580.50 rows=320,849,123,307,356,800 width=435) (actual time=0.452..2,999.691 rows=7,098 loops=1)

2. 9.012 2,900.722 ↑ 3,187,729,296.2 7,098 1

Nested Loop Left Join (cost=3.51..78,442,813,012.18 rows=22,626,502,544,376 width=449) (actual time=0.423..2,900.722 rows=7,098 loops=1)

3. 8.549 2,820.730 ↑ 2,375,844.0 7,098 1

Nested Loop Left Join (cost=3.37..10,317,288.97 rows=16,863,740,740 width=420) (actual time=0.385..2,820.730 rows=7,098 loops=1)

4. 11.310 2,740.469 ↑ 292.3 5,976 1

Nested Loop Left Join (cost=3.22..138,152.77 rows=1,746,651 width=384) (actual time=0.350..2,740.469 rows=5,976 loops=1)

5. 4.926 2,663.423 ↓ 3.3 5,976 1

Nested Loop (cost=3.08..129,652.94 rows=1,838 width=355) (actual time=0.311..2,663.423 rows=5,976 loops=1)

  • Join Filter: ((p.brand_id)::text = (b.id)::text)
  • Rows Removed by Join Filter: 10,970
6. 4.461 2,658.497 ↓ 3.3 5,976 1

Nested Loop (cost=3.08..129,558.17 rows=1,838 width=145) (actual time=0.305..2,658.497 rows=5,976 loops=1)

7. 5.276 2,636.108 ↓ 3.3 5,976 1

Nested Loop (cost=2.80..128,168.37 rows=1,838 width=116) (actual time=0.296..2,636.108 rows=5,976 loops=1)

8. 5.504 2,624.856 ↓ 3.3 5,976 1

Nested Loop (cost=2.65..127,871.20 rows=1,838 width=121) (actual time=0.291..2,624.856 rows=5,976 loops=1)

  • Join Filter: (g.game_provider_id = gp.id)
  • Rows Removed by Join Filter: 11,413
9. 7.743 2,619.352 ↓ 3.3 5,976 1

Nested Loop (cost=2.65..127,562.51 rows=1,838 width=105) (actual time=0.277..2,619.352 rows=5,976 loops=1)

10. 2.614 2,599.657 ↓ 3.3 5,976 1

Merge Append (cost=2.38..126,949.96 rows=1,838 width=58) (actual time=0.266..2,599.657 rows=5,976 loops=1)

  • Sort Key: gr.id
11. 0.006 0.006 ↓ 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=266) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
12. 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=266) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
13. 0.006 0.006 ↓ 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=266) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
14. 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=266) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
15. 0.002 0.002 ↓ 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=266) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
16. 0.003 0.003 ↓ 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=266) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
17. 2,592.332 2,592.332 ↓ 3.3 5,535 1

Index Scan using pk_game_round_2020_07_id on game_round_2020_07 gr_6 (cost=0.43..126,540.38 rows=1,681 width=57) (actual time=0.211..2,592.332 rows=5,535 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
  • Rows Removed by Filter: 2,602,423
18. 4.682 4.682 ↓ 3.0 441 1

Index Scan using pk_game_round_2020_08_id on game_round_2020_08 gr_7 (cost=0.28..197.28 rows=147 width=55) (actual time=0.024..4.682 rows=441 loops=1)

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

Index Scan using pk_game_round_2020_09_id on game_round_2020_09 gr_8 (cost=0.14..17.00 rows=1 width=266) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
20. 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=266) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
21. 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=266) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
22. 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=266) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (((round_status)::text = 'UNRESOLVED'::text) AND ((now() - start_date) > '00:02:00'::interval))
23. 11.952 11.952 ↑ 1.0 1 5,976

Index Scan using pk_game on game g (cost=0.28..0.33 rows=1 width=63) (actual time=0.002..0.002 rows=1 loops=5,976)

  • Index Cond: (id = gr.game_id)
24. 0.000 0.000 ↑ 4.0 3 5,976

Materialize (cost=0.00..1.18 rows=12 width=48) (actual time=0.000..0.000 rows=3 loops=5,976)

25. 0.013 0.013 ↑ 1.3 9 1

Seq Scan on game_provider gp (cost=0.00..1.12 rows=12 width=48) (actual time=0.009..0.013 rows=9 loops=1)

26. 5.976 5.976 ↑ 1.0 1 5,976

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=5,976)

  • Index Cond: (id = g.game_subprovider_id)
27. 17.928 17.928 ↑ 1.0 1 5,976

Index Scan using pk_player on player p (cost=0.29..0.76 rows=1 width=37) (actual time=0.003..0.003 rows=1 loops=5,976)

  • Index Cond: (id = gr.player_id)
28. 0.000 0.000 ↑ 1.3 3 5,976

Materialize (cost=0.00..1.06 rows=4 width=256) (actual time=0.000..0.000 rows=3 loops=5,976)

29. 0.004 0.004 ↑ 1.3 3 1

Seq Scan on brand b (cost=0.00..1.04 rows=4 width=256) (actual time=0.004..0.004 rows=3 loops=1)

30. 29.880 65.736 ↓ 0.0 0 5,976

Append (cost=0.14..4.48 rows=14 width=45) (actual time=0.011..0.011 rows=0 loops=5,976)

31. 5.976 5.976 ↓ 0.0 0 5,976

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..0.17 rows=1 width=72) (actual time=0.001..0.001 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
32. 0.000 0.000 ↓ 0.0 0 5,976

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..0.17 rows=1 width=72) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
33. 0.000 0.000 ↓ 0.0 0 5,976

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..0.17 rows=1 width=72) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
34. 0.000 0.000 ↓ 0.0 0 5,976

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..0.17 rows=1 width=72) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
35. 0.000 0.000 ↓ 0.0 0 5,976

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..0.17 rows=1 width=72) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
36. 5.976 5.976 ↓ 0.0 0 5,976

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..0.17 rows=1 width=72) (actual time=0.001..0.001 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
37. 11.952 11.952 ↓ 0.0 0 5,976

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.42..2.35 rows=2 width=45) (actual time=0.002..0.002 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
38. 5.976 5.976 ↓ 0.0 0 5,976

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..0.40 rows=2 width=44) (actual time=0.001..0.001 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
39. 0.000 0.000 ↓ 0.0 0 5,976

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.14..0.17 rows=1 width=72) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
40. 5.976 5.976 ↓ 0.0 0 5,976

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..0.17 rows=1 width=72) (actual time=0.001..0.001 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
41. 0.000 0.000 ↓ 0.0 0 5,976

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..0.17 rows=1 width=72) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
42. 0.000 0.000 ↓ 0.0 0 5,976

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..0.17 rows=1 width=72) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
43. 41.832 71.712 ↓ 0.0 0 5,976

Append (cost=0.14..5.68 rows=15 width=52) (actual time=0.011..0.012 rows=0 loops=5,976)

44. 0.000 0.000 ↓ 0.0 0 5,976

Index Scan using isoftbet_game_round_detail_2020_01_game_round_id_idx on isoftbet_game_round_detail_2020_01 igr (cost=0.14..0.17 rows=1 width=210) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
45. 0.000 0.000 ↓ 0.0 0 5,976

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..0.17 rows=1 width=210) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
46. 0.000 0.000 ↓ 0.0 0 5,976

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..0.17 rows=1 width=210) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
47. 0.000 0.000 ↓ 0.0 0 5,976

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..0.17 rows=1 width=210) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
48. 0.000 0.000 ↓ 0.0 0 5,976

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..0.17 rows=1 width=210) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
49. 5.976 5.976 ↓ 0.0 0 5,976

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..0.17 rows=1 width=210) (actual time=0.001..0.001 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
50. 17.928 17.928 ↓ 0.0 0 5,976

Index Scan using isoftbet_game_round_detail_2020_07_game_round_id_idx on isoftbet_game_round_detail_2020_07 igr_6 (cost=0.43..3.56 rows=2 width=52) (actual time=0.003..0.003 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
51. 5.976 5.976 ↓ 0.0 0 5,976

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..0.38 rows=3 width=71) (actual time=0.001..0.001 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
52. 0.000 0.000 ↓ 0.0 0 5,976

Index Scan using isoftbet_game_round_detail_2020_09_game_round_id_idx on isoftbet_game_round_detail_2020_09 igr_8 (cost=0.14..0.17 rows=1 width=210) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
53. 0.000 0.000 ↓ 0.0 0 5,976

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..0.17 rows=1 width=210) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
54. 0.000 0.000 ↓ 0.0 0 5,976

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..0.17 rows=1 width=210) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
55. 0.000 0.000 ↓ 0.0 0 5,976

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..0.17 rows=1 width=210) (actual time=0.000..0.000 rows=0 loops=5,976)

  • Index Cond: (gr.id = game_round_id)
56. 42.588 70.980 ↓ 0.0 0 7,098

Append (cost=0.14..4.51 rows=14 width=45) (actual time=0.010..0.010 rows=0 loops=7,098)

57. 7.098 7.098 ↓ 0.0 0 7,098

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..0.17 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
58. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=60) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
59. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=60) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
60. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=60) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
61. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=60) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
62. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=60) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
63. 14.196 14.196 ↓ 0.0 0 7,098

Index Scan using play_and_go_game_round_detail_2020_07_game_round_id_idx on play_and_go_game_round_detail_2020_07 pgr_6 (cost=0.42..2.57 rows=2 width=45) (actual time=0.002..0.002 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
64. 7.098 7.098 ↓ 0.0 0 7,098

Index Scan using play_and_go_game_round_detail_game_round_id_provider_game__idx7 on play_and_go_game_round_detail_2020_08 pgr_7 (cost=0.14..0.18 rows=2 width=44) (actual time=0.001..0.001 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
65. 0.000 0.000 ↓ 0.0 0 7,098

Index Scan using play_and_go_game_round_detail_game_round_id_provider_game__idx8 on play_and_go_game_round_detail_2020_09 pgr_8 (cost=0.14..0.17 rows=1 width=60) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
66. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=60) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
67. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=60) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
68. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=60) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
69. 42.588 85.176 ↑ 14.0 1 7,098

Append (cost=0.14..5.54 rows=14 width=55) (actual time=0.009..0.012 rows=1 loops=7,098)

70. 0.000 0.000 ↓ 0.0 0 7,098

Index Scan using yggdrasil_game_round_detail_2020_01_game_round_id_idx on yggdrasil_game_round_detail_2020_01 ygr (cost=0.14..0.17 rows=1 width=182) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
71. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=182) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
72. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=182) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
73. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=182) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
74. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=182) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
75. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=182) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
76. 28.392 28.392 ↑ 2.0 1 7,098

Index Scan using yggdrasil_game_round_detail_2020_07_game_round_id_idx on yggdrasil_game_round_detail_2020_07 ygr_6 (cost=0.43..3.60 rows=2 width=55) (actual time=0.004..0.004 rows=1 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
77. 7.098 7.098 ↓ 0.0 0 7,098

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..0.18 rows=2 width=55) (actual time=0.001..0.001 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
78. 7.098 7.098 ↓ 0.0 0 7,098

Index Scan using yggdrasil_game_round_detail_2020_09_game_round_id_idx on yggdrasil_game_round_detail_2020_09 ygr_8 (cost=0.14..0.17 rows=1 width=182) (actual time=0.001..0.001 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
79. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=182) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
80. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=182) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
81. 0.000 0.000 ↓ 0.0 0 7,098

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..0.17 rows=1 width=182) (actual time=0.000..0.000 rows=0 loops=7,098)

  • Index Cond: (gr.id = game_round_id)
Planning time : 4.697 ms
Execution time : 3,001.059 ms