explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bwc

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 32,039.530 ↑ 20.0 10 1

Sort (cost=204,602.07..204,602.57 rows=200 width=28) (actual time=32,039.530..32,039.530 rows=10 loops=1)

  • Sort Key: r.ntile
  • Sort Method: quicksort Memory: 25kB
2. 16,740.410 32,039.522 ↑ 20.0 10 1

HashAggregate (cost=204,591.92..204,594.42 rows=200 width=28) (actual time=32,039.518..32,039.522 rows=10 loops=1)

  • Group Key: r.ntile
3. 10,942.333 15,299.112 ↓ 14.3 81,187,147 1

Merge Left Join (cost=6,065.24..105,454.81 rows=5,664,978 width=20) (actual time=13.152..15,299.112 rows=81,187,147 loops=1)

  • Merge Cond: (((r.ntile - 1)) = n.ntile)
4. 8.839 12.673 ↑ 1.1 30,405 1

Sort (cost=3,032.62..3,116.77 rows=33,660 width=12) (actual time=7.989..12.673 rows=30,405 loops=1)

  • Sort Key: ((r.ntile - 1))
  • Sort Method: quicksort Memory: 2194kB
5. 3.834 3.834 ↑ 1.1 30,405 1

Seq Scan on rating_ntile r (cost=0.00..501.60 rows=33,660 width=12) (actual time=0.012..3.834 rows=30,405 loops=1)

6. 4,341.736 4,344.106 ↓ 2,411.9 81,184,336 1

Sort (cost=3,032.62..3,116.77 rows=33,660 width=12) (actual time=5.161..4,344.106 rows=81,184,336 loops=1)

  • Sort Key: n.ntile
  • Sort Method: quicksort Memory: 2194kB
7. 2.370 2.370 ↑ 1.1 30,405 1

Seq Scan on rating_ntile n (cost=0.00..501.60 rows=33,660 width=12) (actual time=0.006..2.370 rows=30,405 loops=1)