explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8ghC

Settings
# exclusive inclusive rows x rows loops node
1. 5.704 69.709 ↓ 2.0 224 1

Hash Join (cost=39,092.14..64,361.68 rows=111 width=155) (actual time=59.615..69.709 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=32265
2. 5.499 6.977 ↓ 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=1.770..6.977 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. 1.478 1.478 ↓ 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=1.478..1.478 rows=23,048 loops=1)

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

Hash (cost=38,532.28..38,532.28 rows=5,086 width=4) (actual time=57.028..57.028 rows=31,462 loops=1)

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

Index Scan using beginning_date_by_mws on public.inbound_shipments inbound_shipments_1 (cost=0.42..38,532.28 rows=5,086 width=4) (actual time=0.015..50.060 rows=31,462 loops=1)

  • Output: inbound_shipments_1.id
  • Index Cond: ((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))
  • Buffers: shared hit=29917
Planning time : 0.282 ms
Execution time : 69.763 ms