explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EFVo

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 421.928 ↑ 166.7 12 1

Sort (cost=130.16..135.16 rows=2,000 width=160) (actual time=421.925..421.928 rows=12 loops=1)

  • Sort Key: get_within_intervals_for_store_webshop_zip_code.dropoff_time_earliest, get_within_intervals_for_store_webshop_zip_code.dropoff_time_latest
  • Sort Method: quicksort Memory: 26kB
2. 0.008 421.899 ↑ 166.7 12 1

Append (cost=0.25..20.50 rows=2,000 width=160) (actual time=421.891..421.899 rows=12 loops=1)

3. 18.674 18.674 ↓ 0.0 0 1

Function Scan on get_within_intervals_for_store_webshop_zip_code (cost=0.25..10.25 rows=1,000 width=160) (actual time=18.674..18.674 rows=0 loops=1)

4. 403.217 403.217 ↑ 83.3 12 1

Function Scan on get_between_intervals_for_store_webshop_zip_code (cost=0.25..10.25 rows=1,000 width=160) (actual time=403.214..403.217 rows=12 loops=1)

Planning time : 0.129 ms
Execution time : 422.035 ms