explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E2Nx

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 162.578 ↑ 1.0 1 1

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

2. 0.090 162.574 ↓ 0.0 0 1

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

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

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

4. 0.260 162.376 ↓ 100.3 1,504 1

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

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

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

Planning time : 0.380 ms