explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H4oY

Settings
# exclusive inclusive rows x rows loops node
1. 35.154 297.278 ↑ 1.0 3 1

HashAggregate (cost=28,905.96..28,905.99 rows=3 width=20) (actual time=297.276..297.278 rows=3 loops=1)

  • Group Key: s.lab_name
2. 78.890 262.124 ↑ 1.0 125,222 1

Hash Join (cost=296.00..28,279.80 rows=125,232 width=20) (actual time=5.606..262.124 rows=125,222 loops=1)

  • Hash Cond: (measurements.scientist_id = s.scientist_id)
3. 177.659 177.659 ↑ 1.0 125,222 1

Seq Scan on measurements (cost=0.00..24,853.00 rows=125,232 width=8) (actual time=0.016..177.659 rows=125,222 loops=1)

  • Filter: ((value_1 = 0) AND (value_2 = 0) AND (value_3 = 0))
  • Rows Removed by Filter: 874778
4. 3.247 5.575 ↑ 1.0 10,000 1

Hash (cost=171.00..171.00 rows=10,000 width=28) (actual time=5.575..5.575 rows=10,000 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 599kB
5. 2.328 2.328 ↑ 1.0 10,000 1

Seq Scan on scientist_labs s (cost=0.00..171.00 rows=10,000 width=28) (actual time=0.006..2.328 rows=10,000 loops=1)