explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Esu : sample lab exercise

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 0.194 ↑ 1.0 1 1

Aggregate (cost=20.30..20.31 rows=1 width=8) (actual time=0.194..0.194 rows=1 loops=1)

2. 0.070 0.166 ↑ 1.0 347 1

Hash Join (cost=8.19..19.43 rows=347 width=0) (actual time=0.081..0.166 rows=347 loops=1)

  • Hash Cond: (album.artistid = artist.artistid)
3. 0.029 0.029 ↑ 1.0 347 1

Seq Scan on album (cost=0.00..6.47 rows=347 width=4) (actual time=0.007..0.029 rows=347 loops=1)

4. 0.034 0.067 ↑ 1.0 275 1

Hash (cost=4.75..4.75 rows=275 width=4) (actual time=0.067..0.067 rows=275 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 18kB
5. 0.033 0.033 ↑ 1.0 275 1

Seq Scan on artist (cost=0.00..4.75 rows=275 width=4) (actual time=0.004..0.033 rows=275 loops=1)

Planning time : 0.172 ms
Execution time : 0.222 ms