explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZnQg

Settings
# exclusive inclusive rows x rows loops node
1. 1.052 66.856 ↑ 93.0 1 1

Nested Loop (cost=3,628.13..3,928.75 rows=93 width=72) (actual time=66.849..66.856 rows=1 loops=1)

2. 0.018 0.018 ↑ 1.0 1 1

Seq Scan on person_preflop_start_stats_average ia (cost=0.00..1.71 rows=1 width=36) (actual time=0.013..0.018 rows=1 loops=1)

  • Filter: (("position" = 0) AND (cnt_players = 6))
  • Rows Removed by Filter: 46
3. 0.003 65.786 ↑ 93.0 1 1

Nested Loop (cost=3,628.13..3,642.46 rows=93 width=184) (actual time=65.784..65.786 rows=1 loops=1)

4. 0.042 0.042 ↑ 1.0 1 1

Index Scan using inx_preflop_start_id on person_preflop_start_stats_average_per_person ip (cost=0.29..8.30 rows=1 width=84) (actual time=0.041..0.042 rows=1 loops=1)

  • Index Cond: (id_player = 1)
5. 0.101 65.741 ↑ 93.0 1 1

GroupAggregate (cost=3,627.85..3,632.30 rows=93 width=114) (actual time=65.741..65.741 rows=1 loops=1)

  • Group Key: l.cnt_players, l."position", p.player_name, s.id_player
6. 0.104 65.640 ↓ 1.3 126 1

Sort (cost=3,627.85..3,628.08 rows=94 width=25) (actual time=65.635..65.640 rows=126 loops=1)

  • Sort Key: p.player_name
  • Sort Method: quicksort Memory: 34kB
7. 0.023 65.536 ↓ 1.3 126 1

Nested Loop (cost=27.69..3,624.77 rows=94 width=25) (actual time=58.873..65.536 rows=126 loops=1)

8. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on lookup_positions l (cost=0.00..2.04 rows=1 width=4) (actual time=0.007..0.013 rows=1 loops=1)

  • Filter: (("position" = 0) AND (cnt_players = 6))
  • Rows Removed by Filter: 68
9. 0.033 65.500 ↓ 1.3 126 1

Nested Loop (cost=27.69..3,621.79 rows=94 width=25) (actual time=58.865..65.500 rows=126 loops=1)

10. 0.032 0.032 ↑ 1.0 1 1

Index Scan using player_primary_key on player p (cost=0.29..8.30 rows=1 width=14) (actual time=0.029..0.032 rows=1 loops=1)

  • Index Cond: (id_player = 1)
11. 6.824 65.435 ↓ 1.3 126 1

Bitmap Heap Scan on cash_hand_player_statistics s (cost=27.40..3,612.55 rows=94 width=15) (actual time=58.830..65.435 rows=126 loops=1)

  • Recheck Cond: (id_player = 1)
  • Filter: ((NOT flg_hero) AND ("position" = 0) AND (cnt_players = 6))
  • Rows Removed by Filter: 1601
  • Heap Blocks: exact=672
12. 58.611 58.611 ↓ 1.9 1,727 1

Bitmap Index Scan on "chps:idx2-id_player" (cost=0.00..27.38 rows=926 width=0) (actual time=58.611..58.611 rows=1,727 loops=1)

  • Index Cond: (id_player = 1)