explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u8Di

Settings
# exclusive inclusive rows x rows loops node
1. 119.149 383.491 ↓ 2.4 17,840 1

Hash Join (cost=25,958.75..64,512.89 rows=7,392 width=4) (actual time=72.639..383.491 rows=17,840 loops=1)

  • Output: inbound_shipments.id
  • Hash Cond: (inbound_shipments_1.id = inbound_shipments.id)
  • Buffers: shared hit=12913 read=13929
2. 248.100 248.100 ↓ 1.6 545,456 1

Seq Scan on public.inbound_shipments inbound_shipments_1 (cost=0.00..37,208.75 rows=339,060 width=4) (actual time=1.676..248.100 rows=545,456 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: (COALESCE(inbound_shipments_1.event_date, inbound_shipments_1.shipment_last_updated) > '2018-12-10 04:15:56.216149'::timestamp without time zone)
  • Rows Removed by Filter: 471724
  • Buffers: shared hit=10565 read=13929
3. 5.577 16.242 ↓ 1.0 23,048 1

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

  • Output: inbound_shipments.id
  • Buckets: 32768 Batches: 1 Memory Usage: 1067kB
  • Buffers: shared hit=2348
4. 8.515 10.665 ↓ 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=2.541..10.665 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. 2.150 2.150 ↓ 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=2.150..2.150 rows=23,048 loops=1)

  • Index Cond: (inbound_shipments.mws_credential_id = 1412)
  • Buffers: shared hit=81
Planning time : 0.568 ms
Execution time : 384.399 ms