explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rc8F : prod_poslije_prod_4

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.103 2,971.208 ↑ 1.0 1 1

Aggregate (cost=620,297.55..620,297.56 rows=1 width=8) (actual time=2,971.208..2,971.208 rows=1 loops=1)

2. 345.090 2,971.105 ↑ 14,144.2 442 1

Merge Join (cost=457,880.97..604,668.24 rows=6,251,722 width=8) (actual time=2,875.555..2,971.105 rows=442 loops=1)

  • Merge Cond: (((a.logicalunitident)::numeric) = ((c.id)::numeric))
3. 0.123 55.125 ↑ 1.2 442 1

Sort (cost=20,564.18..20,565.46 rows=511 width=7) (actual time=55.098..55.125 rows=442 loops=1)

  • Sort Key: ((a.logicalunitident)::numeric)
  • Sort Method: quicksort Memory: 45kB
4. 4.998 55.002 ↑ 1.2 442 1

Gather (cost=1,000.42..20,541.19 rows=511 width=7) (actual time=53.747..55.002 rows=442 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
5. 0.089 50.004 ↑ 1.5 110 4 / 4

Nested Loop (cost=0.42..19,490.09 rows=165 width=7) (actual time=48.979..50.004 rows=110 loops=4)

6. 49.362 49.362 ↑ 1.5 110 4 / 4

Parallel Seq Scan on xlaordertracking b (cost=0.00..18,286.06 rows=165 width=8) (actual time=48.926..49.362 rows=110 loops=4)

  • Filter: ((status)::text = 'Pending'::text)
  • Rows Removed by Filter: 235,599
7. 0.552 0.552 ↑ 1.0 1 442 / 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=442)

  • Index Cond: (id = b.xlaorder_id)
  • Filter: ((logicalunit_code)::text = 'SRSERVICEREQUEST'::text)
8. 194.347 2,570.890 ↑ 1.0 2,441,687 1

Materialize (cost=437,316.79..449,551.08 rows=2,446,858 width=8) (actual time=2,182.604..2,570.890 rows=2,441,687 loops=1)

9. 1,662.740 2,376.543 ↑ 1.0 2,441,610 1

Sort (cost=437,316.79..443,433.93 rows=2,446,858 width=8) (actual time=2,182.601..2,376.543 rows=2,441,610 loops=1)

  • Sort Key: ((c.id)::numeric)
  • Sort Method: external sort Disk: 59,712kB
10. 713.803 713.803 ↑ 1.0 2,441,613 1

Index Only Scan using srservicerequest_pkey on srservicerequest c (cost=0.43..110,761.58 rows=2,446,858 width=8) (actual time=0.036..713.803 rows=2,441,613 loops=1)

  • Heap Fetches: 110,362
Planning time : 0.373 ms
Execution time : 2,984.263 ms