explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FG5f

Settings
# exclusive inclusive rows x rows loops node
1. 0.773 3.812 ↓ 1.0 2,553 1

Hash Left Join (cost=136.540..311.350 rows=2,546 width=425) (actual time=1.349..3.812 rows=2,553 loops=1)

  • Hash Cond: (lima.charlie = november.quebec)
2. 1.072 2.102 ↓ 1.0 2,553 1

Hash Left Join (cost=41.610..181.910 rows=2,546 width=382) (actual time=0.396..2.102 rows=2,553 loops=1)

  • Hash Cond: (lima.tango = sierra.quebec)
3. 0.649 0.649 ↓ 1.0 2,553 1

Seq Scan on lima (cost=0.000..122.460 rows=2,546 width=355) (actual time=0.007..0.649 rows=2,553 loops=1)

4. 0.184 0.381 ↓ 1.0 1,176 1

Hash (cost=27.380..27.380 rows=1,138 width=27) (actual time=0.381..0.381 rows=1,176 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 84kB
5. 0.197 0.197 ↓ 1.0 1,176 1

Seq Scan on sierra (cost=0.000..27.380 rows=1,138 width=27) (actual time=0.003..0.197 rows=1,176 loops=1)

6. 0.402 0.937 ↓ 1.0 2,517 1

Hash (cost=63.860..63.860 rows=2,486 width=43) (actual time=0.937..0.937 rows=2,517 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 218kB
7. 0.535 0.535 ↓ 1.0 2,517 1

Seq Scan on november (cost=0.000..63.860 rows=2,486 width=43) (actual time=0.007..0.535 rows=2,517 loops=1)