explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vl1

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 5,100.007 ↓ 0.0 0 1

Limit (cost=1,289,595.80..1,289,595.97 rows=69 width=334) (actual time=5,100.007..5,100.007 rows=0 loops=1)

2. 0.006 5,100.006 ↓ 0.0 0 1

Sort (cost=1,289,595.80..1,289,595.97 rows=69 width=334) (actual time=5,100.006..5,100.006 rows=0 loops=1)

  • Sort Key: creationdate
  • Sort Method: quicksort Memory: 25kB
3. 5,100.000 5,100.000 ↓ 0.0 0 1

Seq Scan on altc_event (cost=0.00..1,289,593.69 rows=69 width=334) (actual time=5,100.000..5,100.000 rows=0 loops=1)

Planning time : 0.102 ms
Execution time : 5,100.043 ms