explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UorS

Settings
# exclusive inclusive rows x rows loops node
1. 1,119.603 10,370.183 ↓ 97.1 857,259 1

Seq Scan on victor bravo (cost=0.000..22,049,484.170 rows=8,828 width=41) (actual time=4.462..10,370.183 rows=857,259 loops=1)

  • Filter: (india = (delta 1))
  • Rows Removed by Filter: 992857
2.          

SubPlan (forSeq Scan)

3. 3,700.232 9,250.580 ↑ 1.0 1 1,850,116

Aggregate (cost=12.450..12.460 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=1,850,116)

4. 5,550.348 5,550.348 ↓ 1.5 3 1,850,116

Index Scan using quebec on victor (cost=0.430..12.440 rows=2 width=8) (actual time=0.002..0.003 rows=3 loops=1,850,116)

  • Index Cond: (juliet = bravo.juliet)
Planning time : 0.812 ms
Execution time : 10,548.537 ms