explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NMYk

Settings
# exclusive inclusive rows x rows loops node
1. 0.294 12.599 ↓ 0.0 0 1

Bitmap Heap Scan on match (cost=44,099.40..44,183.40 rows=7 width=2,171) (actual time=12.599..12.599 rows=0 loops=1)

  • Recheck Cond: ((awayteamseason_id = 'a7d84fe3-fdaf-42bc-bc71-c42a7e7de028'::uuid) OR (hometeamseason_id = 'a7d84fe3-fdaf-42bc-bc71-c42a7e7de028'::uuid))
  • Filter: ((date)::date < now())
  • Rows Removed by Filter: 38
  • Heap Blocks: exact=37
2. 0.001 12.305 ↓ 0.0 0 1

BitmapOr (cost=44,099.40..44,099.40 rows=21 width=0) (actual time=12.305..12.305 rows=0 loops=1)

3. 0.092 0.092 ↓ 1.9 19 1

Bitmap Index Scan on match_awayteamseason_id_hometeamseason_id_idx (cost=0.00..8.49 rows=10 width=0) (actual time=0.091..0.092 rows=19 loops=1)

  • Index Cond: (awayteamseason_id = 'a7d84fe3-fdaf-42bc-bc71-c42a7e7de028'::uuid)
4. 12.212 12.212 ↓ 1.9 19 1

Bitmap Index Scan on match_awayteamseason_id_hometeamseason_id_idx (cost=0.00..44,090.90 rows=10 width=0) (actual time=12.212..12.212 rows=19 loops=1)

  • Index Cond: (hometeamseason_id = 'a7d84fe3-fdaf-42bc-bc71-c42a7e7de028'::uuid)
Planning time : 1.596 ms
Execution time : 12.666 ms