#	exclusive	inclusive	rows x	rows	loops	node
1.	15.705	1,130.294	↓ 0.0	0	1	→ Gather (cost=1,000.00..646,380.54 rows=660 width=8) (actual time=1,121.526..1,130.294 rows=0 loops=1)
2.	1,114.589	1,114.589	↓ 0.0	0	5	→ Parallel Seq Scan on comm_values (cost=0.00..645,314.54 rows=165 width=8) (actual time=1,114.589..1,114.589 rows=0 loops=5)

Gather (cost=1000.00..646380.54 rows=660 width=8) (actual time=1121.526..1130.294 rows=0 loops=1)
Workers Planned: 4
Workers Launched: 4
-> Parallel Seq Scan on comm_values (cost=0.00..645314.54 rows=165 width=8) (actual time=1114.589..1114.589 rows=0 loops=5)
Filter: ((value)::text = 'in356645'::text)
Rows Removed by Filter: 5018922
Planning time: 0.893 ms
Execution time: 1130.342 ms

Per node type stats

node type	count	sum of times	% of query
Gather	1	15.705 ms	1.4 %
Parallel Seq Scan	1	1,114.589 ms	98.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
comm_values	1	1,114.589 ms	98.6 %
Parallel Seq Scan	1	1,114.589 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KXea

Color mode:

Visible columns:

Per node type stats

Per table stats