# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.008 | 32,991.504 | ↑ 1.0 | 30 | 1 |
→
Limit (cost=374,914.91..374,918.41 rows=30 width=188) (actual time=32,991.473..32,991.504 rows=30 loops=1) |
2. | 0.000 | 32,991.496 | ↑ 4,114.9 | 30 | 1 |
→
Gather Merge (cost=374,914.91..389,317.94 rows=123,446 width=188) (actual time=32,991.470..32,991.496 rows=30 loops=1)
|
3. | 570.600 | 98,928.822 | ↑ 269.5 | 229 | 3 |
→
Sort (cost=373,914.88..374,069.19 rows=61,723 width=188) (actual time=32,976.187..32,976.274 rows=229 loops=3)
|
4. | 277.122 | 98,358.222 | ↑ 1.2 | 50,175 | 3 |
→
Nested Loop (cost=6,233.16..363,305.73 rows=61,723 width=188) (actual time=14,195.288..32,786.074 rows=50,175 loops=3) |
5. | 41,051.846 | 55,181.760 | ↑ 1.2 | 50,175 | 3 |
→
Parallel Bitmap Heap Scan on tbl_proj_com_history_item this_ (cost=6,232.60..102,626.37 rows=61,723 width=66) (actual time=14,166.099..18,393.920 rows=50,175 loops=3)
|
6. | 14,129.914 | 14,129.914 | ↓ 1.0 | 150,524 | 1 |
→
Bitmap Index Scan on idx_fk116 (cost=0.00..6,195.57 rows=148,135 width=0) (actual time=14,129.914..14,129.914 rows=150,524 loops=1)
|
7. | 42,899.340 | 42,899.340 | ↑ 1.0 | 1 | 150,524 |
→
Index Scan using tbl_change_history_item_pkey on tbl_change_history_item this_1_ (cost=0.56..4.22 rows=1 width=155) (actual time=0.285..0.285 rows=1 loops=150,524)
|
Planning time | : | 51.784 ms |
---|---|---|
Execution time | : | 33,065.828 ms |