explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5N2U

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=204,420.65..344,401.35 rows=2,472,011 width=244) (actual rows= loops=)

  • Hash Cond: ((inventory.rnsn)::text = (master.rnsn)::text)
2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=153,360.30..187,436.82 rows=2,472,011 width=67) (actual rows= loops=)

  • Hash Cond: ((sr.serial_number)::text = (inventory.serial_number)::text)
3. 0.000 0.000 ↓ 0.0

Seq Scan on ssdm_sr_header sr (cost=0.00..5,835.38 rows=108,538 width=25) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=98,319.17..98,319.17 rows=2,472,011 width=49) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on ssdm_inventory inventory (cost=0.00..98,319.17 rows=2,472,011 width=49) (actual rows= loops=)

  • Filter: ((active_end_date IS NULL) OR (CURRENT_TIMESTAMP < active_end_date))
6. 0.000 0.000 ↓ 0.0

Hash (cost=32,177.49..32,177.49 rows=886,949 width=47) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on ssdm_item_master master (cost=0.00..32,177.49 rows=886,949 width=47) (actual rows= loops=)