explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WMnp

Settings
# exclusive inclusive rows x rows loops node
1. 0.397 4.855 ↑ 22.9 684 1

Merge Left Join (cost=82.09..1,151.06 rows=15,695 width=363) (actual time=0.414..4.855 rows=684 loops=1)

  • Merge Cond: (ladder.id = ""entryFee"".""ladderId"")
2. 0.361 4.455 ↑ 4.1 684 1

Merge Left Join (cost=81.94..1,115.31 rows=2,774 width=378) (actual time=0.409..4.455 rows=684 loops=1)

  • Merge Cond: (ladder.id = ""ladderPassword"".""ladderId"")
3. 0.527 4.092 ↑ 1.1 684 1

Merge Left Join (cost=81.79..1,040.70 rows=756 width=346) (actual time=0.405..4.092 rows=684 loops=1)

  • Merge Cond: (ladder.id = ""gameParameter"".""ladderId"")
4. 0.374 3.056 ↓ 1.1 359 1

Nested Loop Left Join (cost=0.70..948.49 rows=326 width=327) (actual time=0.043..3.056 rows=359 loops=1)

5. 0.203 0.528 ↓ 1.1 359 1

Merge Left Join (cost=0.43..47.62 rows=326 width=211) (actual time=0.031..0.528 rows=359 loops=1)

  • Merge Cond: (ladder.id = registration.""ladderId"")
6. 0.245 0.245 ↑ 1.0 326 1

Index Scan using ""PK_40842f36d4d90b54eb5621ee735"" on ladder (cost=0.15..24.84 rows=326 width=146) (actual time=0.014..0.245 rows=326 loops=1)

  • Filter: ((""deletedOn"" IS NULL) AND (state = ANY ('{validating,done}'::ladder_state_enum[])) AND ((""gameSlug"")::text = 'warzone'::text))
  • Rows Removed by Filter: 1
7. 0.023 0.080 ↑ 1.0 37 1

Materialize (cost=0.28..21.50 rows=37 width=65) (actual time=0.013..0.080 rows=37 loops=1)

8. 0.042 0.057 ↑ 1.0 37 1

Nested Loop Left Join (cost=0.28..21.41 rows=37 width=65) (actual time=0.010..0.057 rows=37 loops=1)

  • Join Filter: (player.""registrationId"" = registration.id)
9. 0.015 0.015 ↑ 1.0 37 1

Index Scan using ""UQ_ae9df163e90cadf2af68dbf21a1"" on ladder_registration registration (cost=0.14..12.70 rows=37 width=36) (actual time=0.003..0.015 rows=37 loops=1)

10. 0.000 0.000 ↓ 0.0 0 37

Materialize (cost=0.14..8.16 rows=1 width=29) (actual time=0.000..0.000 rows=0 loops=37)

11. 0.004 0.004 ↓ 0.0 0 1

Index Scan using ""PK_70742d4852d2d81096a67b61a57"" on ladder_registration_player player (cost=0.14..8.16 rows=1 width=29) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (""userId"" = '60513'::bigint)
12. 2.154 2.154 ↑ 1.0 1 359

Index Scan using ""PK_f698e8a4d0124769b21f55880ed"" on ladder_prize prize (cost=0.27..2.75 rows=1 width=116) (actual time=0.005..0.006 rows=1 loops=359)

  • Index Cond: (""ladderId"" = ladder.id)
13. 0.325 0.509 ↑ 1.2 651 1

Sort (cost=81.09..82.98 rows=758 width=19) (actual time=0.359..0.509 rows=651 loops=1)

  • Sort Key: ""gameParameter"".""ladderId"
  • Sort Method: quicksort Memory: 75kB
14. 0.158 0.184 ↑ 1.2 652 1

Bitmap Heap Scan on ladder_game_parameter ""gameParameter"" (cost=32.25..44.83 rows=758 width=19) (actual time=0.034..0.184 rows=652 loops=1)

  • Heap Blocks: exact=5
15. 0.026 0.026 ↑ 1.2 652 1

Bitmap Index Scan on ""PK_53aac850511da2fad64cf3c3178"" (cost=0.00..32.06 rows=758 width=0) (actual time=0.026..0.026 rows=652 loops=1)

16. 0.002 0.002 ↓ 0.0 0 1

Index Scan using ""PK_0324d258259dd07cc00d3dbd4af"" on ladder_password ""ladderPassword"" (cost=0.15..62.15 rows=1,200 width=40) (actual time=0.002..0.002 rows=0 loops=1)

17. 0.003 0.003 ↑ 1,850.0 1 1

Index Scan using ""PK_bddf862ba2d2a1e76f7798f791c"" on ladder_entry_fee ""entryFee"" (cost=0.15..48.90 rows=1,850 width=16) (actual time=0.002..0.003 rows=1 loops=1)

Planning time : 1.120 ms
Execution time : 5.104 ms