...
https://github.com/perfsonar/elmond
elmond/elmond/perfsonar-elmond/elmond/app.py
elmond/elmond/perfsonar-elmond/elmond/data.py
⭐ Only opensearch used
Image Added
| 코드 블럭 |
|---|
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ls_hosts'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=hosts&src=?source=134.75.207.2
&dest=138.44.228.7'
curl '
&url=https://ps-daej.kreonet2.net/esmond/perfsonar-graphs/cgi-bin/graphData.cgi?action=has_traceroute_data&url=httparchive/
&timeframe=1d#start=1693273543&end=1693878343
A=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/&/
B=b01012273dd3c9c66e8bbfc6b095dde515c57cbb11afa76a4015dca4bfee7da2
C=e632505ff9396efd34f63927cace884b5cb14cc4b5bf61d1b431c182a56fca0e
curl 'A/?source=134.75.207.2&destdestination=138.44.228.7'
curl 'https:A//ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=http://ps-daej.kreonet2.net/esmond/perfsonar/archive/?source=134.75.207.2&destination=138.44.228.7'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=http://ps-daej.kreonet2.net/esmond/perfsonar/archive/?format=json&pscheduler-test-type=dns&measurement-agent=134.75.207.2&pscheduler-dns-query=138.44.228.7'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=http://ps-daej.kreonet2.net/esmond/perfsonar/archive/?format=json&pscheduler-test-type=http&measurement-agent=134.75.207.2&pscheduler-http-url=138.44.228.7'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=http://ps-daej.kreonet2.net/esmond/perfsonar/archive/?source=138.44.228.7&destination=134.75.207.2'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=http://ps-daej.kreonet2.net/esmond/perfsonar/archive/?format=json&pscheduler-test-type=dns&measurement-agent=138.44.228.7&pscheduler-dns-query=134.75.207.2'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=http://ps-daej.kreonet2.net/esmond/perfsonar/archive/?format=json&pscheduler-test-type=http&measurement-agent=138.44.228.7&pscheduler-http-url=134.75.207.2'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/b01012273dd3c9c66e8bbfc6b095dde515c57cbb11afa76a4015dca4bfee7da2/failures/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/b01012273dd3c9c66e8bbfc6b095dde515c57cbb11afa76a4015dca4bfee7da2/packet-count-sent/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/b01012273dd3c9c66e8bbfc6b095dde515c57cbb11afa76a4015dca4bfee7da2/histogram-owdelay/statistics/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/b01012273dd3c9c66e8bbfc6b095dde515c57cbb11afa76a4015dca4bfee7da2/packet-loss-rate/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/b01012273dd3c9c66e8bbfc6b095dde515c57cbb11afa76a4015dca4bfee7da2/packet-count-lost/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/633d37ee8d02faea57253338387248ff14bd8ef135aba39eefa30ef73c166b26/failures/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/e632505ff9396efd34f63927cace884b5cb14cc4b5bf61d1b431c182a56fca0e/failures/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/e632505ff9396efd34f63927cace884b5cb14cc4b5bf61d1b431c182a56fca0e/throughput/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/e632505ff9396efd34f63927cace884b5cb14cc4b5bf61d1b431c182a56fca0e/packet-retransmits/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/e4f166e6bfc9e6f904b8c3cca3fa55d2de65c0d8d36f97b4cf8b1ec19750836b/failures/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/e4f166e6bfc9e6f904b8c3cca3fa55d2de65c0d8d36f97b4cf8b1ec19750836b/packet-count-sent/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/e4f166e6bfc9e6f904b8c3cca3fa55d2de65c0d8d36f97b4cf8b1ec19750836b/histogram-owdelay/statistics/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/e4f166e6bfc9e6f904b8c3cca3fa55d2de65c0d8d36f97b4cf8b1ec19750836b/packet-loss-rate/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/e4f166e6bfc9e6f904b8c3cca3fa55d2de65c0d8d36f97b4cf8b1ec19750836b/packet-count-lost/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/d71bab605895223dd0cd7105c8afe3db34d2ed98bacc835819b55375aab193ce/failures/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/d71bab605895223dd0cd7105c8afe3db34d2ed98bacc835819b55375aab193ce/packet-count-sent/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/d71bab605895223dd0cd7105c8afe3db34d2ed98bacc835819b55375aab193ce/histogram-owdelay/statistics/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/d71bab605895223dd0cd7105c8afe3db34d2ed98bacc835819b55375aab193ce/packet-loss-rate/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/d71bab605895223dd0cd7105c8afe3db34d2ed98bacc835819b55375aab193ce/packet-count-lost/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/32925fb4f2b93d861fd3a325908734ab12e1dde083f7ff4e0ab4c860a60b6b92/failures/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/32925fb4f2b93d861fd3a325908734ab12e1dde083f7ff4e0ab4c860a60b6b92/throughput/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/32925fb4f2b93d861fd3a325908734ab12e1dde083f7ff4e0ab4c860a60b6b92/packet-retransmits/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/3847418218e4a93c9398e946e5f3d3c374b6f295d8fd37ad18618071d927a121/failures/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/3847418218e4a93c9398e946e5f3d3c374b6f295d8fd37ad18618071d927a121/packet-count-sent/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/3847418218e4a93c9398e946e5f3d3c374b6f295d8fd37ad18618071d927a121/histogram-owdelay/statistics/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/3847418218e4a93c9398e946e5f3d3c374b6f295d8fd37ad18618071d927a121/packet-loss-rate/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/3847418218e4a93c9398e946e5f3d3c374b6f295d8fd37ad18618071d927a121/packet-count-lost/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/07f99260b2e8f69cb9178b5378a1bd0b7613a9b209f57b41051a6c8dabb8739e/failures/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/d119142bf5e7805bad66cce67022a137504422a4327e45a89d92a675dc0a4cc8/failures/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/d119142bf5e7805bad66cce67022a137504422a4327e45a89d92a675dc0a4cc8/throughput/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/d119142bf5e7805bad66cce67022a137504422a4327e45a89d92a675dc0a4cc8/packet-retransmits/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/9fd43fb9bc8c62fbfc4b23309a9973790a174e08755a3367ed57ea70c0b563ec/failures/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/9fd43fb9bc8c62fbfc4b23309a9973790a174e08755a3367ed57ea70c0b563ec/packet-count-sent/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/9fd43fb9bc8c62fbfc4b23309a9973790a174e08755a3367ed57ea70c0b563ec/histogram-owdelay/statistics/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/9fd43fb9bc8c62fbfc4b23309a9973790a174e08755a3367ed57ea70c0b563ec/packet-loss-rate/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/9fd43fb9bc8c62fbfc4b23309a9973790a174e08755a3367ed57ea70c0b563ec/packet-count-lost/aggregations/86400?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/6491af1f55ba9202deee2f11c4964d0b03565d0d58888d6b4a444f3c39872ac9/failures/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/2f56c6575525ec9b6e96656751b952775fe2dba426f73bd9771006118b103d60/failures/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/2f56c6575525ec9b6e96656751b952775fe2dba426f73bd9771006118b103d60/throughput/base/0?time-start=1693271687&time-end=1693876487'
curl 'https://ps-daej.kreonet2.net/perfsonar-graphs/cgi-bin/graphData.cgi?action=ma_data&url=https://ps-daej.kreonet2.net/esmond/perfsonar/archive/2f56c6575525ec9b6e96656751b952775fe2dba426f73bd9771006118b103d60/packet-retransmits/base/0?time-start=1693271687&time-end=1693876487'B/failures/base/0 ?time-start=1693273543&time-end=1693878343'
curl 'A/B/packet-count-sent/aggregations/86400 ?time-start=1693273543&time-end=1693878343'
curl 'A/B/histogram-owdelay/statistics/86400 ?time-start=1693273543&time-end=1693878343'
curl 'A/B/packet-loss-rate/aggregations/86400 ?time-start=1693273543&time-end=1693878343'
curl 'A/B/packet-count-lost/aggregations/86400 ?time-start=1693273543&time-end=1693878343'
curl 'A/C/throughput/base/0 ?time-start=1693273543&time-end=1693878343' |
| 코드 블럭 |
|---|
| language | bash |
|---|
| linenumbers | true |
|---|
|
# du -h /var/lib/pgsql
2.9G /var/lib/pgsql
# du -h /var/lib/opensearch
15G /var/lib/opensearch |
| 코드 블럭 |
|---|
| language | bash |
|---|
| linenumbers | true |
|---|
|
# su postgres
bash-4.2$ psql
psql (10.17)
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
------------+------------+-----------+---------+-------+---------------------------
esmond | postgres | SQL_ASCII | C | C | =Tc/postgres +
| | | | | postgres=CTc/postgres +
| | | | | esmond=CTc/postgres
pscheduler | pscheduler | SQL_ASCII | C | C | =Tc/pscheduler +
| | | | | pscheduler=CTc/pscheduler
postgres=# \c esmond
You are now connected to database "esmond" as user "postgres".
esmond=# select
esmond-# table_name,
esmond-# pg_size_pretty(pg_relation_size(quote_ident(table_name))),
esmond-# pg_relation_size(quote_ident(table_name))
esmond-# from information_schema.tables
esmond-# where table_schema = 'public';
table_name | pg_size_pretty | pg_relation_size
----------------------------+----------------+------------------
django_migrations | 8192 bytes | 8192
ps_metadata_parameters | 8192 bytes | 8192
ps_networkelement_subject | 0 bytes | 0
django_content_type | 8192 bytes | 8192
auth_group_permissions | 0 bytes | 0
auth_group | 0 bytes | 0
auth_user | 8192 bytes | 8192
auth_user_groups | 0 bytes | 0
auth_permission | 8192 bytes | 8192
auth_user_user_permissions | 0 bytes | 0
django_admin_log | 0 bytes | 0
ps_p2p_subject | 8192 bytes | 8192
useripaddress | 0 bytes | 0
ps_metadata | 8192 bytes | 8192
ps_event_types | 32 kB | 32768
authtoken_token | 8192 bytes | 8192
django_session | 0 bytes | 0
(17 rows)
esmond=# \c pscheduler
You are now connected to database "pscheduler" as user "postgres".
pscheduler=# select
pscheduler-# table_name,
pscheduler-# pg_size_pretty(pg_relation_size(quote_ident(table_name))),
pscheduler-# pg_relation_size(quote_ident(table_name))
pscheduler-# from information_schema.tables
pscheduler-# where table_schema = 'public';
table_name | pg_size_pretty | pg_relation_size
---------------------------+----------------+------------------
scheduling_class | 8192 bytes | |
| 코드 블럭 |
|---|
| language | bash |
|---|
| linenumbers | true |
|---|
|
# su postgres
bash-4.2$ psql
psql (10.17)
postgres=# \l
8192
archive_default List of databases
| Name16 kB | Owner | Encoding | Collate | Ctype | Access privileges
------------+------------+-----------+---------+-------+---------------------------
esmond | postgres | SQL_ASCII | C16384
tool_test | 8192 bytes | 8192
table_version | 8192 bytes | 8192
heartbeat | 528 kB | 540672
auth_key_type | 8192 bytes | 8192
auth_key | 0 bytes | 0
control | 8192 bytes | 8192
queries | 0 bytes | 0
heartbeat_full | 0 bytes | 0
archiving_eligible | 0 bytes | 0
schedule | 0 bytes | 0
archiver_test | 0 bytes | 0
heartbeat_json | 0 bytes | 0
http_queue | 48 kB | 49152
test | 440 kB | 450560
tool | 696 kB | 712704
archiver_summary | 0 bytes C | =Tc/postgres | +
0
context | | 40 kB | | 40960
run_conflictable | postgres=CTc/postgres +
| 0 bytes | | 0
run_status | | 0 bytes | esmond=CTc/postgres
pscheduler | pscheduler | SQL_ASCII | C 0
run_status_short | C | =Tc/pscheduler0 bytes | +
| 0
schedule_upcoming | 0 bytes | | | pscheduler=CTc/pscheduler
postgres=# \c esmond
You are now connected to database "esmond" as user "postgres".
esmond=# \dt
0
schedule_runs_to_schedule | 0 bytes | 0
schedule_overlap List of relations
Schema | | 0 bytes Name | | Type | Owner
--------+----------------------------+-------+--------
public |0
authrun_groupstate | table8192 |bytes esmond
public | auth_group_permissions | | table | esmond
public | auth_permission 8192
task | table | esmond
public | auth_user | 7552 kB | table | esmond
public | auth_user_groups 7733248
configurables | table | esmond
public | auth_user_user_permissions | table8192 |bytes esmond
public | authtoken_token | | table | esmond8192
public | django_admin_logrun_latest | table | esmond
public | django_content_type136 kB | table | esmond
public | django_migrations 139264
archiver | table | esmond
public | django_session | table216 |kB esmond
public | ps_event_types | | table | esmond221184
publicrun | ps_metadata | table | esmond
public | ps_metadata_parameters388 MB | table | esmond
public | ps_networkelement_subject | table | esmond406921216
publicarchiving | ps_p2p_subject | table | esmond
575 publicMB | useripaddress | | table | esmond602931200
(1732 rows)
|
https://stackoverflow.com/questions/21738408/postgresql-list-and-order-tables-by-size