explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sr39

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 149.281 ↑ 1.0 1 1

Aggregate (cost=179.22..179.23 rows=1 width=40) (actual time=149.281..149.281 rows=1 loops=1)

2. 0.075 149.278 ↓ 0.0 0 1

Hash Join (cost=154.36..179.10 rows=15 width=48) (actual time=149.278..149.278 rows=0 loops=1)

  • Hash Cond: (d.attachmentid = att.id)
3. 0.090 0.090 ↑ 1.0 906 1

Seq Scan on document d (cost=0.00..20.06 rows=906 width=52) (actual time=0.021..0.090 rows=906 loops=1)

4. 0.174 149.113 ↓ 100.3 1,504 1

Hash (cost=154.18..154.18 rows=15 width=4) (actual time=149.113..149.113 rows=1,504 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 69kB
5. 148.939 148.939 ↓ 100.3 1,504 1

Foreign Scan on attachment att (cost=100.00..154.18 rows=15 width=4) (actual time=84.979..148.939 rows=1,504 loops=1)

Planning time : 0.189 ms