explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 091U

Settings
# exclusive inclusive rows x rows loops node
1. 10.934 1,057.561 ↓ 2.4 263 1

Hash Join (cost=25,958.75..96,246.03 rows=111 width=4) (actual time=464.838..1,057.561 rows=263 loops=1)

  • Output: inbound_shipments.id
  • Hash Cond: (inbound_shipments_1.id = inbound_shipments.id)
  • Buffers: shared hit=18419 read=8423
2. 1,027.297 1,027.297 ↓ 6.8 34,408 1

Seq Scan on public.inbound_shipments inbound_shipments_1 (cost=0.00..70,267.10 rows=5,086 width=4) (actual time=19.858..1,027.297 rows=34,408 loops=1)

  • Output: inbound_shipments_1.id, inbound_shipments_1.shipment_id, inbound_shipments_1.shipment_name, inbound_shipments_1.shipment_status, inbound_shipments_1.destination_fulfillment_center_id, inbound_shipments_1.created_at, inbound_shipments_1.updated_at, inbound_shipments_1.ship_from_city, inbound_shipments_1.ship_from_country_code, inbound_shipments_1.ship_from_postal_code, inbound_shipments_1.ship_from_name, inbound_shipments_1.ship_from_address_one, inbound_shipments_1.ship_from_address_two, inbound_shipments_1.ship_from_state_or_province_code, inbound_shipments_1.shipment_last_updated, inbound_shipments_1.event_date, inbound_shipments_1.mws_credential_id
  • Filter: ((date_part('day'::text, ((COALESCE(inbound_shipments_1.event_date, inbound_shipments_1.shipment_last_updated) + '270 days'::interval) - (('now'::cstring)::date)::timestamp without time zone)) >= '0'::double precision) AND (date_part('day'::text, ((COALESCE(inbound_shipments_1.event_date, inbound_shipments_1.shipment_last_updated) + '270 days'::interval) - (('now'::cstring)::date)::timestamp without time zone)) <= '14'::double precision))
  • Rows Removed by Filter: 982772
  • Buffers: shared hit=16071 read=8423
3. 6.482 19.330 ↓ 1.0 23,048 1

Hash (cost=25,681.56..25,681.56 rows=22,175 width=4) (actual time=19.330..19.330 rows=23,048 loops=1)

  • Output: inbound_shipments.id
  • Buckets: 32768 Batches: 1 Memory Usage: 1067kB
  • Buffers: shared hit=2348
4. 9.670 12.848 ↓ 1.0 23,048 1

Bitmap Heap Scan on public.inbound_shipments (cost=496.28..25,681.56 rows=22,175 width=4) (actual time=3.740..12.848 rows=23,048 loops=1)

  • Output: inbound_shipments.id
  • Recheck Cond: (inbound_shipments.mws_credential_id = 1412)
  • Heap Blocks: exact=2267
  • Buffers: shared hit=2348
5. 3.178 3.178 ↓ 1.0 23,048 1

Bitmap Index Scan on index_inbound_shipments_on_mws_credential_id (cost=0.00..490.74 rows=22,175 width=0) (actual time=3.178..3.178 rows=23,048 loops=1)

  • Index Cond: (inbound_shipments.mws_credential_id = 1412)
  • Buffers: shared hit=81
Planning time : 0.397 ms
Execution time : 1,057.622 ms