explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FMLm : no trim

Settings
# exclusive inclusive rows x rows loops node
1. 0.100 3.990 ↓ 4.0 4 1

Sort (cost=295.54..295.55 rows=1 width=36) (actual time=3.953..3.990 rows=4 loops=1)

  • Sort Key: g_oc.date_g
  • Sort Method: quicksort Memory: 25kB
2. 0.141 3.890 ↓ 4.0 4 1

Nested Loop (cost=5.93..295.53 rows=1 width=36) (actual time=0.811..3.890 rows=4 loops=1)

3. 0.243 3.681 ↓ 4.0 4 1

Nested Loop (cost=5.78..287.34 rows=1 width=130) (actual time=0.756..3.681 rows=4 loops=1)

4. 0.122 3.314 ↓ 4.0 4 1

Nested Loop (cost=5.63..279.16 rows=1 width=32) (actual time=0.705..3.314 rows=4 loops=1)

5. 0.140 2.996 ↓ 4.0 4 1

Nested Loop (cost=5.35..270.86 rows=1 width=52) (actual time=0.572..2.996 rows=4 loops=1)

6. 0.142 2.752 ↓ 4.0 4 1

Nested Loop (cost=5.06..262.54 rows=1 width=28) (actual time=0.526..2.752 rows=4 loops=1)

7. 0.146 2.506 ↓ 4.0 4 1

Nested Loop (cost=5.06..262.47 rows=1 width=72) (actual time=0.486..2.506 rows=4 loops=1)

8. 0.164 2.268 ↓ 4.0 4 1

Nested Loop (cost=5.06..262.40 rows=1 width=92) (actual time=0.452..2.268 rows=4 loops=1)

9. 0.155 1.996 ↓ 4.0 4 1

Nested Loop (cost=5.05..262.33 rows=1 width=136) (actual time=0.414..1.996 rows=4 loops=1)

10. 0.150 1.729 ↓ 4.0 4 1

Nested Loop (cost=5.05..262.21 rows=1 width=112) (actual time=0.368..1.729 rows=4 loops=1)

11. 0.147 1.447 ↓ 4.0 4 1

Nested Loop (cost=5.04..262.09 rows=1 width=88) (actual time=0.320..1.447 rows=4 loops=1)

12. 0.128 1.184 ↓ 4.0 4 1

Nested Loop (cost=5.03..261.97 rows=1 width=64) (actual time=0.271..1.184 rows=4 loops=1)

13. 0.148 0.992 ↓ 4.0 4 1

Nested Loop (cost=4.74..253.65 rows=1 width=44) (actual time=0.238..0.992 rows=4 loops=1)

14. 0.173 0.728 ↓ 1.3 4 1

Nested Loop (cost=4.74..253.44 rows=3 width=64) (actual time=0.192..0.728 rows=4 loops=1)

15. 0.118 0.431 ↓ 1.3 4 1

Nested Loop (cost=4.73..253.08 rows=3 width=40) (actual time=0.136..0.431 rows=4 loops=1)

16. 0.188 0.213 ↑ 1.0 4 1

Bitmap Heap Scan on games_atp g_oc (cost=4.44..219.83 rows=4 width=20) (actual time=0.084..0.213 rows=4 loops=1)

  • Recheck Cond: (id_t_g = 1114)
  • Filter: ((date_g IS NULL) AND (id_r_g = 9))
  • Rows Removed by Filter: 66
  • Heap Blocks: exact=48
17. 0.025 0.025 ↓ 1.2 70 1

Bitmap Index Scan on idx_oc_games_atp_id_t_g (cost=0.00..4.43 rows=58 width=0) (actual time=0.017..0.025 rows=70 loops=1)

  • Index Cond: (id_t_g = 1114)
18. 0.100 0.100 ↑ 1.0 1 4

Index Scan using players_atp_pkey on players_atp p1_oc (cost=0.29..8.31 rows=1 width=28) (actual time=0.023..0.025 rows=1 loops=4)

  • Index Cond: (id_p = g_oc.id1_g)
  • Filter: ((name_p)::text ~~ '%/%'::text)
19. 0.124 0.124 ↑ 1.0 1 4

Index Scan using idx_oc_lower_player_name_atp on players_atp p1a_oc (cost=0.01..0.11 rows=1 width=24) (actual time=0.020..0.031 rows=1 loops=4)

  • Index Cond: (lower((name_p)::text) = lower(btrim(split_part((p1_oc.name_p)::text, '/'::text, 1))))
20. 0.116 0.116 ↑ 1.0 1 4

Index Scan using idx_master_lower_player_name_atp on player_atp p1a_master (cost=0.00..0.06 rows=1 width=20) (actual time=0.018..0.029 rows=1 loops=4)

  • Index Cond: (lower((name)::text) = lower((p1a_oc.name_p)::text))
21. 0.064 0.064 ↑ 1.0 1 4

Index Scan using players_atp_pkey on players_atp p2_oc (cost=0.29..8.31 rows=1 width=28) (actual time=0.014..0.016 rows=1 loops=4)

  • Index Cond: (id_p = g_oc.id2_g)
  • Filter: ((name_p)::text ~~ '%/%'::text)
22. 0.116 0.116 ↑ 1.0 1 4

Index Scan using idx_oc_lower_player_name_atp on players_atp p1b_oc (cost=0.01..0.11 rows=1 width=24) (actual time=0.016..0.029 rows=1 loops=4)

  • Index Cond: (lower((name_p)::text) = lower(btrim(split_part((p1_oc.name_p)::text, '/'::text, 2))))
23. 0.132 0.132 ↑ 1.0 1 4

Index Scan using idx_oc_lower_player_name_atp on players_atp p2a_oc (cost=0.01..0.11 rows=1 width=24) (actual time=0.016..0.033 rows=1 loops=4)

  • Index Cond: (lower((name_p)::text) = lower(btrim(split_part((p2_oc.name_p)::text, '/'::text, 1))))
24. 0.112 0.112 ↑ 1.0 1 4

Index Scan using idx_oc_lower_player_name_atp on players_atp p2b_oc (cost=0.01..0.11 rows=1 width=24) (actual time=0.017..0.028 rows=1 loops=4)

  • Index Cond: (lower((name_p)::text) = lower(btrim(split_part((p2_oc.name_p)::text, '/'::text, 2))))
25. 0.108 0.108 ↑ 1.0 1 4

Index Scan using idx_master_lower_player_name_atp on player_atp p1b_master (cost=0.00..0.06 rows=1 width=20) (actual time=0.014..0.027 rows=1 loops=4)

  • Index Cond: (lower((name)::text) = lower((p1b_oc.name_p)::text))
26. 0.092 0.092 ↑ 1.0 1 4

Index Scan using idx_master_lower_player_name_atp on player_atp p2a_master (cost=0.00..0.06 rows=1 width=20) (actual time=0.012..0.023 rows=1 loops=4)

  • Index Cond: (lower((name)::text) = lower((p2a_oc.name_p)::text))
27. 0.104 0.104 ↑ 1.0 1 4

Index Scan using idx_master_lower_player_name_atp on player_atp p2b_master (cost=0.00..0.06 rows=1 width=20) (actual time=0.015..0.026 rows=1 loops=4)

  • Index Cond: (lower((name)::text) = lower((p2b_oc.name_p)::text))
28. 0.104 0.104 ↑ 1.0 1 4

Index Scan using tours_atp_pkey on tours_atp t_oc (cost=0.29..8.30 rows=1 width=28) (actual time=0.015..0.026 rows=1 loops=4)

  • Index Cond: (id_t = 1114)
29. 0.196 0.196 ↑ 1.0 1 4

Index Scan using tournament_atp_c1 on tournament_atp t_master (cost=0.29..8.30 rows=1 width=28) (actual time=0.047..0.049 rows=1 loops=4)

  • Index Cond: (((name)::text = (t_oc.name_t)::text) AND (start_date = t_oc.date_t))
30. 0.124 0.124 ↑ 1.0 1 4

Index Scan using rounds_pkey on rounds r_oc (cost=0.15..8.17 rows=1 width=102) (actual time=0.014..0.031 rows=1 loops=4)

  • Index Cond: (id_r = 9)
31. 0.068 0.068 ↑ 1.0 1 4

Index Scan using rounds_name_key on rounds r_master (cost=0.15..8.17 rows=1 width=102) (actual time=0.016..0.017 rows=1 loops=4)

  • Index Cond: ((name)::text = (r_oc.name_r)::text)
Planning time : 5.817 ms
Execution time : 4.658 ms