explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dH2c

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.274 6,877.382 ↑ 183.2 441 1

Nested Loop (cost=810.24..329,831.86 rows=80,800 width=207) (actual time=160.901..6,877.382 rows=441 loops=1)

  • Buffers: shared hit=1113099
2. 0.024 0.208 ↑ 9.0 45 1

Append (cost=0..69.03 rows=404 width=109) (actual time=0.018..0.208 rows=45 loops=1)

  • Buffers: shared hit=12
3. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on teams tm (cost=0..0 rows=1 width=122) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (tm.teamid < 250)
4. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on teams tm_1 (cost=0..16.62 rows=177 width=122) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (tm_1.teamid < 250)
5. 0.178 0.178 ↑ 1.1 45 1

Seq Scan on teams tm_2 (cost=0..33.76 rows=49 width=15) (actual time=0.013..0.178 rows=45 loops=1)

  • Filter: (tm_2.teamid < 250)
  • Buffers: shared hit=12
6. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on teams tm_3 (cost=0..16.62 rows=177 width=122) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (tm_3.teamid < 250)
7. 6,847.380 6,876.900 ↑ 20.0 10 45

Aggregate (cost=810.24..812.24 rows=200 width=98) (actual time=152.816..152.82 rows=10 loops=45)

  • Buffers: shared hit=1113087
8. 3.330 29.520 ↓ 1.9 406 45

Append (cost=0..266.15 rows=214 width=14) (actual time=0.08..0.656 rows=406 loops=45)

  • Buffers: shared hit=8076
9. 0.000 0.000 ↓ 0.0 0 45

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

  • Filter: ((tm.teamid = mtc.homeid) OR (tm.teamid = mtc.awayid))
10. 0.000 0.000 ↓ 0.0 0 45

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

  • Filter: ((tm.teamid = mtc_1.homeid) OR (tm.teamid = mtc_1.awayid))
11. 23.580 26.190 ↓ 2.1 406 45

Bitmap Heap Scan on matches mtc_2 (cost=8.95..208.18 rows=189 width=14) (actual time=0.074..0.582 rows=406 loops=45)

  • Buffers: shared hit=8076
12. 0.090 2.610 ↓ 0.0 0 45

BitmapOr (cost=8.95..8.95 rows=189 width=0) (actual time=0.058..0.058 rows=0 loops=45)

  • Buffers: shared hit=855
13. 1.350 1.350 ↓ 2.1 203 45

Bitmap Index Scan on inx_soccer_matches_home_date_cover (cost=0..4.43 rows=95 width=0) (actual time=0.03..0.03 rows=203 loops=45)

  • Index Cond: (tm.teamid = mtc_2.homeid)
  • Buffers: shared hit=427
14. 1.170 1.170 ↓ 2.2 203 45

Bitmap Index Scan on inx_soccer_away_home_date_cover (cost=0..4.42 rows=94 width=0) (actual time=0.026..0.026 rows=203 loops=45)

  • Index Cond: (tm.teamid = mtc_2.awayid)
  • Buffers: shared hit=428
15. 0.000 0.000 ↓ 0.0 0 45

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

  • Filter: ((tm.teamid = mtc_3.homeid) OR (tm.teamid = mtc_3.awayid))