explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wq3x

Settings
# exclusive inclusive rows x rows loops node
1. 17,694.669 118,587.000 ↑ 1,065.3 22,708 1

Hash Join (cost=3,369,435.37..4,527,404.19 rows=24,190,810 width=122) (actual time=101,000.633..118,587.000 rows=22,708 loops=1)

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

Nested Loop (cost=107.66..7,878.61 rows=24,190,810 width=122) (actual time=0.984..19.737 rows=22,708 loops=1)

3. 1.556 1.837 ↓ 20.1 4,028 1

HashAggregate (cost=107.10..109.10 rows=200 width=4) (actual time=0.970..1.837 rows=4,028 loops=1)

  • Group Key: tmp_measurements.measurement_id
4. 0.281 0.281 ↓ 1.1 4,028 1

Seq Scan on tmp_measurements (cost=0.00..98.28 rows=3,528 width=4) (actual time=0.009..0.281 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,491.086 100,872.594 ↓ 1.0 48,432,255 1

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

  • Buckets: 4194304 Batches: 32 Memory Usage: 85969kB
7. 92,381.508 92,381.508 ↓ 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..92,381.508 rows=48,432,255 loops=1)

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