explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sd1f

Settings
# exclusive inclusive rows x rows loops node
1. 9,864.262 101,895.732 ↑ 1,065.3 22,708 1

Hash Join (cost=3,369,441.62..4,527,410.44 rows=24,190,810 width=122) (actual time=92,032.934..101,895.732 rows=22,708 loops=1)

  • Hash Cond: (mf.file_id = measurement_files.file_id)
2. 5.249 19.127 ↑ 1,065.3 22,708 1

Nested Loop (cost=113.91..7,884.86 rows=24,190,810 width=122) (actual time=0.932..19.127 rows=22,708 loops=1)

3. 1.535 1.794 ↓ 20.1 4,028 1

HashAggregate (cost=113.35..115.35 rows=200 width=4) (actual time=0.921..1.794 rows=4,028 loops=1)

  • Group Key: tmp_measurements.measurement_id
4. 0.259 0.259 ↑ 1.0 4,028 1

Seq Scan on tmp_measurements (cost=0.00..103.28 rows=4,028 width=4) (actual time=0.009..0.259 rows=4,028 loops=1)

5. 12.084 12.084 ↑ 32.7 6 4,028

Index Scan using idx_measurement_files_measurement_id on measurement_files mf (cost=0.56..36.89 rows=196 width=122) (actual time=0.002..0.003 rows=6 loops=4,028)

  • Index Cond: (measurement_id = tmp_measurements.measurement_id)
6. 8,364.916 92,012.343 ↓ 1.0 48,432,255 1

Hash (cost=2,575,566.45..2,575,566.45 rows=48,381,620 width=4) (actual time=92,012.343..92,012.343 rows=48,432,255 loops=1)

  • Buckets: 4194304 Batches: 32 Memory Usage: 85969kB
7. 83,647.427 83,647.427 ↓ 1.0 48,432,255 1

Seq Scan on measurement_files (cost=0.00..2,575,566.45 rows=48,381,620 width=4) (actual time=0.025..83,647.427 rows=48,432,255 loops=1)

  • Filter: (mount_point_id = ANY ('{1,2,3,4,5,6,7,8,9,10}'::integer[]))