explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7oFi : TPC-DS 03

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 1,987.025 ↑ 1.5 31 1

Limit (cost=79,162.340..79,162.460 rows=45 width=244) (actual time=1,986.999..1,987.025 rows=31 loops=1)

2. 0.052 1,987.004 ↑ 1.5 31 1

Sort (cost=79,162.340..79,162.460 rows=45 width=244) (actual time=1,986.998..1,987.004 rows=31 loops=1)

  • Sort Key: six_seven.uniform, (five(juliet.six_uniform)) DESC, hotel.golf
  • Sort Method: quicksort Memory: 29kB
3. 0.188 1,986.952 ↑ 1.5 31 1

GroupAggregate (cost=79,159.980..79,161.110 rows=45 width=244) (actual time=1,986.720..1,986.952 rows=31 loops=1)

  • Group Key: six_seven.uniform, hotel.foxtrot, hotel.golf
4. 0.547 1,986.764 ↓ 6.4 287 1

Sort (cost=79,159.980..79,160.090 rows=45 width=226) (actual time=1,986.694..1,986.764 rows=287 loops=1)

  • Sort Key: six_seven.uniform, hotel.foxtrot, hotel.golf
  • Sort Method: quicksort Memory: 65kB
5. 127.447 1,986.217 ↓ 6.4 287 1

Hash Join (cost=3,173.380..79,158.750 rows=45 width=226) (actual time=30.900..1,986.217 rows=287 loops=1)

  • Hash Cond: (juliet.xray = hotel.lima)
6. 981.706 1,852.062 ↓ 49.8 438,190 1

Hash Join (cost=1,881.560..77,833.470 rows=8,803 width=22) (actual time=15.072..1,852.062 rows=438,190 loops=1)

  • Hash Cond: (juliet.delta_lima = six_seven.charlie)
7. 855.405 855.405 ↓ 1.6 2,880,404 1

Seq Scan on juliet (cost=0.000..69,272.640 rows=1,757,664 width=22) (actual time=0.003..855.405 rows=2,880,404 loops=1)

8. 2.205 14.951 ↓ 31.6 6,000 1

Hash (cost=1,879.190..1,879.190 rows=190 width=8) (actual time=14.951..14.951 rows=6,000 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 299kB
9. 12.746 12.746 ↓ 31.6 6,000 1

Seq Scan on bravo six_seven (cost=0.000..1,879.190 rows=190 width=8) (actual time=0.055..12.746 rows=6,000 loops=1)

  • Filter: (delta_hotel = 11)
  • Rows Removed by Filter: 67049
10. 0.015 6.708 ↑ 2.3 11 1

Hash (cost=1,291.500..1,291.500 rows=25 width=212) (actual time=6.707..6.708 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 6.693 6.693 ↑ 2.3 11 1

Seq Scan on hotel (cost=0.000..1,291.500 rows=25 width=212) (actual time=0.075..6.693 rows=11 loops=1)

  • Filter: (four = 816)
  • Rows Removed by Filter: 17989