explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qQfX

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.025 ↓ 0.0 0 1

Append (cost=0..243.25 rows=192 width=38) (actual time=0.025..0.025 rows=0 loops=1)

  • Buffers: shared hit=6
2. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on matches mtc (cost=0..0 rows=1 width=38) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((mtc.homeid = 1) OR (mtc.awayid = 1))
3. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on matches mtc_1 (cost=0..28.45 rows=12 width=38) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((mtc_1.homeid = 1) OR (mtc_1.awayid = 1))
4. 0.001 0.019 ↓ 0.0 0 1

Bitmap Heap Scan on matches mtc_2 (cost=8.77..185.39 rows=167 width=38) (actual time=0.019..0.019 rows=0 loops=1)

  • Buffers: shared hit=6
5. 0.001 0.018 ↓ 0.0 0 1

BitmapOr (cost=8.77..8.77 rows=167 width=0) (actual time=0.018..0.018 rows=0 loops=1)

  • Buffers: shared hit=6
6. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on inx_soccer_matches_home_date_cover (cost=0..4.35 rows=84 width=0) (actual time=0.01..0.01 rows=0 loops=1)

  • Index Cond: (mtc_2.homeid = 1)
  • Buffers: shared hit=3
7. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on inx_soccer_away_home_date_cover (cost=0..4.34 rows=83 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (mtc_2.awayid = 1)
  • Buffers: shared hit=3
8. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on matches mtc_3 (cost=0..28.45 rows=12 width=38) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((mtc_3.homeid = 1) OR (mtc_3.awayid = 1))