explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uv1C

Settings
# exclusive inclusive rows x rows loops node
1. 4,534.678 5,248.802 ↑ 1.7 3 1

Gather (cost=1,004.12..95,054.71 rows=5 width=113) (actual time=637.022..5,248.802 rows=3 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 0.004 714.043 ↑ 1.0 1 5 / 5

Nested Loop Left Join (cost=4.12..94,049.01 rows=1 width=81) (actual time=127.237..714.043 rows=1 loops=5)

3. 303.023 714.035 ↑ 1.0 1 5 / 5

Hash Join (cost=4.09..94,048.98 rows=1 width=49) (actual time=127.232..714.035 rows=1 loops=5)

  • Hash Cond: ((arinvdet.ap_partime)::text = (apinvdet.""timestamp"")::text)
4. 411.008 411.008 ↑ 1.2 304,547 5 / 5

Parallel Seq Scan on arinvdet (cost=0.00..93,847.05 rows=376,822 width=40) (actual time=0.002..411.008 rows=304,547 loops=5)

  • Filter: ((inven IS NOT NULL) AND ((inven)::text <> ALL ('{LABOR,OVERHEAD}'::text[])))
  • Rows Removed by Filter: 33222
5. 0.001 0.004 ↑ 1.0 1 1 / 5

Hash (cost=4.09..4.09 rows=1 width=27) (actual time=0.018..0.019 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.003 0.003 ↑ 1.0 1 1 / 5

Index Scan using apinvdet_pkey on apinvdet (cost=0.08..4.09 rows=1 width=27) (actual time=0.015..0.016 rows=1 loops=1)

  • Index Cond: ((autoid)::text = '2J2ELP9VUS4E2EB1'::text)
7. 0.004 0.004 ↓ 0.0 0 3 / 5

Index Scan using uc_componentautoid on item_components (cost=0.03..0.03 rows=1 width=64) (actual time=0.006..0.006 rows=0 loops=3)

  • Index Cond: ((arinvdet.autoid)::text = (component_autoid)::text)
8.          

SubPlan (for Gather)

9. 0.009 0.081 ↓ 0.0 0 3

Unique (cost=1.04..1.04 rows=3 width=32) (actual time=0.026..0.027 rows=0 loops=3)

10. 0.030 0.072 ↓ 0.0 0 3

Sort (cost=1.04..1.04 rows=3 width=32) (actual time=0.024..0.024 rows=0 loops=3)

  • Sort Key: vw_upstreams_only.upstream_id
  • Sort Method: quicksort Memory: 25kB
11. 0.006 0.042 ↓ 0.0 0 3

Append (cost=0.00..1.03 rows=3 width=32) (actual time=0.014..0.014 rows=0 loops=3)

12. 0.003 0.015 ↓ 0.0 0 3

Subquery Scan on vw_upstreams_only (cost=0.00..0.01 rows=2 width=32) (actual time=0.005..0.005 rows=0 loops=3)

13. 0.003 0.012 ↓ 0.0 0 3

Append (cost=0.00..0.01 rows=2 width=129) (actual time=0.004..0.004 rows=0 loops=3)

14. 0.003 0.003 ↓ 0.0 0 3

Result (cost=0.00..0.00 rows=0 width=86) (actual time=0.001..0.001 rows=0 loops=3)

  • One-Time Filter: false
15. 0.000 0.006 ↓ 0.0 0 3

Subquery Scan on "*SELECT* 2_1" (cost=0.00..0.01 rows=1 width=114) (actual time=0.002..0.002 rows=0 loops=3)

16. 0.005 0.006 ↓ 0.0 0 3

HashAggregate (cost=0.00..0.00 rows=1 width=126) (actual time=0.002..0.002 rows=0 loops=3)

  • Group Key: autoid, id
17. 0.001 0.001 ↓ 0.0 0 1

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

  • One-Time Filter: false
18. 0.006 0.021 ↓ 0.0 0 3

Subquery Scan on "*SELECT* 2" (cost=0.00..1.01 rows=1 width=32) (actual time=0.007..0.007 rows=0 loops=3)

19. 0.015 0.015 ↓ 0.0 0 3

Seq Scan on component_links (cost=0.00..1.01 rows=1 width=6) (actual time=0.004..0.005 rows=0 loops=3)

  • Filter: ((component_autoid)::text = (arinvdet.autoid)::text)
  • Rows Removed by Filter: 3
Planning time : 3.726 ms
Execution time : 5,248.938 ms