explain.depesz.com

PostgreSQL's explain analyze made readable

Result: byvV

Settings
# exclusive inclusive rows x rows loops node
1. 4.666 267.493 ↓ 2.0 224 1

Hash Join (cost=40,311.56..65,581.10 rows=111 width=155) (actual time=258.777..267.493 rows=224 loops=1)

  • Output: inbound_shipments.id, inbound_shipments.shipment_id, inbound_shipments.shipment_name, inbound_shipments.shipment_status, inbound_shipments.destination_fulfillment_center_id, inbound_shipments.created_at, inbound_shipments.updated_at, inbound_shipments.ship_from_city, inbound_shipments.ship_from_country_code, inbound_shipments.ship_from_postal_code, inbound_shipments.ship_from_name, inbound_shipments.ship_from_address_one, inbound_shipments.ship_from_address_two, inbound_shipments.ship_from_state_or_province_code, inbound_shipments.shipment_last_updated, inbound_shipments.event_date, inbound_shipments.mws_credential_id
  • Hash Cond: (inbound_shipments.id = inbound_shipments_1.id)
  • Buffers: shared hit=12561 read=14281
2. 5.440 9.378 ↓ 1.0 23,048 1

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

  • Output: inbound_shipments.id, inbound_shipments.shipment_id, inbound_shipments.shipment_name, inbound_shipments.shipment_status, inbound_shipments.destination_fulfillment_center_id, inbound_shipments.created_at, inbound_shipments.updated_at, inbound_shipments.ship_from_city, inbound_shipments.ship_from_country_code, inbound_shipments.ship_from_postal_code, inbound_shipments.ship_from_name, inbound_shipments.ship_from_address_one, inbound_shipments.ship_from_address_two, inbound_shipments.ship_from_state_or_province_code, inbound_shipments.shipment_last_updated, inbound_shipments.event_date, inbound_shipments.mws_credential_id
  • Recheck Cond: (inbound_shipments.mws_credential_id = 1412)
  • Heap Blocks: exact=2267
  • Buffers: shared hit=2348
3. 3.938 3.938 ↓ 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.938..3.938 rows=23,048 loops=1)

  • Index Cond: (inbound_shipments.mws_credential_id = 1412)
  • Buffers: shared hit=81
4. 7.912 253.449 ↓ 6.2 31,462 1

Hash (cost=39,751.70..39,751.70 rows=5,086 width=4) (actual time=253.449..253.449 rows=31,462 loops=1)

  • Output: inbound_shipments_1.id
  • Buckets: 32768 (originally 8192) Batches: 1 (originally 1) Memory Usage: 1363kB
  • Buffers: shared hit=10213 read=14281
5. 245.537 245.537 ↓ 6.2 31,462 1

Seq Scan on public.inbound_shipments inbound_shipments_1 (cost=0.00..39,751.70 rows=5,086 width=4) (actual time=6.435..245.537 rows=31,462 loops=1)

  • Output: inbound_shipments_1.id
  • Filter: ((COALESCE(inbound_shipments_1.event_date, inbound_shipments_1.shipment_last_updated) > '2018-12-10 03:55:30.322703'::timestamp without time zone) AND (COALESCE(inbound_shipments_1.event_date, inbound_shipments_1.shipment_last_updated) < '2018-12-24 03:55:30.323637'::timestamp without time zone))
  • Rows Removed by Filter: 985718
  • Buffers: shared hit=10213 read=14281
Planning time : 0.795 ms
Execution time : 267.565 ms