explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J2Op

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 0.118 ↓ 11.0 11 1

Sort (cost=8.47..8.48 rows=1 width=168) (actual time=0.118..0.118 rows=11 loops=1)

  • Sort Key: elapse_time
  • Sort Method: quicksort Memory: 27kB
2. 0.079 0.079 ↓ 11.0 11 1

Index Scan using mv_dispatch_schedule_carrier_code_schedule_number_schedule__idx on mv_dispatch_schedule (cost=0.43..8.46 rows=1 width=168) (actual time=0.040..0.079 rows=11 loops=1)

  • Index Cond: (((carrier_code)::text = 'GLC'::text) AND ((schedule_number)::text = '5502'::text) AND (schedule_date = '2020-03-16'::date))
  • Filter: ((effective_date <= '2020-03-16'::date) AND ((expiration_date IS NULL) OR (expiration_date > '2020-03-16'::date)) AND (catalog_date <= '2020-03-16'::date) AND ((inactive_date IS NULL) OR (inactive_date > '2020-03-16'::date)))
  • Rows Removed by Filter: 11
Planning time : 0.287 ms
Execution time : 0.239 ms