# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.051 | 10.070 | ↑ 25,804.0 | 1 | 1 |
→
Nested Loop (cost=1,578.16..9,371.84 rows=25,804 width=223) (actual time=10.069..10.070 rows=1 loops=1)
|
2. | 0.004 | 10.006 | ↑ 200.0 | 1 | 1 |
→
HashAggregate (cost=1,577.75..1,579.75 rows=200 width=4) (actual time=10.005..10.006 rows=1 loops=1)
|
3. | 0.131 | 10.002 | ↑ 1,570.0 | 1 | 1 |
→
Hash Join (cost=1,544.00..1,573.82 rows=1,570 width=4) (actual time=10.000..10.002 rows=1 loops=1)
|
4. | 0.010 | 0.010 | ↑ 1,570.0 | 1 | 1 |
→
Seq Scan on safekids.participant part (cost=0.00..25.70 rows=1,570 width=8) (actual time=0.009..0.010 rows=1 loops=1)
|
5. | 5.332 | 9.861 | ↑ 1.0 | 41,600 | 1 |
→
Hash (cost=1,024.00..1,024.00 rows=41,600 width=4) (actual time=9.861..9.861 rows=41,600 loops=1)
|
6. | 4.529 | 4.529 | ↑ 1.0 | 41,600 | 1 |
→
Seq Scan on safekids.person per (cost=0.00..1,024.00 rows=41,600 width=4) (actual time=0.007..4.529 rows=41,600 loops=1)
|
7. | 0.013 | 0.013 | ↑ 1.0 | 1 | 1 |
→
Index Scan using case_pkey on safekids."case" c (cost=0.41..7.57 rows=1 width=187) (actual time=0.013..0.013 rows=1 loops=1)
|
Planning time | : | 0.290 ms |
---|---|---|
Execution time | : | 10.307 ms |