explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H9wt : Optimization for: plan #uVi5

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 0.444 ↓ 0.0 0 1

Sort (cost=13.56..13.57 rows=1 width=83) (actual time=0.444..0.444 rows=0 loops=1)

  • Sort Key: preregistr0_.called_at
  • Sort Method: quicksort Memory: 25kB
2. 0.000 0.441 ↓ 0.0 0 1

Nested Loop (cost=0.84..13.55 rows=1 width=83) (actual time=0.441..0.441 rows=0 loops=1)

3. 0.441 0.441 ↓ 0.0 0 1

Index Scan using trx_qm_pre_registration_queue_number_location_logical_location_ on trx_qm_pre_registration_queue_number preregistr1_ (cost=0.42..5.10 rows=1 width=8) (actual time=0.441..0.441 rows=0 loops=1)

  • Index Cond: (location_logical_location_id = 1)
4. 0.000 0.000 ↓ 0.0 0

Index Scan using trx_qm_pre_registration_queue_number_occurr_queue_number_id_idx on trx_qm_pre_registration_queue_number_occurrence preregistr0_ (cost=0.42..8.45 rows=1 width=83) (never executed)

  • Index Cond: (queue_number_id = preregistr1_.id)
  • Filter: ((called_at IS NOT NULL) AND (arrived_at IS NULL) AND (servicing_at IS NULL) AND (checked_out_at IS NULL) AND (queued_at >= '2019-05-14 00:00:00'::timestamp without time zone) AND (queued_at <= '2019-05-15 00:00:00'::timestamp without time zone))