explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D5cA : Optimization for: prod_poslije_prod_4; plan #Rc8F-stavljen_wrok_mem_256m

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.079 1,310.321 ↑ 1.0 1 1

Aggregate (cost=547,273.94..547,273.95 rows=1 width=8) (actual time=1,310.320..1,310.321 rows=1 loops=1)

2. 281.343 1,310.242 ↑ 13,954.7 448 1

Merge Join (cost=390,974.50..531,644.64 rows=6,251,722 width=8) (actual time=1,259.770..1,310.242 rows=448 loops=1)

  • Merge Cond: (((a.logicalunitident)::numeric) = ((c.id)::numeric))
3. 0.066 47.724 ↑ 1.1 448 1

Sort (cost=20,566.72..20,567.99 rows=511 width=7) (actual time=47.700..47.724 rows=448 loops=1)

  • Sort Key: ((a.logicalunitident)::numeric)
  • Sort Method: quicksort Memory: 46kB
4. 4.382 47.658 ↑ 1.1 448 1

Gather (cost=1,000.42..20,543.73 rows=511 width=7) (actual time=46.535..47.658 rows=448 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
5. 0.011 43.276 ↑ 1.5 112 4 / 4

Nested Loop (cost=0.42..19,492.63 rows=165 width=7) (actual time=42.393..43.276 rows=112 loops=4)

6. 42.705 42.705 ↑ 1.5 112 4 / 4

Parallel Seq Scan on xlaordertracking b (cost=0.00..18,288.60 rows=165 width=8) (actual time=42.343..42.705 rows=112 loops=4)

  • Filter: ((status)::text = 'Pending'::text)
  • Rows Removed by Filter: 235,624
7. 0.560 0.560 ↑ 1.0 1 448 / 4

Index Scan using xlaorder_pkey on xlaorder a (cost=0.42..7.30 rows=1 width=15) (actual time=0.005..0.005 rows=1 loops=448)

  • Index Cond: (id = b.xlaorder_id)
  • Filter: ((logicalunit_code)::text = 'SRSERVICEREQUEST'::text)
8. 460.310 981.175 ↑ 1.0 2,441,844 1

Sort (cost=370,407.79..376,524.93 rows=2,446,858 width=8) (actual time=889.042..981.175 rows=2,441,844 loops=1)

  • Sort Key: ((c.id)::numeric)
  • Sort Method: quicksort Memory: 201,840kB
9. 520.865 520.865 ↑ 1.0 2,441,777 1

Index Only Scan using srservicerequest_pkey on srservicerequest c (cost=0.43..110,765.58 rows=2,446,858 width=8) (actual time=0.015..520.865 rows=2,441,777 loops=1)

  • Heap Fetches: 116,936
Planning time : 0.300 ms
Execution time : 1,332.914 ms