explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uVi5

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 13.574 ↓ 0.0 0 1

Sort (cost=4,820.88..4,820.88 rows=1 width=83) (actual time=13.574..13.574 rows=0 loops=1)

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

Nested Loop (cost=0.42..4,820.87 rows=1 width=83) (actual time=13.570..13.570 rows=0 loops=1)

3. 13.570 13.570 ↓ 0.0 0 1

Seq Scan on trx_qm_pre_registration_queue_number preregistr1_ (cost=0.00..4,812.41 rows=1 width=8) (actual time=13.570..13.570 rows=0 loops=1)

  • Filter: (location_logical_location_id = 1)
  • Rows Removed by Filter: 176397
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))