explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ltM8

Settings
# exclusive inclusive rows x rows loops node
1. 1,018.643 3,999.804 ↓ 1,160.0 857,259 1

Merge Join (cost=0.850..388,865.370 rows=739 width=41) (actual time=0.026..3,999.804 rows=857,259 loops=1)

  • Merge Cond: (victor.juliet = bravo.juliet)
  • Join Filter: (bravo.india = (alpha(victor.india)))
  • Rows Removed by Join Filter: 992857
2. 796.390 1,981.467 ↓ 1.2 857,259 1

GroupAggregate (cost=0.430..184,710.990 rows=714,584 width=12) (actual time=0.017..1,981.467 rows=857,259 loops=1)

  • Group Key: victor.juliet
3. 1,185.077 1,185.077 ↓ 1.0 1,850,116 1

Index Scan using quebec on victor (cost=0.430..168,736.690 rows=1,765,692 width=12) (actual time=0.009..1,185.077 rows=1,850,116 loops=1)

4. 999.694 999.694 ↓ 1.0 1,850,116 1

Index Scan using quebec on victor bravo (cost=0.430..168,736.690 rows=1,765,692 width=49) (actual time=0.004..999.694 rows=1,850,116 loops=1)

Planning time : 0.278 ms
Execution time : 4,165.258 ms