explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3FBH : Optimization for: plan #k88rS

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 2,326.566 5,975,989.990 ↓ 83.2 3,326,898 1

Aggregate (cost=15,385,816,054.030..15,385,842,138.990 rows=40,000 width=26) (actual time=5,966,245.164..5,975,989.990 rows=3,326,898 loops=1)

  • Buffers: shared hit=31698 read=33565
2. 7,349.452 5,973,663.424 ↓ 54.5 10,908,331 1

Gather Merge (cost=15,385,816,054.030..15,385,840,238.990 rows=200,000 width=26) (actual time=5,966,245.124..5,973,663.424 rows=10,908,331 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=198899 read=194678
3. 1,824.674 5,966,313.972 ↓ 45.5 1,818,055 6 / 6

Sort (cost=15,385,815,053.950..15,385,815,153.950 rows=40,000 width=26) (actual time=5,965,726.811..5,966,313.972 rows=1,818,055 loops=6)

  • Sort Key: romeo1.juliet, romeo1.tango
  • Sort Method: quicksort Memory: 169239kB
  • Buffers: shared hit=198899 read=194678
4. 2,498,268.994 5,964,489.298 ↓ 45.5 1,818,055 6 / 6

Aggregate (cost=15,385,811,596.410..15,385,811,996.410 rows=40,000 width=26) (actual time=5,963,806.250..5,964,489.298 rows=1,818,055 loops=6)

  • Buffers: shared hit=198829 read=194678
5. 3,460,780.497 3,466,220.304 ↑ 118.2 8,658,346,639 6 / 6

Hash Join (cost=341,024.530..7,712,495,727.150 rows=1,023,108,782,567 width=32) (actual time=3,535.866..3,466,220.304 rows=8,658,346,639 loops=6)

  • Buffers: shared hit=198829 read=194678
6. 1,935.122 1,935.122 ↑ 1.1 5,880,754 6 / 6

Seq Scan on foxtrot_zulu four (cost=0.000..260,858.680 rows=6,413,268 width=22) (actual time=0.015..1,935.122 rows=5,880,754 loops=6)

  • Buffers: shared hit=196726
7. 2,286.254 3,504.685 ↑ 1.1 5,880,754 6 / 6

Hash (cost=260,858.680..260,858.680 rows=6,413,268 width=18) (actual time=3,504.684..3,504.685 rows=5,880,754 loops=6)

  • Buffers: shared hit=2048 read=194678
8. 1,218.431 1,218.431 ↑ 1.1 5,880,754 6 / 6

Seq Scan on foxtrot_zulu foxtrot_juliet (cost=0.000..260,858.680 rows=6,413,268 width=18) (actual time=0.071..1,218.431 rows=5,880,754 loops=6)

  • Buffers: shared hit=2048 read=194678
Planning time : 0.36 ms
Execution time : 5,979,562.629 ms