|QUERY PLAN                                                                                                                                                                       |
|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|Unique  (cost=5942.91..6241.39 rows=2341 width=23) (actual time=36.815..39.882 rows=87 loops=1)                                                                                  |
|  ->  Gather Merge  (cost=5942.91..6229.68 rows=2341 width=23) (actual time=36.814..39.870 rows=87 loops=1)                                                                      |
|        Workers Planned: 1                                                                                                                                                       |
|        Workers Launched: 1                                                                                                                                                      |
|        ->  Unique  (cost=4942.90..4960.45 rows=2341 width=23) (actual time=18.537..20.019 rows=44 loops=2)                                                                      |
|              ->  Sort  (cost=4942.90..4948.75 rows=2341 width=23) (actual time=18.535..19.107 rows=13650 loops=2)                                                               |
|                    Sort Key: t.shortdescription, sd.division                                                                                                                    |
|                    Sort Method: quicksort  Memory: 1913kB                                                                                                                       |
|                    Worker 0:  Sort Method: quicksort  Memory: 25kB                                                                                                              |
|                    ->  Merge Join  (cost=4710.76..4753.63 rows=2341 width=23) (actual time=10.545..12.695 rows=13650 loops=2)                                                   |
|                          Merge Cond: (mv_asc_document_job_refjob.ref_job = sd.job)                                                                                              |
|                          ->  Sort  (cost=4257.59..4261.70 rows=1644 width=8) (actual time=8.188..8.251 rows=1362 loops=2)                                                       |
|                                Sort Key: mv_asc_document_job_refjob.ref_job                                                                                                     |
|                                Sort Method: quicksort  Memory: 97kB                                                                                                             |
|                                Worker 0:  Sort Method: quicksort  Memory: 25kB                                                                                                  |
|                                ->  Parallel Seq Scan on mv_asc_document_job_refjob  (cost=0.00..4169.78 rows=1644 width=8) (actual time=0.523..8.044 rows=1362 loops=2)         |
|                                      Filter: (docconcept_id = 539)                                                                                                              |
|                                      Rows Removed by Filter: 101371                                                                                                             |
|                          ->  Sort  (cost=453.00..453.95 rows=382 width=31) (actual time=4.694..5.827 rows=28078 loops=1)                                                        |
|                                Sort Key: sd.job                                                                                                                                 |
|                                Sort Method: quicksort  Memory: 226kB                                                                                                            |
|                                ->  Hash Join  (cost=215.20..436.62 rows=382 width=31) (actual time=1.455..4.317 rows=2600 loops=1)                                              |
|                                      Hash Cond: (sd.division = t.division)                                                                                                      |
|                                      ->  Hash Join  (cost=194.03..332.68 rows=5735 width=2066) (actual time=1.156..3.456 rows=5735 loops=1)                                     |
|                                            Hash Cond: (sd.job = mv_asc_job.job)                                                                                                 |
|                                            ->  Hash Join  (cost=175.32..298.75 rows=5735 width=16) (actual time=1.010..2.475 rows=5735 loops=1)                                 |
|                                                  Hash Cond: (sd.staff = st.staff)                                                                                               |
|                                                  ->  Seq Scan on staffdivision sd  (cost=0.00..108.35 rows=5735 width=24) (actual time=0.016..0.563 rows=5735 loops=1)          |
|                                                  ->  Hash  (cost=135.70..135.70 rows=3170 width=16) (actual time=0.977..0.978 rows=3170 loops=1)                                |
|                                                        Buckets: 4096  Batches: 1  Memory Usage: 159kB                                                                           |
|                                                        ->  Seq Scan on staff st  (cost=0.00..135.70 rows=3170 width=16) (actual time=0.014..0.665 rows=3170 loops=1)            |
|                                            ->  Hash  (cost=13.87..13.87 rows=387 width=8) (actual time=0.130..0.130 rows=387 loops=1)                                           |
|                                                  Buckets: 1024  Batches: 1  Memory Usage: 24kB                                                                                  |
|                                                  ->  Seq Scan on mv_asc_job  (cost=0.00..13.87 rows=387 width=8) (actual time=0.023..0.088 rows=387 loops=1)                    |
|                                      ->  Hash  (cost=20.94..20.94 rows=18 width=31) (actual time=0.280..0.284 rows=119 loops=1)                                                 |
|                                            Buckets: 1024  Batches: 1  Memory Usage: 16kB                                                                                        |
|                                            ->  Nested Loop  (cost=1.35..20.94 rows=18 width=31) (actual time=0.078..0.257 rows=119 loops=1)                                     |
|                                                  ->  Hash Join  (cost=1.20..16.73 rows=18 width=8) (actual time=0.061..0.139 rows=119 loops=1)                                  |
|                                                        Hash Cond: (d.registry = t_1.registry)                                                                                   |
|                                                        ->  Seq Scan on division d  (cost=0.00..14.64 rows=264 width=16) (actual time=0.017..0.064 rows=264 loops=1)             |
|                                                        ->  Hash  (cost=1.19..1.19 rows=1 width=8) (actual time=0.028..0.029 rows=6 loops=1)                                     |
|                                                              Buckets: 1024  Batches: 1  Memory Usage: 9kB                                                                       |
|                                                              ->  Seq Scan on branch_registry t_1  (cost=0.00..1.19 rows=1 width=8) (actual time=0.021..0.022 rows=6 loops=1)    |
|                                                                    Filter: (branch_id = 1)                                                                                      |
|                                                                    Rows Removed by Filter: 9                                                                                    |
|                                                  ->  Index Scan using division_pkey on division t  (cost=0.15..0.23 rows=1 width=23) (actual time=0.001..0.001 rows=1 loops=119)|
|                                                        Index Cond: (division = d.division)                                                                                      |
|Planning Time: 1.362 ms                                                                                                                                                          |
|Execution Time: 40.248 ms                                                                                                                                                        |