VOOZH about

URL: https://explain.depesz.com/s/pIzU

⇱ pIzU | explain.depesz.com

Result: pIzU

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.074 451.249 ↓ 0.0 0 1
→

Sort (cost=48,984.88..48,984.88 rows=2 width=39) (actual time=451.249..451.249 rows=0 loops=1)

  • Sort Key: nsdl_error_response.cfms_frn
  • Sort Method: quicksort Memory: 25kB
2. 14.810 451.175 ↓ 0.0 0 1
→

Gather (cost=2,180.43..48,984.87 rows=2 width=39) (actual time=451.175..451.175 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 1.438 436.365 ↓ 0.0 0 5
/ 5
→

Hash Semi Join (cost=1,180.43..47,984.67 rows=0 width=39) (actual time=436.365..436.365 rows=0 loops=5)

  • Hash Cond: ((nsdl_error_response.cfms_frn)::text = (nsdl_file_hdr.frn)::text)
4. 410.641 410.641 ↓ 1.9 25,840
- 1,344,440 		5
/ 5
→

Parallel Seq Scan on nsdl_error_response (cost=0.00..46,797.23 rows=2,670 width=39) (actual time=0.107..410.641 rows=5,168 loops=5)

  • Filter: (((line_no)::text <> '-'::text) AND ((invalidate_flag)::text = 'N'::text) AND ((err_or_warn)::text = 'Error'::text))
  • Rows Removed by Filter: 268,888
5. 0.010 24.286 ↑ 1.0 5 5
/ 5
→

Hash (cost=1,180.42..1,180.42 rows=1 width=22) (actual time=24.286..24.286 rows=1 loops=5)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
6. 24.276 24.276 ↑ 1.0 5
- 114,390 		5
/ 5
→

Seq Scan on nsdl_file_hdr (cost=0.00..1,180.42 rows=1 width=22) (actual time=1.013..24.276 rows=1 loops=5)

  • Filter: (((treasury_code)::text = 'PTC'::text) AND (trunc(start_date) = '2021-03-01 00:00:00'::timestamp without time zone) AND (trunc(end_date) = '2021-03-31 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 22,878
Planning time : 0.943 ms
Execution time : 472.616 ms 
Sort (cost=48984.88..48984.88 rows=2 width=39) (actual time=451.249..451.249 rows=0 loops=1)
 Sort Key: nsdl_error_response.cfms_frn
 Sort Method: quicksort Memory: 25kB
 -> Gather (cost=2180.43..48984.87 rows=2 width=39) (actual time=451.175..451.175 rows=0 loops=1)
 Workers Planned: 4
 Workers Launched: 4
 -> Hash Semi Join (cost=1180.43..47984.67 rows=0 width=39) (actual time=436.365..436.365 rows=0 loops=5)
 Hash Cond: ((nsdl_error_response.cfms_frn)::text = (nsdl_file_hdr.frn)::text)
 -> Parallel Seq Scan on nsdl_error_response (cost=0.00..46797.23 rows=2670 width=39) (actual time=0.107..410.641 rows=5168 loops=5)
 Filter: (((line_no)::text <> '-'::text) AND ((invalidate_flag)::text = 'N'::text) AND ((err_or_warn)::text = 'Error'::text))
 Rows Removed by Filter: 268888
 -> Hash (cost=1180.42..1180.42 rows=1 width=22) (actual time=24.286..24.286 rows=1 loops=5)
 Buckets: 1024 Batches: 1 Memory Usage: 9kB
 -> Seq Scan on nsdl_file_hdr (cost=0.00..1180.42 rows=1 width=22) (actual time=1.013..24.276 rows=1 loops=5)
 Filter: (((treasury_code)::text = 'PTC'::text) AND (trunc(start_date) = '2021-03-01 00:00:00'::timestamp without time zone) AND (trunc(end_date) = '2021-03-31 00:00:00'::timestamp without time zone))
 Rows Removed by Filter: 22878
Planning time: 0.943 ms
Execution time: 472.616 ms

Per node type stats

node typecountsum of times% of query
Gather 1 14.810 ms 3.3 %
Hash 1 0.010 ms 0.0 %
Hash Semi Join 1 1.438 ms 0.3 %
Parallel Seq Scan 1 410.641 ms 91.0 %
Seq Scan 1 24.276 ms 5.4 %
Sort 1 0.074 ms 0.0 %

Per table stats

Table nameScan countTotal time% of query
scan typecountsum of times% of table
nsdl_error_response 1 410.641 ms 91.0 %
Parallel Seq Scan 1 410.641 ms 100.0 %
nsdl_file_hdr 1 24.276 ms 5.4 %
Seq Scan 1 24.276 ms 100.0 %