explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DTXo

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 239.038 ↑ 1.0 10 1

Limit (cost=1,003.66..247,998.65 rows=10 width=1,408) (actual time=157.700..239.038 rows=10 loops=1)

2. 72.957 239.029 ↑ 5.6 10 1

Gather Merge (cost=1,003.66..1,384,175.63 rows=56 width=1,408) (actual time=157.699..239.029 rows=10 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.019 166.072 ↑ 2.6 9 3 / 3

Nested Loop Left Join (cost=3.63..1,383,169.14 rows=23 width=1,408) (actual time=150.980..166.072 rows=9 loops=3)

4. 0.020 165.864 ↑ 2.4 9 3 / 3

Nested Loop Anti Join (cost=2.94..1,383,067.33 rows=22 width=739) (actual time=150.953..165.864 rows=9 loops=3)

5. 0.020 165.772 ↑ 2.4 9 3 / 3

Nested Loop Anti Join (cost=2.66..1,382,998.11 rows=22 width=780) (actual time=150.911..165.772 rows=9 loops=3)

6. 0.080 164.322 ↓ 3.0 65 3 / 3

Nested Loop Left Join (cost=2.24..1,382,916.24 rows=22 width=780) (actual time=149.602..164.322 rows=65 loops=3)

7. 0.037 161.382 ↓ 3.0 65 3 / 3

Nested Loop (cost=1.54..1,382,813.67 rows=22 width=111) (actual time=149.534..161.382 rows=65 loops=3)

  • Join Filter: ((pvp_player.profile_id)::text = (redeem_code.profile_id)::text)
8. 0.190 158.875 ↓ 1.7 65 3 / 3

Nested Loop (cost=0.99..1,382,647.75 rows=38 width=104) (actual time=149.462..158.875 rows=65 loops=3)

9. 150.806 150.806 ↑ 10.9 207 3 / 3

Parallel Index Scan Backward using pvp_player_summary_guild_power_idx on pvp_player (cost=0.43..1,363,529.72 rows=2,248 width=53) (actual time=149.217..150.806 rows=207 loops=3)

  • Index Cond: (summary_guild_power >= 0)
  • Filter: (((summary_guild_power)::numeric >= 10,784.15) AND ((summary_guild_power)::numeric <= 22,397.850000000002))
  • Rows Removed by Filter: 16,823
10. 7.879 7.879 ↓ 0.0 0 622 / 3

Index Scan using player_profile_pkey on player_profile (cost=0.56..8.50 rows=1 width=51) (actual time=0.038..0.038 rows=0 loops=622)

  • Index Cond: ((profile_id)::text = (pvp_player.profile_id)::text)
  • Filter: ((NOT is_cheater) AND (NOT is_qa_account) AND ((profile_id)::text !~~ 'AND%-%'::text) AND ((profile_id)::text !~~ 'Fb%-%'::text) AND ((profile_id)::text !~~ 'IOS%-%'::text) AND (update_datetime >= '2020-01-06 17:11:57.046645'::timestamp without time zone))
  • Rows Removed by Filter: 1
11. 2.470 2.470 ↑ 1.0 1 195 / 3

Index Scan using redeem_code_pkey on redeem_code (cost=0.56..4.35 rows=1 width=48) (actual time=0.038..0.038 rows=1 loops=195)

  • Index Cond: ((profile_id)::text = (player_profile.profile_id)::text)
12. 2.860 2.860 ↑ 15.0 1 195 / 3

Index Scan using profile_bit_pk on profile_bit (cost=0.70..60.20 rows=15 width=710) (actual time=0.044..0.044 rows=1 loops=195)

  • Index Cond: (((profile_id)::text = (player_profile.profile_id)::text) AND ((bit_name)::text = 'NameBit'::text))
13. 1.430 1.430 ↑ 1.0 1 195 / 3

Index Only Scan using guild_member_pkey on guild_member (cost=0.41..3.58 rows=1 width=40) (actual time=0.022..0.022 rows=1 loops=195)

  • Index Cond: (profile_id = (pvp_player.profile_id)::text)
  • Heap Fetches: 31
14. 0.072 0.072 ↓ 0.0 0 27 / 3

Index Only Scan using guild_recruits_black_list_pkey on guild_recruits_black_list (cost=0.28..3.02 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=27)

  • Index Cond: ((guild_id = 53,652) AND (profile_id = (pvp_player.profile_id)::text))
  • Heap Fetches: 0
15. 0.189 0.189 ↑ 16.0 1 27 / 3

Index Scan using profile_bit_pk on profile_bit profile_bit_1 (cost=0.70..63.62 rows=16 width=710) (actual time=0.021..0.021 rows=1 loops=27)

  • Index Cond: (((profile_id)::text = (player_profile.profile_id)::text) AND ((bit_name)::text = 'RankBit'::text))
Planning time : 7.815 ms
Execution time : 239.225 ms