explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MCSj : prod_prije_prod_spor_cest_upit_3

Settings
# exclusive inclusive rows x rows loops node
1. 0.109 3,329.601 ↑ 1.0 1 1

Aggregate (cost=658,211.99..658,212.00 rows=1 width=8) (actual time=3,329.601..3,329.601 rows=1 loops=1)

2. 324.881 3,329.492 ↑ 12,769.9 504 1

Merge Join (cost=490,983.25..642,121.97 rows=6,436,007 width=8) (actual time=3,273.062..3,329.492 rows=504 loops=1)

  • Merge Cond: (((a.logicalunitident)::numeric) = ((c.id)::numeric))
3. 0.091 54.938 ↑ 1.0 504 1

Sort (cost=20,484.84..20,486.11 rows=509 width=7) (actual time=54.909..54.938 rows=504 loops=1)

  • Sort Key: ((a.logicalunitident)::numeric)
  • Sort Method: quicksort Memory: 48kB
4. 5.092 54.847 ↑ 1.0 504 1

Gather (cost=1,000.42..20,461.96 rows=509 width=7) (actual time=53.553..54.847 rows=504 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
5. 0.103 49.755 ↑ 1.3 126 4 / 4

Nested Loop (cost=0.42..19,411.06 rows=164 width=7) (actual time=48.651..49.755 rows=126 loops=4)

6. 49.022 49.022 ↑ 1.3 126 4 / 4

Parallel Seq Scan on xlaordertracking b (cost=0.00..18,215.06 rows=164 width=8) (actual time=48.599..49.022 rows=126 loops=4)

  • Filter: ((status)::text = 'Pending'::text)
  • Rows Removed by Filter: 235,100
7. 0.630 0.630 ↑ 1.0 1 504 / 4

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

  • Index Cond: (id = b.xlaorder_id)
  • Filter: ((logicalunit_code)::text = 'SRSERVICEREQUEST'::text)
8. 190.946 2,949.673 ↑ 1.0 2,437,122 1

Materialize (cost=470,498.41..483,142.82 rows=2,528,883 width=8) (actual time=2,251.913..2,949.673 rows=2,437,122 loops=1)

9. 1,862.141 2,758.727 ↑ 1.0 2,437,053 1

Sort (cost=470,498.41..476,820.62 rows=2,528,883 width=8) (actual time=2,251.911..2,758.727 rows=2,437,053 loops=1)

  • Sort Key: ((c.id)::numeric)
  • Sort Method: external merge Disk: 59,704kB
10. 896.586 896.586 ↑ 1.0 2,437,107 1

Seq Scan on srservicerequest c (cost=0.00..132,397.83 rows=2,528,883 width=8) (actual time=0.015..896.586 rows=2,437,107 loops=1)

Planning time : 0.741 ms
Execution time : 3,342.696 ms