#	exclusive	inclusive	rows x	rows	loops	node
1.	32.799	6,999.307	↑ 465.6	10	1	→ Gather (cost=1,000.00..5,931,342.42 rows=4,656 width=16) (actual time=3,364.198..6,999.307 rows=10 loops=1) Workers Planned: 8 Workers Launched: 8
2.	6,966.508	6,966.508	↑ 582.0	1	9	→ Parallel Seq Scan on "INVENTORYTRANSACTION" "IT" (cost=0.00..5,929,876.82 rows=582 width=16) (actual time=5,762.476..6,966.508 rows=1 loops=9) Filter: (("FORMATTEDPOSTINGORDERNUMBER")::text ~~ 'R01-T001750536%'::text) Rows Removed by Filter: 5847699

Planning time	:	0.224 ms
Execution time	:	6,999.337 ms

 QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=1000.00..5931342.42 rows=4656 width=16) (actual time=3364.198..6999.307 rows=10 loops=1)
   Workers Planned: 8
   Workers Launched: 8
   ->  Parallel Seq Scan on "INVENTORYTRANSACTION" "IT"  (cost=0.00..5929876.82 rows=582 width=16) (actual time=5762.476..6966.508 rows=1 loops=9)
         Filter: (("FORMATTEDPOSTINGORDERNUMBER")::text ~~ 'R01-T001750536%'::text)
         Rows Removed by Filter: 5847699
 Planning time: 0.224 ms
 Execution time: 6999.337 ms
(8 rows)

Per node type stats

node type	count	sum of times	% of query
Gather	1	32.799 ms	0.5 %
Parallel Seq Scan	1	6,966.508 ms	99.5 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
"INVENTORYTRANSACTION"	1	6,966.508 ms	99.5 %
Parallel Seq Scan	1	6,966.508 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BTYm

Color mode:

Visible columns:

Per node type stats

Per table stats