explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BFYS

Settings
# exclusive inclusive rows x rows loops node
1. 0.062 1,616.077 ↑ 1.0 1 1

Aggregate (cost=225.48..225.49 rows=1 width=40) (actual time=1,616.077..1,616.077 rows=1 loops=1)

2. 42.414 1,616.015 ↑ 7.2 136 1

Hash Join (cost=131.38..218.17 rows=975 width=48) (actual time=269.008..1,616.015 rows=136 loops=1)

  • Hash Cond: (att.id = d.attachmentid)
3. 1,573.126 1,573.126 ↓ 397.6 387,645 1

Foreign Scan on attachment att (cost=100.00..173.38 rows=975 width=4) (actual time=1.423..1,573.126 rows=387,645 loops=1)

4. 0.274 0.475 ↑ 1.0 906 1

Hash (cost=20.06..20.06 rows=906 width=52) (actual time=0.475..0.475 rows=906 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 85kB
5. 0.201 0.201 ↑ 1.0 906 1

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