explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 42UR

Settings
# exclusive inclusive rows x rows loops node
1. 529.565 530.104 ↑ 90,909.1 11 1

Function Scan on generate_series i (cost=8.32..49,613.32 rows=1,000,000 width=8) (actual time=56.787..530.104 rows=11 loops=1)

2.          

Initplan (for Function Scan)

3. 0.021 0.021 ↑ 1.0 1 1

Index Scan using ews_mrp_job_orders_job_name_uniq on ews_mrp_job_orders (cost=0.28..8.30 rows=1 width=8) (actual time=0.020..0.021 rows=1 loops=1)

  • Index Cond: ((name)::text = '1455'::text)
4. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

5.          

SubPlan (for Function Scan)

6. 0.066 0.066 ↑ 1.0 1 11

Result (cost=0.00..0.02 rows=1 width=0) (actual time=0.005..0.006 rows=1 loops=11)

7. 0.066 0.066 ↑ 1.0 1 11

Result (cost=0.00..0.03 rows=1 width=0) (actual time=0.005..0.006 rows=1 loops=11)

8. 0.055 0.055 ↑ 1.0 1 11

Result (cost=0.00..0.02 rows=1 width=0) (actual time=0.005..0.005 rows=1 loops=11)

9. 0.044 0.044 ↑ 1.0 1 11

Result (cost=0.00..0.03 rows=1 width=0) (actual time=0.004..0.004 rows=1 loops=11)

10. 0.146 0.286 ↓ 0.0 0 22

Seq Scan on inventory_manufacturing_overhead (cost=0.04..44.01 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=22)

  • Filter: ((weld_location_id = 5,628) AND ((year)::double precision = $5) AND ((month)::double precision = $6))
  • Rows Removed by Filter: 2
11.          

Initplan (for Seq Scan)

12. 0.110 0.110 ↑ 1.0 1 22

Result (cost=0.00..0.02 rows=1 width=0) (actual time=0.004..0.005 rows=1 loops=22)

13. 0.030 0.030 ↑ 1.0 1 10

Result (cost=0.00..0.02 rows=1 width=0) (actual time=0.002..0.003 rows=1 loops=10)

Planning time : 0.262 ms
Execution time : 530.199 ms