explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p27g

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 863.129 ↑ 1.0 50 1

Limit (cost=77,236.87..77,236.99 rows=50 width=36) (actual time=863.121..863.129 rows=50 loops=1)

2. 278.126 863.126 ↑ 22,458.3 50 1

Sort (cost=77,236.87..80,044.15 rows=1,122,914 width=36) (actual time=863.120..863.126 rows=50 loops=1)

  • Sort Key: two.november, charlie.quebec
  • Sort Method: top-N heapsort Memory: 27kB
3. 407.835 585.000 ↓ 1.0 1,123,178 1

Hash Join (cost=1,586.26..39,934.47 rows=1,122,914 width=36) (actual time=22.761..585.000 rows=1,123,178 loops=1)

  • Hash Cond: (charlie.juliet = sierra.quebec)
4. 154.554 154.554 ↓ 1.0 1,123,178 1

Seq Scan on charlie (cost=0.00..22,908.14 rows=1,122,914 width=8) (actual time=0.009..154.554 rows=1,123,178 loops=1)

5. 5.817 22.611 ↓ 1.0 22,633 1

Hash (cost=1,304.53..1,304.53 rows=22,539 width=36) (actual time=22.610..22.611 rows=22,633 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,729kB
6. 8.953 16.794 ↓ 1.0 22,633 1

Hash Join (cost=589.23..1,304.53 rows=22,539 width=36) (actual time=5.652..16.794 rows=22,633 loops=1)

  • Hash Cond: (sierra.hotel = two.quebec)
7. 2.269 2.269 ↓ 1.0 22,633 1

Seq Scan on sierra (cost=0.00..405.39 rows=22,539 width=8) (actual time=0.007..2.269 rows=22,633 loops=1)

8. 2.551 5.572 ↑ 1.0 12,410 1

Hash (cost=434.10..434.10 rows=12,410 width=36) (actual time=5.572..5.572 rows=12,410 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 981kB
9. 3.021 3.021 ↑ 1.0 12,410 1

Seq Scan on two (cost=0.00..434.10 rows=12,410 width=36) (actual time=0.006..3.021 rows=12,410 loops=1)

Planning time : 0.562 ms
Execution time : 863.181 ms