# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.383 | 3.973 | ↑ 1.0 | 1,000 | 1 |
→
Limit (cost=0.00..66.88 rows=1,000 width=272) (actual time=0.147..3.973 rows=1,000 loops=1)
|
2. | 2.203 | 3.590 | ↑ 10.3 | 1,000 | 1 |
→
Nested Loop (cost=0.00..688.88 rows=10,300 width=272) (actual time=0.145..3.590 rows=1,000 loops=1)
|
3. | 0.146 | 0.523 | ↓ 4.2 | 432 | 1 |
→
Append (cost=0.00..96.63 rows=103 width=80) (actual time=0.123..0.523 rows=432 loops=1)
|
4. | 0.015 | 0.015 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on changes (cost=0.00..0.00 rows=1 width=80) (actual time=0.014..0.015 rows=0 loops=1)
|
5. | 0.269 | 0.362 | ↓ 6.9 | 432 | 1 |
→
Bitmap Heap Scan on changes_1549144800 (cost=2.03..59.31 rows=63 width=80) (actual time=0.107..0.362 rows=432 loops=1)
|
6. | 0.093 | 0.093 | ↓ 24.5 | 1,544 | 1 |
→
Bitmap Index Scan on route_changes_1549144800_endtime_idx (cost=0.00..2.01 rows=63 width=0) (actual time=0.093..0.093 rows=1,544 loops=1)
|
7. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Bitmap Heap Scan on changes_1549231200 (cost=1.78..36.81 rows=39 width=80) (never executed)
|
|
8. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Bitmap Index Scan on route_changes_1549231200_endtime_idx (cost=0.00..1.77 rows=39 width=0) (never executed)
|
|
9. | 0.864 | 0.864 | ↑ 50.0 | 2 | 432 |
→
Function Scan on jsonb_array_elements dt (cost=0.00..1.00 rows=100 width=32) (actual time=0.001..0.002 rows=2 loops=432) |