explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UUyT

Settings
# exclusive inclusive rows x rows loops node
1. 0.567 1,192.311 ↓ 1.3 56 1

Nested Loop (cost=236,938.83..680,942.90 rows=43 width=4) (actual time=858.399..1,192.311 rows=56 loops=1)

  • Join Filter: (x0.keymiindustrytree = x0_2.keymiindustrytree)
  • Rows Removed by Join Filter: 3240
2. 0.000 727.008 ↓ 47.8 3,296 1

Gather (cost=235,938.83..486,115.45 rows=69 width=6) (actual time=392.499..727.008 rows=3,296 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 221.170 990.557 ↓ 37.9 1,099 3

Hash Join (cost=234,938.83..485,108.55 rows=29 width=6) (actual time=388.385..990.557 rows=1,099 loops=3)

  • Hash Cond: (x0.keyinstn = x0_1.keyinstn)
4. 527.397 527.397 ↑ 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.007..527.397 rows=2,861,760 loops=3)

  • Filter: ((updoperation < 2) AND (keyindustryrelationshiplevel = 0))
  • Rows Removed by Filter: 1273046
5. 0.488 241.990 ↓ 19.6 3,187 3

Hash (cost=234,936.79..234,936.79 rows=163 width=4) (actual time=241.989..241.990 rows=3,187 loops=3)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 145kB
6. 241.502 241.502 ↓ 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.025..241.502 rows=3,187 loops=3)

  • Index Cond: (industrybenchmark = true)
  • Filter: (industrybenchmark AND (updoperation < 2) AND (keyinstn <> 4008251))
  • Rows Removed by Filter: 1
7. 0.000 464.736 ↑ 6.0 1 3,296

Materialize (cost=1,000.00..194,821.26 rows=6 width=2) (actual time=0.141..0.141 rows=1 loops=3,296)

8. 2.288 465.886 ↑ 6.0 1 1

Gather (cost=1,000.00..194,821.23 rows=6 width=2) (actual time=465.822..465.886 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 463.598 463.598 ↓ 0.0 0 3

Parallel Seq Scan on instnmiindustry x0_2 (cost=0.00..193,820.62 rows=2 width=2) (actual time=338.336..463.598 rows=0 loops=3)

  • Filter: ((updoperation < 2) AND (keyindustryrelationshiplevel = 0) AND (keyinstn = 4008251))
  • Rows Removed by Filter: 4134806
Planning time : 0.275 ms