psql service=staging-swh-deposit -c '\x' -c 'select now(), * from deposit order by id desc limit 5;'
Pager usage is off.
Null display is "(null)".
Timing is on.
Border style is 2.
Current Host Server Date Time : Tue 15 Feb 2022 10:32:40 AM CET
Administrative queries:
:settings -- Server Settings
:conninfo -- Server connections
:activity -- Server activity
:locks -- Lock info
:waits -- Waiting queires
:dbsize -- Database Size
:tablesize -- Tables Size
:uselesscol -- Useless columns
:uptime -- Server uptime
:menu -- Help Menu
\h -- Help with SQL commands
\? -- Help with psql commands
Development queries:
:sp -- Current Search Path
:clear -- Clear screen
:ll -- List
Expanded display is used automatically.
Expanded display is off.
+-------------------------------+-----+-------------------------------+-------------------------------+------------------------------------------+----------------------------------------------------+--------+-----------+---------------+-----------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+--------------+---------------------------------------------------------------------------+
| now | id | reception_date | complete_date | external_id | swhid | status | client_id | collection_id | parent_id | status_detail | swhid_context | check_task_id | load_task_id | origin_url |
+-------------------------------+-----+-------------------------------+-------------------------------+------------------------------------------+----------------------------------------------------+--------+-----------+---------------+-----------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+--------------+---------------------------------------------------------------------------+
| 2022-02-15 09:32:40.673076+00 | 921 | 2022-02-15 00:06:27.816033+00 | 2022-02-15 00:06:27.815648+00 | check-deposit-2022-02-15T00:06:27.562739 | swh:1:dir:d83b7dda887dc790f7207608474650d4344b8df9 | done | 3 | 2 | (null) | (null) | swh:1:dir:d83b7dda887dc790f7207608474650d4344b8df9;origin=https://www.softwareheritage.org/check-deposit-2022-02-15T00:06:27.562739;visit=swh:1:snp:cf933dcdb492a51ffdb331ade44c189f51733064;anchor=swh:1:rel:505afc55d290a1d84e335d29bdad5a9576be72d9;path=/ | 29805447 | 29805449 | https://www.softwareheritage.org/check-deposit-2022-02-15T00:06:27.562739 |
| 2022-02-15 09:32:40.673076+00 | 920 | 2022-02-14 15:48:37.721157+00 | 2022-02-14 15:48:37.721157+00 | | swh:1:dir:79b8c8755dbed34f01a6a7184ffc196f3c58cb5d | done | 5 | 4 | (null) | (null) | swh:1:dir:79b8c8755dbed34f01a6a7184ffc196f3c58cb5d | (null) | (null) | (null) |
| 2022-02-15 09:32:40.673076+00 | 919 | 2022-02-14 01:07:10.934471+00 | 2022-02-14 01:07:10.934106+00 | check-deposit-2022-02-14T01:07:10.728209 | swh:1:dir:d83b7dda887dc790f7207608474650d4344b8df9 | done | 3 | 2 | (null) | (null) | swh:1:dir:d83b7dda887dc790f7207608474650d4344b8df9;origin=https://www.softwareheritage.org/check-deposit-2022-02-14T01:07:10.728209;visit=swh:1:snp:d0f1a44326073ff93443272f0aa505ce99c7f378;anchor=swh:1:rel:ce73f92c1d6014edd03548ac0daf3d1b1aff2848;path=/ | 29787998 | 29788001 | https://www.softwareheritage.org/check-deposit-2022-02-14T01:07:10.728209 |
| 2022-02-15 09:32:40.673076+00 | 918 | 2022-02-13 02:07:44.85524+00 | 2022-02-13 02:07:44.854898+00 | check-deposit-2022-02-13T02:07:44.416972 | swh:1:dir:d83b7dda887dc790f7207608474650d4344b8df9 | done | 3 | 2 | (null) | (null) | swh:1:dir:d83b7dda887dc790f7207608474650d4344b8df9;origin=https://www.softwareheritage.org/check-deposit-2022-02-13T02:07:44.416972;visit=swh:1:snp:72677e9cd3d43e8f8e3de6f82fe7d8e89fd0dda6;anchor=swh:1:rel:b56de15122f5c511ceb4081f56fca9ee8b7c2cba;path=/ | 29774028 | 29774029 | https://www.softwareheritage.org/check-deposit-2022-02-13T02:07:44.416972 |
| 2022-02-15 09:32:40.673076+00 | 917 | 2022-02-12 03:08:19.97471+00 | 2022-02-12 03:08:19.974303+00 | check-deposit-2022-02-12T03:08:19.557842 | swh:1:dir:d83b7dda887dc790f7207608474650d4344b8df9 | done | 3 | 2 | (null) | (null) | swh:1:dir:d83b7dda887dc790f7207608474650d4344b8df9;origin=https://www.softwareheritage.org/check-deposit-2022-02-12T03:08:19.557842;visit=swh:1:snp:dd0fa00f1d311bf968bb0cdef9f4d66acc85353a;anchor=swh:1:rel:86bd2954517b0edc01b59b918ea970c1e4586183;path=/ | 29753890 | 29753894 | https://www.softwareheritage.org/check-deposit-2022-02-12T03:08:19.557842 |
+-------------------------------+-----+-------------------------------+-------------------------------+------------------------------------------+----------------------------------------------------+--------+-----------+---------------+-----------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+--------------+---------------------------------------------------------------------------+
(5 rows)
Time: 40.376 ms