explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KoxE

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=1,908,267.62..1,908,267.63 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Merge Join (cost=5,085.50..1,841,249.18 rows=26,807,375 width=8) (actual rows= loops=)

  • Merge Cond: (si.image_id = if.image_id)
3. 0.000 0.000 ↓ 0.0

Sort (cost=5,084.91..5,207.01 rows=48,839 width=8) (actual rows= loops=)

  • Sort Key: si.image_id
4. 0.000 0.000 ↓ 0.0

Seq Scan on rovi_season_images si (cost=0.00..1,281.39 rows=48,839 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Materialize (cost=0.56..1,495,309.30 rows=24,497,642 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Only Scan using rovi_imagefiles_image_id_file_format_id_idx on rovi_imagefiles if (cost=0.56..1,434,065.19 rows=24,497,642 width=8) (actual rows= loops=)