explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OOc9

Settings
# exclusive inclusive rows x rows loops node
1. 82,787.695 217,481.637 ↑ 1.0 1 1

Hash Join (cost=5,831,347.890..16,806,120.100 rows=1 width=28) (actual time=167,450.958..217,481.637 rows=1 loops=1)

  • Hash Cond: ((three.foxtrot = seven2.foxtrot) AND (three.zulu = seven2.zulu) AND (three.bravo = seven2.bravo) AND (three.two_tango = (alpha_four(seven2.two_tango))))
2. 44,789.802 44,789.802 ↑ 1.0 329,243,097 1

Seq Scan on yankee three (cost=0.000..6,036,124.680 rows=329,243,168 width=28) (actual time=0.030..44,789.802 rows=329,243,097 loops=1)

3. 0.020 89,904.140 ↑ 1.0 1 1

Hash (cost=5,831,347.870..5,831,347.870 rows=1 width=28) (actual time=89,904.140..89,904.140 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
4. 0.010 89,904.120 ↑ 1.0 1 1

GroupAggregate (cost=5,831,347.820..5,831,347.860 rows=1 width=28) (actual time=89,904.120..89,904.120 rows=1 loops=1)

  • Group Key: seven2.foxtrot, seven2.zulu, seven2.bravo, ((golf(((seven2.two_tango / 900000))::double precision) * 'delta'::double precision))
5. 0.000 89,904.110 ↓ 3.0 3 1

Sort (cost=5,831,347.820..5,831,347.820 rows=1 width=28) (actual time=89,904.109..89,904.110 rows=3 loops=1)

  • Sort Key: ((golf(((seven2.two_tango / 900000))::double precision) * 'delta'::double precision))
  • Sort Method: quicksort Memory: 25kB
6. 6.265 89,905.202 ↓ 3.0 3 1

Gather (cost=1,000.000..5,831,347.810 rows=1 width=28) (actual time=54,588.516..89,905.202 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 89,898.937 89,898.937 ↑ 1.0 1 3 / 3

Parallel Seq Scan on yankee alpha_lima (cost=0.000..5,830,347.710 rows=1 width=28) (actual time=78,127.108..89,898.937 rows=1 loops=3)

  • Filter: ((two_tango >= 'mike'::bigint) AND (two_tango < 'charlie'::bigint) AND (foxtrot = 192) AND (zulu = 75) AND (bravo = 0)) kilo whiskey india two_seven: 109,747,698