#	exclusive	inclusive	rows x	rows	loops	node
1.	0.000	1,378.880	↓ 1.9	56	1	→ Nested Loop Semi Join (cost=236,938.83..680,942.41 rows=29 width=4) (actual time=1,038.144..1,378.880 rows=56 loops=1) Join Filter: (x0.keymiindustrytree = x0_2.keymiindustrytree) Rows Removed by Join Filter: 3,240
2.	0.000	911.650	↓ 47.8	3,296	1	→ Gather (cost=235,938.83..486,115.45 rows=69 width=6) (actual time=570.329..911.650 rows=3,296 loops=1) Workers Planned: 2 Workers Launched: 2
3.	222.744	1,178.361	↓ 37.9	1,099	3 / 3	→ Hash Join (cost=234,938.83..485,108.55 rows=29 width=6) (actual time=569.366..1,178.361 rows=1,099 loops=3) Hash Cond: (x0.keyinstn = x0_1.keyinstn)
4.	532.666	532.666	↑ 1.1	2,861,760	3 / 3	→ Parallel Seq Scan on instnmiindustry x0 (cost=0.00..180,899.25 rows=3,259,773 width=6) (actual time=0.006..532.666 rows=2,861,760 loops=3) Filter: ((updoperation < 2) AND (keyindustryrelationshiplevel = 0)) Rows Removed by Filter: 1,273,046
5.	0.519	422.951	↓ 19.6	3,187	3 / 3	→ Hash (cost=234,936.79..234,936.79 rows=163 width=4) (actual time=422.951..422.951 rows=3,187 loops=3) Buckets: 4,096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 145kB
6.	422.432	422.432	↓ 19.6	3,187	3 / 3	→ Index Scan using ix_panjivacompany_sudeep on panjivacompany x0_1 (cost=0.43..234,936.79 rows=163 width=4) (actual time=0.026..422.432 rows=3,187 loops=3) Index Cond: (industrybenchmark = true) Filter: (industrybenchmark AND (updoperation < 2) AND (keyinstn <> 4008251)) Rows Removed by Filter: 1
7.	0.209	468.032	↑ 6.0	1	3,296	→ Materialize (cost=1,000.00..194,821.26 rows=6 width=2) (actual time=0.142..0.142 rows=1 loops=3,296)
8.	2.365	467.823	↑ 6.0	1	1	→ Gather (cost=1,000.00..194,821.23 rows=6 width=2) (actual time=467.726..467.823 rows=1 loops=1) Workers Planned: 2 Workers Launched: 2
9.	465.458	465.458	↓ 0.0	0	3 / 3	→ Parallel Seq Scan on instnmiindustry x0_2 (cost=0.00..193,820.62 rows=2 width=2) (actual time=339.628..465.458 rows=0 loops=3) Filter: ((updoperation < 2) AND (keyindustryrelationshiplevel = 0) AND (keyinstn = 4,008,251)) Rows Removed by Filter: 4,134,806

"Nested Loop Semi Join  (cost=236938.83..680942.41 rows=29 width=4) (actual time=1038.144..1378.880 rows=56 loops=1)"
"  Join Filter: (x0.keymiindustrytree = x0_2.keymiindustrytree)"
"  Rows Removed by Join Filter: 3240"
"  ->  Gather  (cost=235938.83..486115.45 rows=69 width=6) (actual time=570.329..911.650 rows=3296 loops=1)"
"        Workers Planned: 2"
"        Workers Launched: 2"
"        ->  Hash Join  (cost=234938.83..485108.55 rows=29 width=6) (actual time=569.366..1178.361 rows=1099 loops=3)"
"              Hash Cond: (x0.keyinstn = x0_1.keyinstn)"
"              ->  Parallel Seq Scan on instnmiindustry x0  (cost=0.00..180899.25 rows=3259773 width=6) (actual time=0.006..532.666 rows=2861760 loops=3)"
"                    Filter: ((updoperation < 2) AND (keyindustryrelationshiplevel = 0))"
"                    Rows Removed by Filter: 1273046"
"              ->  Hash  (cost=234936.79..234936.79 rows=163 width=4) (actual time=422.951..422.951 rows=3187 loops=3)"
"                    Buckets: 4096 (originally 1024)  Batches: 1 (originally 1)  Memory Usage: 145kB"
"                    ->  Index Scan using ix_panjivacompany_sudeep on panjivacompany x0_1  (cost=0.43..234936.79 rows=163 width=4) (actual time=0.026..422.432 rows=3187 loops=3)"
"                          Index Cond: (industrybenchmark = true)"
"                          Filter: (industrybenchmark AND (updoperation < 2) AND (keyinstn <> 4008251))"
"                          Rows Removed by Filter: 1"
"  ->  Materialize  (cost=1000.00..194821.26 rows=6 width=2) (actual time=0.142..0.142 rows=1 loops=3296)"
"        ->  Gather  (cost=1000.00..194821.23 rows=6 width=2) (actual time=467.726..467.823 rows=1 loops=1)"
"              Workers Planned: 2"
"              Workers Launched: 2"
"              ->  Parallel Seq Scan on instnmiindustry x0_2  (cost=0.00..193820.62 rows=2 width=2) (actual time=339.628..465.458 rows=0 loops=3)"
"                    Filter: ((updoperation < 2) AND (keyindustryrelationshiplevel = 0) AND (keyinstn = 4008251))"
"                    Rows Removed by Filter: 4134806"
"Planning time: 0.443 ms"
"Execution time: 1380.326 ms"

Per node type stats

node type	count	sum of times	% of query
Gather	2	2.365 ms	0.2 %
Hash	1	0.519 ms	0.0 %
Hash Join	1	222.744 ms	16.2 %
Index Scan	1	422.432 ms	30.6 %
Materialize	1	0.209 ms	0.0 %
Nested Loop Semi Join	1	0.000 ms	0.0 %
Parallel Seq Scan	2	998.124 ms	72.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
instnmiindustry	2	998.124 ms	72.4 %
Parallel Seq Scan	2	998.124 ms	100.0 %
panjivacompany	1	422.432 ms	30.6 %
Index Scan	1	422.432 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9z3

Color mode:

Visible columns:

Per node type stats

Per table stats