explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 67Mi

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.083 ↑ 1.0 1 1

Hash Right Join (cost=12.91..23.74 rows=1 width=3,574) (actual time=0.081..0.083 rows=1 loops=1)

  • Hash Cond: ("e.ArchiveIndex".id = e.archiveindexid)
2. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on archiveindexes "e.ArchiveIndex" (cost=0.00..10.60 rows=60 width=1,173) (actual time=0.007..0.007 rows=0 loops=1)

3. 0.004 0.062 ↑ 1.0 1 1

Hash (cost=12.90..12.90 rows=1 width=2,401) (actual time=0.062..0.062 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.016 0.058 ↑ 1.0 1 1

Hash Join (cost=9.59..12.90 rows=1 width=2,401) (actual time=0.050..0.058 rows=1 loops=1)

  • Hash Cond: ("e.DocType".id = e.doctypeid)
5. 0.013 0.013 ↑ 1.0 94 1

Seq Scan on doctypes "e.DocType" (cost=0.00..2.94 rows=94 width=1,869) (actual time=0.010..0.013 rows=94 loops=1)

6. 0.006 0.029 ↑ 1.0 1 1

Hash (cost=9.58..9.58 rows=1 width=532) (actual time=0.029..0.029 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.003 0.023 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.43..9.58 rows=1 width=532) (actual time=0.022..0.023 rows=1 loops=1)

  • Join Filter: (e.docsourcetypeid = "e.DocSourceType".id)
  • Rows Removed by Join Filter: 6
8. 0.015 0.015 ↑ 1.0 1 1

Index Scan using pk_docs on docs e (cost=0.43..8.45 rows=1 width=455) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (id = 117774)
9. 0.005 0.005 ↑ 1.0 6 1

Seq Scan on docsourcetypes "e.DocSourceType" (cost=0.00..1.06 rows=6 width=77) (actual time=0.005..0.005 rows=6 loops=1)