# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 1.331 | 163.496 | ↑ 1.0 | 1 | 1 |
→
Aggregate (cost=110.05..110.06 rows=1 width=16) (actual time=163.495..163.496 rows=1 loops=1)
|
2. | 1.562 | 162.165 | ↑ 1.0 | 3,000 | 1 |
→
Limit (cost=0.01..65.05 rows=3,000 width=688) (actual time=56.583..162.165 rows=3,000 loops=1)
|
3. | 3.689 | 160.603 | ↑ 24,771.1 | 3,000 | 1 |
→
Nested Loop (cost=0.01..1,611,332.68 rows=74,313,400 width=688) (actual time=56.581..160.603 rows=3,000 loops=1)
|
4. | 1.177 | 20.801 | ↑ 322.1 | 2,307 | 1 |
→
Append (cost=0.00..125,064.67 rows=743,134 width=1,048) (actual time=15.524..20.801 rows=2,307 loops=1)
|
5. | 0.028 | 0.028 | ↓ 0.0 | 0 | 1 |
→
Seq Scan on conversion c (cost=0.00..0.00 rows=1 width=40) (actual time=0.027..0.028 rows=0 loops=1)
|
6. | 19.596 | 19.596 | ↑ 198.9 | 2,307 | 1 |
→
Index Scan using route_conversion_1549404000_endtime_idx on conversion_1549404000 c_1 (cost=0.42..74,931.74 rows=458,941 width=1,048) (actual time=15.494..19.596 rows=2,307 loops=1)
|
7. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using route_conversion_1549490400_endtime_idx on conversion_1549490400 c_2 (cost=0.42..46,417.27 rows=284,192 width=1,047) (never executed)
|
|
8. | 136.113 | 136.113 | ↑ 100.0 | 1 | 2,307 |
→
Function Scan on jsonb_each esme (cost=0.01..1.00 rows=100 width=0) (actual time=0.058..0.059 rows=1 loops=2,307)
|