explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FaRY

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 2,581.029 ↓ 0.0 0 1

Limit (cost=0.41..274.83 rows=1 width=1,730) (actual time=2,581.028..2,581.029 rows=0 loops=1)

2. 0.954 2,581.027 ↓ 0.0 0 1

Nested Loop (cost=0.41..274.83 rows=1 width=1,730) (actual time=2,581.027..2,581.027 rows=0 loops=1)

3. 0.211 1.989 ↓ 68.0 68 1

Nested Loop (cost=0.28..87.38 rows=1 width=8) (actual time=0.040..1.989 rows=68 loops=1)

4. 0.758 0.758 ↓ 68.0 68 1

Seq Scan on game game2_ (cost=0.00..79.08 rows=1 width=8) (actual time=0.021..0.758 rows=68 loops=1)

  • Filter: ((game_engine_id)::text = 'com.booming-games'::text)
  • Rows Removed by Filter: 1,299
5. 1.020 1.020 ↑ 1.0 1 68

Index Scan using game_profile_unq03 on game_profile gameprofil1_ (cost=0.28..8.29 rows=1 width=16) (actual time=0.012..0.015 rows=1 loops=68)

  • Index Cond: (game_id = game2_.game_id)
6. 3.196 2,578.084 ↓ 0.0 0 68

Append (cost=0.14..187.21 rows=24 width=1,731) (actual time=37.913..37.913 rows=0 loops=68)

7. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2015q1_unq01 on game_play_p2015q1 gameplay0_ (cost=0.14..3.83 rows=1 width=4,892) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (game_profile_id = gameprofil1_.game_profile_id)
  • Filter: ((expiry_date IS NOT NULL) AND (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone))
8. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2015q2_ix03 on game_play_p2015q2 gameplay0__1 (cost=0.12..8.14 rows=1 width=2,008) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
9. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2015q3_ix03 on game_play_p2015q3 gameplay0__2 (cost=0.12..8.14 rows=1 width=2,008) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
10. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2015q4_ix03 on game_play_p2015q4 gameplay0__3 (cost=0.12..8.14 rows=1 width=2,008) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
11. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2016q1_ix03 on game_play_p2016q1 gameplay0__4 (cost=0.12..8.14 rows=1 width=2,008) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
12. 0.136 0.136 ↓ 0.0 0 68

Index Scan using game_play_p2016q2_ix03 on game_play_p2016q2 gameplay0__5 (cost=0.12..8.14 rows=1 width=2,008) (actual time=0.002..0.002 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
13. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2016q3_ix03 on game_play_p2016q3 gameplay0__6 (cost=0.12..8.14 rows=1 width=530) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
14. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2016q4_ix03 on game_play_p2016q4 gameplay0__7 (cost=0.12..8.14 rows=1 width=532) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
15. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2017q1_ix03 on game_play_p2017q1 gameplay0__8 (cost=0.12..8.14 rows=1 width=533) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
16. 0.272 0.272 ↓ 0.0 0 68

Index Scan using game_play_p2017q2_ix03 on game_play_p2017q2 gameplay0__9 (cost=0.12..8.14 rows=1 width=537) (actual time=0.004..0.004 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
17. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2017q3_ix03 on game_play_p2017q3 gameplay0__10 (cost=0.12..8.14 rows=1 width=540) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
18. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2017q4_ix03 on game_play_p2017q4 gameplay0__11 (cost=0.12..8.14 rows=1 width=540) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
19. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2018q1_ix03 on game_play_p2018q1 gameplay0__12 (cost=0.12..8.14 rows=1 width=541) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
20. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2018q2_ix03 on game_play_p2018q2 gameplay0__13 (cost=0.12..8.14 rows=1 width=599) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
21. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2018q3_ix03 on game_play_p2018q3 gameplay0__14 (cost=0.12..8.14 rows=1 width=601) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
22. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2018q4_ix03 on game_play_p2018q4 gameplay0__15 (cost=0.12..8.14 rows=1 width=601) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
23. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2019q1_ix03 on game_play_p2019q1 gameplay0__16 (cost=0.12..8.14 rows=1 width=602) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
24. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2019q2_ix03 on game_play_p2019q2 gameplay0__17 (cost=0.12..8.14 rows=1 width=601) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
25. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2019q3_ix03 on game_play_p2019q3 gameplay0__18 (cost=0.12..8.14 rows=1 width=601) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
26. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2019q4_ix03 on game_play_p2019q4 gameplay0__19 (cost=0.12..8.14 rows=1 width=537) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
27. 0.136 0.136 ↓ 0.0 0 68

Index Scan using game_play_p2020q1_ix03 on game_play_p2020q1 gameplay0__20 (cost=0.12..8.14 rows=1 width=390) (actual time=0.002..0.002 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
28. 0.204 0.204 ↓ 0.0 0 68

Index Scan using game_play_p2020q2_ix03 on game_play_p2020q2 gameplay0__21 (cost=0.12..8.14 rows=1 width=397) (actual time=0.003..0.003 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
29. 2,570.196 2,570.196 ↓ 0.0 0 68

Index Scan using game_play_p2020q3_ix03 on game_play_p2020q3 gameplay0__22 (cost=0.38..8.39 rows=1 width=395) (actual time=37.797..37.797 rows=0 loops=68)

  • Index Cond: (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone)
  • Filter: (gameprofil1_.game_profile_id = game_profile_id)
  • Rows Removed by Filter: 2
30. 0.272 0.272 ↓ 0.0 0 68

Index Scan using game_play_p2020q4_unq01 on game_play_p2020q4 gameplay0__23 (cost=0.14..3.83 rows=1 width=4,892) (actual time=0.004..0.004 rows=0 loops=68)

  • Index Cond: (game_profile_id = gameprofil1_.game_profile_id)
  • Filter: ((expiry_date IS NOT NULL) AND (expiry_date <= '2020-09-11 14:53:09.158+00'::timestamp with time zone))
Planning time : 11.344 ms
Execution time : 2,582.055 ms