# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.053 | 1.043 | ↑ 69.3 | 200 | 1 |
→
Nested Loop (cost=10.49..857.57 rows=13,870 width=548) (actual time=0.115..1.043 rows=200 loops=1) |
2. | 0.151 | 0.190 | ↓ 2.0 | 200 | 1 |
→
HashAggregate (cost=10.07..11.07 rows=100 width=4) (actual time=0.085..0.190 rows=200 loops=1)
|
3. | 0.024 | 0.039 | ↓ 2.0 | 200 | 1 |
→
ProjectSet (cost=0.29..8.82 rows=100 width=4) (actual time=0.017..0.039 rows=200 loops=1) |
4. | 0.015 | 0.015 | ↑ 1.0 | 1 | 1 |
→
Index Scan using client_logs_client_id_by_date_index on client_logs (cost=0.29..8.31 rows=1 width=826) (actual time=0.014..0.015 rows=1 loops=1)
|
5. | 0.200 | 0.800 | ↑ 1.0 | 1 | 200 |
→
Append (cost=0.43..8.46 rows=1 width=548) (actual time=0.003..0.004 rows=1 loops=200) |
6. | 0.600 | 0.600 | ↑ 1.0 | 1 | 200 |
→
Index Scan using changes_y2018_change_id_change_date_idx on changes_y2018 (cost=0.43..8.45 rows=1 width=548) (actual time=0.003..0.003 rows=1 loops=200)
|