explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kih9

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 25.646 ↑ 1.0 7 1

Limit (cost=778.810..778.820 rows=7 width=524) (actual time=25.641..25.646 rows=7 loops=1)

2. 0.036 25.639 ↑ 20.0 7 1

Sort (cost=778.810..779.160 rows=140 width=524) (actual time=25.638..25.639 rows=7 loops=1)

  • Sort Key: (five(seven.november)) DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 0.210 25.603 ↑ 6.7 21 1

HashAggregate (cost=774.740..776.140 rows=140 width=524) (actual time=25.592..25.603 rows=21 loops=1)

  • Group Key: charlie.romeo
4. 20.199 25.393 ↑ 105.1 328 1

Hash Join (cost=13.150..602.380 rows=34,472 width=520) (actual time=0.105..25.393 rows=328 loops=1)

  • Hash Cond: (seven.november = charlie.november)
5. 5.153 5.153 ↑ 1.0 34,472 1

Seq Scan on seven (cost=0.000..498.720 rows=34,472 width=4) (actual time=0.037..5.153 rows=34,472 loops=1)

6. 0.015 0.041 ↑ 6.7 21 1

Hash (cost=11.400..11.400 rows=140 width=520) (actual time=0.041..0.041 rows=21 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
7. 0.026 0.026 ↑ 6.7 21 1

Seq Scan on charlie (cost=0.000..11.400 rows=140 width=520) (actual time=0.018..0.026 rows=21 loops=1)