Skip to content
This repository has been archived by the owner on Feb 8, 2018. It is now read-only.

backfill the network column of the exchange_routes table #4500

Closed
chadwhitacre opened this issue Jun 2, 2017 · 1 comment
Closed

backfill the network column of the exchange_routes table #4500

chadwhitacre opened this issue Jun 2, 2017 · 1 comment

Comments

@chadwhitacre
Copy link
Contributor

Doesn't help to back route (#2779) if the route has an unknown network.

@chadwhitacre
Copy link
Contributor Author

We have 1626 routes with unknown network.

We have 44993 exchanges (51%) linked to one or another of those routes.

gratipay::DATABASE=> select count(*) from exchanges e join exchange_routes er on e.route = er.id where network='unknown';
┌───────┐
│ count │
├───────┤
│ 44993 │
└───────┘
(1 row)

gratipay::DATABASE=> select count(*) from exchanges e join exchange_routes er on e.route = er.id;
┌───────┐
│ count │
├───────┤
│ 88622 │
└───────┘
(1 row)

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant