Revision 12624
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 4254 | 4254 |
Equivalent to VegBank''s observation table. |
| 4255 | 4255 |
|
| 4256 | 4256 |
`VACUUM ANALYZE VERBOSE locationevent` runtime: 20 min ("1188590 ms") @vegbiendev
|
| 4257 |
`CREATE INDEX locationevent_place_visit_id` runtime: 3 min ("179139 ms") @vegbiendev
|
|
| 4257 | 4258 |
`UPDATE locationevent SET place_visit_id = place_visit_id` runtime: >~1 h @vegbiendev |
| 4258 | 4259 |
'; |
| 4259 | 4260 |
|
Also available in: Unified diff
schemas/vegbien.sql: locationevent: documented `CREATE INDEX locationevent_place_visit_id` runtime (3 min)