# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 23,482.694 | 24,028.882 | ↓ 1.0 | 135,518 | 1 |
→
Hash Join (cost=2,191.28..368,969.80 rows=134,427 width=1,064) (actual time=12.723..24,028.882 rows=135,518 loops=1)
|
2. | 135.042 | 546.177 | ↓ 1.0 | 135,518 | 1 |
→
Hash Join (cost=2,190.17..195,914.09 rows=134,427 width=783) (actual time=12.018..546.177 rows=135,518 loops=1)
|
3. | 204.442 | 410.316 | ↓ 1.0 | 135,518 | 1 |
→
Hash Join (cost=2,137.72..195,507.63 rows=134,427 width=565) (actual time=11.193..410.316 rows=135,518 loops=1)
|
4. | 197.444 | 205.084 | ↓ 1.0 | 135,518 | 1 |
→
Bitmap Heap Scan on entity_eton_agg d (cost=2,085.27..195,101.16 rows=134,427 width=347) (actual time=10.395..205.084 rows=135,518 loops=1)
|
5. | 7.640 | 7.640 | ↓ 1.0 | 136,091 | 1 |
→
Bitmap Index Scan on idx_entity_eton_agg_works_state (cost=0.00..2,051.66 rows=134,439 width=0) (actual time=7.640..7.640 rows=136,091 loops=1)
|
6. | 0.390 | 0.790 | ↑ 1.0 | 1,309 | 1 |
→
Hash (cost=36.09..36.09 rows=1,309 width=222) (actual time=0.790..0.790 rows=1,309 loops=1)
|
7. | 0.400 | 0.400 | ↑ 1.0 | 1,309 | 1 |
→
Seq Scan on orgref publisher (cost=0.00..36.09 rows=1,309 width=222) (actual time=0.002..0.400 rows=1,309 loops=1) |
8. | 0.390 | 0.819 | ↑ 1.0 | 1,309 | 1 |
→
Hash (cost=36.09..36.09 rows=1,309 width=222) (actual time=0.819..0.819 rows=1,309 loops=1)
|
9. | 0.429 | 0.429 | ↑ 1.0 | 1,309 | 1 |
→
Seq Scan on orgref resporg (cost=0.00..36.09 rows=1,309 width=222) (actual time=0.004..0.429 rows=1,309 loops=1) |
10. | 0.004 | 0.011 | ↑ 1.0 | 5 | 1 |
→
Hash (cost=1.05..1.05 rows=5 width=92) (actual time=0.011..0.011 rows=5 loops=1)
|
11. | 0.007 | 0.007 | ↑ 1.0 | 5 | 1 |
→
Seq Scan on eton_impact ei (cost=0.00..1.05 rows=5 width=92) (actual time=0.004..0.007 rows=5 loops=1) |
QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Hash Join (cost=2191.28..368969.80 rows=134427 width=1064) (actual time=12.723..24028.882 rows=135518 loops=1) Hash Cond: (d.impact_score = ei.impact_score) -> Hash Join (cost=2190.17..195914.09 rows=134427 width=783) (actual time=12.018..546.177 rows=135518 loops=1) Hash Cond: (d.responsible_org_orgref = resporg.swa_org_ref) -> Hash Join (cost=2137.72..195507.63 rows=134427 width=565) (actual time=11.193..410.316 rows=135518 loops=1) Hash Cond: (d.publisher_orgref = publisher.swa_org_ref) -> Bitmap Heap Scan on entity_eton_agg d (cost=2085.27..195101.16 rows=134427 width=347) (actual time=10.395..205.084 rows=135518 loops=1) Recheck Cond: (works_state = ANY ('{0,2,3,4,5,6,7,8}'::integer[])) Filter: active Rows Removed by Filter: 43 Heap Blocks: exact=19082 -> Bitmap Index Scan on idx_entity_eton_agg_works_state (cost=0.00..2051.66 rows=134439 width=0) (actual time=7.640..7.640 rows=136091 loops=1) Index Cond: (works_state = ANY ('{0,2,3,4,5,6,7,8}'::integer[])) -> Hash (cost=36.09..36.09 rows=1309 width=222) (actual time=0.790..0.790 rows=1309 loops=1) Buckets: 2048 Batches: 1 Memory Usage: 82kB -> Seq Scan on orgref publisher (cost=0.00..36.09 rows=1309 width=222) (actual time=0.002..0.400 rows=1309 loops=1) -> Hash (cost=36.09..36.09 rows=1309 width=222) (actual time=0.819..0.819 rows=1309 loops=1) Buckets: 2048 Batches: 1 Memory Usage: 82kB -> Seq Scan on orgref resporg (cost=0.00..36.09 rows=1309 width=222) (actual time=0.004..0.429 rows=1309 loops=1) -> Hash (cost=1.05..1.05 rows=5 width=92) (actual time=0.011..0.011 rows=5 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 9kB -> Seq Scan on eton_impact ei (cost=0.00..1.05 rows=5 width=92) (actual time=0.004..0.007 rows=5 loops=1) Planning time: 0.391 ms Execution time: 24084.291 ms 24 rows selected.
node type | count | sum of times | % of query |
---|---|---|---|
Bitmap Heap Scan | 1 | 197.444 ms | 0.8 % |
Bitmap Index Scan | 1 | 7.640 ms | 0.0 % |
Hash | 3 | 0.784 ms | 0.0 % |
Hash Join | 3 | 23,822.178 ms | 99.1 % |
Seq Scan | 3 | 0.836 ms | 0.0 % |
Table name | Scan count | Total time | % of query |
---|---|---|---|
scan type | count | sum of times | % of table |
entity_eton_agg | 1 | 197.444 ms | 0.8 % |
Bitmap Heap Scan | 1 | 197.444 ms | 100.0 % |
eton_impact | 1 | 0.007 ms | 0.0 % |
Seq Scan | 1 | 0.007 ms | 100.0 % |
orgref | 2 | 0.829 ms | 0.0 % |
Seq Scan | 2 | 0.829 ms | 100.0 % |