# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 162,089.745 | 178,019.323 | ↑ 1.0 | 1 | 1 |
→
Aggregate (cost=2,006,508.14..2,006,508.15 rows=1 width=8) (actual time=178,019.322..178,019.323 rows=1 loops=1) |
2. | 15,928.416 | 15,929.578 | ↓ 1.3 | 23,981,911 | 1 |
→
Index Only Scan using api_report_a_c_s_r_index on api_report (cost=179.46..1,960,959.16 rows=18,219,594 width=20) (actual time=1.333..15,929.578 rows=23,981,911 loops=1)
|
3. |
SubPlan (for Index Only Scan) |
|||||
4. | 1.162 | 1.162 | ↑ 1.0 | 107 | 1 |
→
Seq Scan on api_rule (cost=0.00..178.49 rows=107 width=4) (actual time=0.016..1.162 rows=107 loops=1)
|
Planning time | : | 0.374 ms |
---|---|---|
Execution time | : | 178,019.402 ms |