explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JyDb

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.031 ↓ 0.0 0 1

Aggregate (cost=731.41..733.33 rows=192 width=98) (actual time=0.031..0.031 rows=0 loops=1)

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

Append (cost=0..243.25 rows=192 width=14) (actual time=0.028..0.028 rows=0 loops=1)

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

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

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

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

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

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

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

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

  • Buffers: shared hit=6
7. 0.011 0.011 ↓ 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.011..0.011 rows=0 loops=1)

  • Index Cond: (1 = mtc_2.homeid)
  • Buffers: shared hit=3
8. 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: (1 = mtc_2.awayid)
  • Buffers: shared hit=3
9. 0.001 0.001 ↓ 0.0 0 1

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

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