# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.044 | 1.100 | ↑ 65.0 | 200 | 1 |
→
Nested Loop (cost=10.49..857.57 rows=12,999 width=548) (actual time=0.162..1.100 rows=200 loops=1) |
2. | 0.192 | 0.256 | ↓ 2.0 | 200 | 1 |
→
HashAggregate (cost=10.07..11.07 rows=100 width=4) (actual time=0.119..0.256 rows=200 loops=1)
|
3. | 0.030 | 0.064 | ↓ 2.0 | 200 | 1 |
→
ProjectSet (cost=0.29..8.82 rows=100 width=4) (actual time=0.036..0.064 rows=200 loops=1) |
4. | 0.034 | 0.034 | ↑ 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.033..0.034 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)
|