explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I9wu

Settings
# exclusive inclusive rows x rows loops node
1. 16,384.120 16,384.120 ↓ 69.5 139 1

CTE Scan on report_loads (cost=19.08..19.13 rows=2 width=40) (actual time=16,383.500..16,384.120 rows=139 loops=1)

2.          

CTE report_loads

3. 0.390 16,384.023 ↓ 69.5 139 1

GroupAggregate (cost=19.02..19.08 rows=2 width=72) (actual time=16,383.492..16,384.023 rows=139 loops=1)

  • Group Key: (date_trunc('day'::text, l.pickup_date))
4. 0.784 16,383.633 ↓ 813.0 1,626 1

Sort (cost=19.02..19.02 rows=2 width=25) (actual time=16,383.456..16,383.633 rows=1,626 loops=1)

  • Sort Key: (date_trunc('day'::text, l.pickup_date))
  • Sort Method: quicksort Memory: 176kB
5. 16,382.849 16,382.849 ↓ 813.0 1,626 1

Function Scan on usp_loads l (cost=0.25..19.01 rows=2 width=25) (actual time=16,375.454..16,382.849 rows=1,626 loops=1)

  • Filter: ((pickup_date > '2019-10-09 20:00:00-04'::timestamp with time zone) AND (shipper_business_id = '1703858125129385245'::bigint) AND (status <> ALL ('{CANCELED,DRAFT,RATE_CONFIRMATION_REQUESTED}'::text[])))
  • Rows Removed by Filter: 7367
Planning time : 0.132 ms
Execution time : 16,385.888 ms