16:01:50 <hiro> #startmeeting network-health 2024-09-09
16:01:50 <MeetBot> Meeting started Mon Sep  9 16:01:50 2024 UTC.  The chair is hiro. Information about MeetBot at http://wiki.debian.org/MeetBot.
16:01:50 <MeetBot> Useful Commands: #action #agreed #help #info #idea #link #topic.
16:02:17 <hiro> welcome everyone
16:02:27 <GeKo> hi!
16:03:23 <hiro> I hope this is the week I can review pending issues on descriptorParser and start importing historical data
16:04:34 <GeKo> where are we with descriptorparser#118?
16:04:53 <hiro> also @juga asked me to review some queries for speed and I am going to do that and see if I c an add some indexes and persist some tables.. let's see
16:05:13 <GeKo> https://gitlab.torproject.org/tpo/network-health/metrics/descriptorParser/-/issues/119 might actually be related to that ticket
16:05:17 <hiro> I am not sure @GeKo it seems the bw files have been created?
16:05:27 <hiro> ops I mean bw records
16:05:31 <GeKo> "I don't think the problem is the query, but the machine, cpu busy with postgres (maybe there're other queries going on that i don't know about?)"
16:05:52 <GeKo> juga: did you mean this is actually a machine problem?
16:06:01 <juga> GeKo: also
16:06:02 <hiro> well the api queries the same db
16:06:06 <hiro> so if people are testing
16:07:12 <GeKo> hiro: what do you mean with bw records are created?
16:07:26 <GeKo> if you look at https://gitlab.torproject.org/tpo/network-health/metrics/descriptorParser/-/issues/119#note_3072698
16:07:38 <GeKo> you can see that we seem to have only 20 for that bw file
16:07:50 <GeKo> which seems... wrong
16:07:58 <GeKo> given that we have thousands of relays
16:08:25 <hiro> can it happen that the entry is repeated? and I am creating the digest wrong for it?
16:08:46 <hiro> so the digest is colliding and  hence the bw line is not saved?
16:09:29 <juga> hiro, good point, i intended to check that but forgot
16:09:46 * juga noting to check that
16:09:54 <hiro> so I am going to check the query with the relationship I have created and see
16:10:02 <juga> ok, thanks
16:10:30 <hiro> this: https://gitlab.torproject.org/tpo/network-health/metrics/metrics-sql-tables/-/blob/main/bandwidth_tables.sql?ref_type=heads#L80
16:11:14 <juga> yup
16:11:44 <hiro> ok I can give you an answer on that after the meeting
16:11:54 <juga> ok
16:14:25 <hiro> ok!
16:14:40 <hiro> does anyone have any other issue or blocker?
16:14:58 * juga is good
16:17:05 <GeKo> nope
16:17:29 <GeKo> i got a bit nerd-sniped by the osing proposal work
16:17:43 <hiro> sounds good
16:17:51 <hiro> I'll end the meeting than
16:17:54 <GeKo> and did not get to https://gitlab.torproject.org/tpo/network-health/analysis/-/issues/67
16:18:03 <GeKo> but try to this week :)
16:18:05 <GeKo> yeah
16:18:13 <GeKo> *osint
16:18:19 <hiro> I wanted  to check if is there something that we can save to have those metrics available in the db
16:18:31 <hiro> let's see if this week I have time
16:18:39 <GeKo> okay
16:18:53 <hiro> oook, thank you everyone
16:18:57 <hiro> #endmeeting