16:01:14 swh@db1:5432=> select * from origin_visit_status ovs inner join origin o on ovs.origin=o.id where date > '2021-11-10 15:00' and type='npm' limit 10;
+---------+-------+-------------------------------+---------+----------+--------------------------------------------+------+---------+-----------------------------------------------------------+
| origin  | visit |             date              | status  | metadata |                  snapshot                  | type |   id    |                            url                            |
+---------+-------+-------------------------------+---------+----------+--------------------------------------------+------+---------+-----------------------------------------------------------+
| 1796362 |     1 | 2021-11-10 15:00:22.221484+00 | full    | (null)   | \x034b93485d1fc0a0efc9dd3447b1f7a92e278041 | npm  | 1796362 | https://www.npmjs.com/package/angular-phonecat-nexen      |
| 1796363 |     1 | 2021-11-10 15:00:30.255544+00 | full    | (null)   | \x75afd71f0ead0456acbc8777e2ff90a5a7726e46 | npm  | 1796363 | https://www.npmjs.com/package/replace-task-webpack-plugin |
| 1796364 |     1 | 2021-11-10 15:00:30.321502+00 | created | (null)   | (null)                                     | npm  | 1796364 | https://www.npmjs.com/package/react-native-badge          |
| 1796373 |     1 | 2021-11-10 15:01:02.074164+00 | full    | (null)   | \xcf089d05b811cb5ca1db6d362efb490b78c8def2 | npm  | 1796373 | https://www.npmjs.com/package/chloe                       |
| 1796362 |     1 | 2021-11-10 15:00:17.243589+00 | created | (null)   | (null)                                     | npm  | 1796362 | https://www.npmjs.com/package/angular-phonecat-nexen      |
| 1796368 |     1 | 2021-11-10 15:00:50.801616+00 | full    | (null)   | \x1291f77517a284ff82d0298459b0763db02bf45f | npm  | 1796368 | https://www.npmjs.com/package/time_format                 |
| 1796371 |     1 | 2021-11-10 15:00:58.16354+00  | full    | (null)   | \x38138aced5fbc78af7b747aa2328f1b186ab6c75 | npm  | 1796371 | https://www.npmjs.com/package/rnpack                      |
| 1796377 |     1 | 2021-11-10 15:01:05.693586+00 | created | (null)   | (null)                                     | npm  | 1796377 | https://www.npmjs.com/package/webapi-enumeratedevices     |
| 1796376 |     1 | 2021-11-10 15:01:14.872231+00 | full    | (null)   | \xbe2f39fc54cc6a377f1de23ac7d9ca15f8713b63 | npm  | 1796376 | https://www.npmjs.com/package/voltrazord-layout           |
| 1796356 |     1 | 2021-11-10 15:00:17.16698+00  | full    | (null)   | \x6f9084961682cf79cdcdc681bcd5d36220bf635a | npm  | 1796356 | https://www.npmjs.com/package/stf-device-db               |
+---------+-------+-------------------------------+---------+----------+--------------------------------------------+------+---------+-----------------------------------------------------------+
(10 rows)

Time: 23893.118 ms (00:23.893)