explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zfR

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

"Sort (cost=1,243.98..1,243.99 rows=1 width=1,759) (actual rows= loops=)

  • Sort Key: job_number DESC
2. 0.000 0.000 ↓ 0.0

Index Scan using idx_lab_job_lab_id on lab_job elabjob0_ (cost=0.42..1,243.97 rows=1 width=1,759) (actual rows= loops=)

  • Index Cond: (lab_id = '291d0ce9-b34d-4c5b-b047-1fc4f55b19b0'::uuid)
  • Filter: (((current_state)::text <> 'ACCEPTED'::text) AND (upper((tracking_number)::text) = 'wrwe'::text))