explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2KyL

Settings
# exclusive inclusive rows x rows loops node
1. 9.380 101.850 ↑ 1.0 10,771 1

Hash Join (cost=233.08..1,933.82 rows=10,771 width=246) (actual time=33.095..101.850 rows=10,771 loops=1)

  • Hash Cond: (ae.comprehendid = subject.comprehendid)
2. 67.980 67.980 ↑ 1.0 10,771 1

Seq Scan on ae (cost=0.00..1,525.71 rows=10,771 width=246) (actual time=8.595..67.980 rows=10,771 loops=1)

3. 0.537 24.490 ↑ 1.0 3,090 1

Hash (cost=194.46..194.46 rows=3,090 width=22) (actual time=24.490..24.490 rows=3,090 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 164kB
4. 0.904 23.953 ↑ 1.0 3,090 1

Hash Join (cost=1.07..194.46 rows=3,090 width=22) (actual time=20.781..23.953 rows=3,090 loops=1)

  • Hash Cond: (subject.studyid = study.studyid)
5. 23.043 23.043 ↑ 1.0 3,090 1

Seq Scan on subject (cost=0.00..150.90 rows=3,090 width=27) (actual time=20.763..23.043 rows=3,090 loops=1)

6. 0.002 0.006 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=5) (actual time=0.006..0.006 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
7. 0.004 0.004 ↑ 1.0 3 1

Seq Scan on study (cost=0.00..1.03 rows=3 width=5) (actual time=0.003..0.004 rows=3 loops=1)

Planning time : 130.478 ms
Execution time : 102.551 ms