explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EPZP

Settings
# exclusive inclusive rows x rows loops node
1. 0.507 55.873 ↑ 1.0 8,485 1

Limit (cost=838.53..859.74 rows=8,485 width=151) (actual time=54.468..55.873 rows=8,485 loops=1)

2. 21.435 55.366 ↑ 1.0 8,485 1

Sort (cost=838.53..859.74 rows=8,485 width=151) (actual time=54.467..55.366 rows=8,485 loops=1)

  • Sort Key: idunicoferta
  • Sort Method: quicksort Memory: 2584kB
3. 33.931 33.931 ↑ 1.0 8,485 1

Seq Scan on consumelementcomplet_2017 (cost=0.00..284.85 rows=8,485 width=151) (actual time=9.782..33.931 rows=8,485 loops=1)