explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nBRA

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 43,914.891 ↑ 1.0 1 1

Aggregate (cost=18,121,096.25..18,121,096.26 rows=1 width=8) (actual time=43,914.891..43,914.891 rows=1 loops=1)

2. 54.857 43,914.857 ↑ 2.9 34 1

Seq Scan on results r (cost=0.00..18,121,096.00 rows=100 width=0) (actual time=1,123.026..43,914.857 rows=34 loops=1)

  • Filter: (result = (SubPlan 1))
  • Rows Removed by Filter: 19966
3.          

SubPlan (for Seq Scan)

4. 5,320.000 43,860.000 ↑ 1.0 1 20,000

Aggregate (cost=906.00..906.01 rows=1 width=8) (actual time=2.193..2.193 rows=1 loops=20,000)

5. 38,540.000 38,540.000 ↓ 1.0 4,001 20,000

Seq Scan on results r1 (cost=0.00..896.00 rows=4,000 width=8) (actual time=0.002..1.927 rows=4,001 loops=20,000)

  • Filter: (sportid = r.sportid)
  • Rows Removed by Filter: 15999