explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ke4H

Settings
# exclusive inclusive rows x rows loops node
1. 0.519 25,577.613 ↑ 1.0 10,000 1

Limit (cost=34,675.45..34,700.45 rows=10,000 width=268) (actual time=25,575.945..25,577.613 rows=10,000 loops=1)

2. 1,707.302 25,577.094 ↑ 15.6 10,000 1

Sort (cost=34,675.45..35,066.41 rows=156,383 width=268) (actual time=25,575.939..25,577.094 rows=10,000 loops=1)

  • Sort Key: gpsdatetime
  • Sort Method: top-N heapsort Memory: 2740kB
3. 23,869.792 23,869.792 ↓ 43.1 6,746,653 1

Index Scan using gps_device_cache_pkey on gps_device_cache (cost=0.44..23,503.67 rows=156,383 width=268) (actual time=0.169..23,869.792 rows=6,746,653 loops=1)

  • Index Cond: (gps_device_cache_id > 498803810)