explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fVHG

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

Hash Join (cost=23,531.16..2,935,184.57 rows=350,636 width=1,026) (actual rows= loops=)

  • Hash Cond: (os.inventory_type_id = tt.inventory_type_id)
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=23,526.37..2,921,592.64 rows=350,636 width=1,033) (actual rows= loops=)

  • Hash Cond: ((oh.network_cd)::text = (nd.include_value_cd)::text)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=23,525.07..2,917,771.91 rows=350,636 width=1,021) (actual rows= loops=)

  • Hash Cond: ((oh.division_cd)::text = (fd.include_value_cd)::text)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=23,523.84..2,915,453.98 rows=350,636 width=1,009) (actual rows= loops=)

  • Hash Cond: (oh.order_status_id = dos.order_status_id)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=23,522.71..2,910,631.61 rows=350,636 width=1,000) (actual rows= loops=)

  • Hash Cond: ((os.order_id = oh.order_id) AND (os.version_id = oh.version_id))
6. 0.000 0.000 ↓ 0.0

Seq Scan on order_spot os (cost=0.00..993,043.88 rows=19,749,288 width=329) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=15,699.10..15,699.10 rows=77,507 width=677) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on order_header oh (cost=0.00..15,699.10 rows=77,507 width=677) (actual rows= loops=)

  • Filter: ((end_date)::date >= '2015-12-28'::date)
9. 0.000 0.000 ↓ 0.0

Hash (cost=1.06..1.06 rows=6 width=11) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on order_status dos (cost=0.00..1.06 rows=6 width=11) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=1.18..1.18 rows=4 width=17) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on filters_for_reveal fd (cost=0.00..1.18 rows=4 width=17) (actual rows= loops=)

  • Filter: ((value_type)::text = 'division'::text)
13. 0.000 0.000 ↓ 0.0

Hash (cost=1.18..1.18 rows=10 width=17) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on filters_for_reveal nd (cost=0.00..1.18 rows=10 width=17) (actual rows= loops=)

  • Filter: ((value_type)::text = 'network'::text)
15. 0.000 0.000 ↓ 0.0

Hash (cost=3.24..3.24 rows=124 width=17) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on traffic_inventory_type tt (cost=0.00..3.24 rows=124 width=17) (actual rows= loops=)