explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 46x0

Settings
# exclusive inclusive rows x rows loops node
1. 0.463 2,630.101 ↓ 37.2 186 1

Nested Loop (cost=8.89..163,545.35 rows=5 width=159) (actual time=90.763..2,630.101 rows=186 loops=1)

2. 817.485 2,164.638 ↓ 37.2 186 1

Hash Join (cost=8.46..163,542.89 rows=5 width=27) (actual time=10.688..2,164.638 rows=186 loops=1)

  • Hash Cond: (pa.authid = a.id)
3. 1,347.069 1,347.069 ↓ 1.0 8,997,872 1

Seq Scan on paperauths pa (cost=0.00..129,792.73 rows=8,997,773 width=8) (actual time=0.015..1,347.069 rows=8,997,872 loops=1)

4. 0.004 0.084 ↑ 1.0 1 1

Hash (cost=8.45..8.45 rows=1 width=19) (actual time=0.084..0.084 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.080 0.080 ↑ 1.0 1 1

Index Scan using idx_auth_name on authors a (cost=0.43..8.45 rows=1 width=19) (actual time=0.078..0.080 rows=1 loops=1)

  • Index Cond: ((name)::text = 'David J. DeWitt'::text)
6. 465.000 465.000 ↑ 1.0 1 186

Index Scan using papers_pkey on papers p (cost=0.43..0.48 rows=1 width=132) (actual time=2.498..2.500 rows=1 loops=186)

  • Index Cond: (id = pa.paperid)
Planning time : 1.015 ms
Execution time : 2,630.247 ms