| # | 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 % |