explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mAvAP : Optimization for: plan #4QZn

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.010 544.544 ↑ 1.0 10 1

Limit (cost=15,458.92..15,458.95 rows=10 width=30) (actual time=544.531..544.544 rows=10 loops=1)

2. 352.169 544.534 ↑ 39,940.1 10 1

Sort (cost=15,458.92..16,457.42 rows=399,401 width=30) (actual time=544.527..544.534 rows=10 loops=1)

  • Sort Key: datetime
  • Sort Method: top-N heapsort Memory: 17kB
3. 192.365 192.365 ↑ 1.0 399,401 1

Seq Scan on measurement (cost=0.00..6,828.01 rows=399,401 width=30) (actual time=0.028..192.365 rows=399,401 loops=1)

Planning time : 0.242 ms
Execution time : 544.624 ms