# | 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)
|
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)
|
3. | 222.744 | 1,178.361 | ↓ 37.9 | 1,099 | 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)
|
4. | 532.666 | 532.666 | ↑ 1.1 | 2,861,760 | 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)
|
5. | 0.519 | 422.951 | ↓ 19.6 | 3,187 | 3 |
→
Hash (cost=234,936.79..234,936.79 rows=163 width=4) (actual time=422.951..422.951 rows=3,187 loops=3)
|
6. | 422.432 | 422.432 | ↓ 19.6 | 3,187 | 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)
|
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)
|
9. | 465.458 | 465.458 | ↓ 0.0 | 0 | 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)
|
Planning time | : | 0.443 ms |
---|