# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.003 | 1.933 | ↓ 4.0 | 4 | 1 |
→
Group (cost=225.88..225.89 rows=1 width=108) (actual time=1.931..1.933 rows=4 loops=1)
|
2. | 0.020 | 1.930 | ↓ 4.0 | 4 | 1 |
→
Sort (cost=225.88..225.88 rows=1 width=108) (actual time=1.930..1.930 rows=4 loops=1)
|
3. | 0.015 | 1.910 | ↓ 4.0 | 4 | 1 |
→
Nested Loop (cost=130.83..225.87 rows=1 width=108) (actual time=1.631..1.910 rows=4 loops=1) |
4. | 0.037 | 1.895 | ↓ 4.0 | 4 | 1 |
→
Nested Loop (cost=130.55..225.49 rows=1 width=101) (actual time=1.626..1.895 rows=4 loops=1)
|
5. | 0.182 | 1.858 | ↑ 18.8 | 4 | 1 |
→
Hash Join (cost=130.27..190.42 rows=75 width=40) (actual time=1.604..1.858 rows=4 loops=1)
|
6. | 1.240 | 1.661 | ↓ 1.0 | 2,515 | 1 |
→
HashAggregate (cost=129.14..154.15 rows=2,501 width=16) (actual time=1.343..1.661 rows=2,515 loops=1)
|
7. | 0.421 | 0.421 | ↑ 1.0 | 3,409 | 1 |
→
Seq Scan on batch_job_execution (cost=0.00..112.09 rows=3,409 width=16) (actual time=0.003..0.421 rows=3,409 loops=1) |
8. | 0.015 | 0.015 | ↑ 1.5 | 4 | 1 |
→
Hash (cost=1.06..1.06 rows=6 width=24) (actual time=0.015..0.015 rows=4 loops=1) |