explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JeUg

Settings
# exclusive inclusive rows x rows loops node
1. 0.316 11.966 ↑ 4.0 995 1

Sort (cost=6,844.9..6,854.76 rows=3,943 width=104) (actual time=11.907..11.966 rows=995 loops=1)

  • Sort Key: shipment_order_line_state."timestamp"
  • Sort Method: quicksort Memory: 164kB
  • Buffers: shared hit=1244
2. 6.910 11.650 ↑ 4.0 995 1

Aggregate (cost=6,569.98..6,609.41 rows=3,943 width=104) (actual time=11.303..11.65 rows=995 loops=1)

  • Buffers: shared hit=1244
3. 2.874 4.740 ↓ 1.2 14,925 1

Bitmap Heap Scan on shipment_order_line_state shipment_order_line_state (cost=392.18..6,172.96 rows=12,216 width=56) (actual time=1.979..4.74 rows=14,925 loops=1)

  • Buffers: shared hit=1244
4. 1.866 1.866 ↓ 1.2 14,925 1

Bitmap Index Scan on warehouse_departure_deadline_idx (cost=0..389.12 rows=12,216 width=0) (actual time=1.866..1.866 rows=14,925 loops=1)

  • Index Cond: ((shipment_order_line_state.warehouse = 'FC1'::text) AND (shipment_order_line_state.departure_deadline >= '2019-08-11 22:00:00+00'::timestamp with time zone) AND (shipment_order_line_state.departure_deadline <= '2019-08-12 22:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=71