HNHacker News
TopNewBestAskShowJobs

kvaranasi_

65 karma · joined August 7, 2023

Email me: kaushik [at] rocketgraph (dot) app
submissionscomments
kvaranasi_··on Show HN: ML condenses billions of logs into a tiny snapshot your LLM can debug
No, that was a completely different project - build websites in minutes, not weeks. But yes, the AI wave did kill that because you can literally make websites in minutes with Claude code today. But it has the same name - Rocketgraph, and I built it.
kvaranasi_··on My tool found 1 DELETE TABLE log from 1M logs
Monitoring tools were built with the premise that humans have written the code and humans are reading the logs, querying dashboards. But today, it's far from the truth. The machine writes code and the machine debugs it. But the logging tools have not evolved beyond complex LogQL queries that take weeks to understand the documentation. And not to mention, the ever-evolving logging patterns within the same company.

It is impossible to detect anomalies in log patterns using deterministic methods alone. That is why companies like Datadog, etc have stopped at anomaly detection at the metrics layer. Because they are numbers you can predict. And you can't feed your entire firehose to LLMs because they blow up in compute.

I developed Rocketgraph that generates "snapshots" from billions of logs so that your agents can query and root cause without hallucinating and burning your engineering budget. First, we fingerprint the logs by masking away all the PII stuff, then use fuzzy matching to group together similar logs using TF-IDF. Then we apply IsolationForest to rank the logs with an anomaly score. By now, we have condensed them to 100-1000 log patterns we call a "snapshot". Here is the interesting part: we just make an LLM call with the service graph dependency map to root cause over the log patterns, and the result is something like what is shown. They are highly accurate.

It can be used to detect anomalous retry loops, weird call patterns, unseen formats, etc.

Basically, I'm building Datadog - but the user is an AI agent. A monitoring tool whose output is queryable and consumable by an AI agent.

I would love to hear your thoughts on this.

kvaranasi_··on LogHub: A large dataset of real-world logs to benchmark your tools
Hey, I thought this might be helpful to some of you who are working in the observability space. It's a large dataset of real-world logs. You can use it to benchmark your tools. Or test the ones you are building. I am not the author.
kvaranasi_··on Drain3 – A robust streaming log template miner based on the Drain algorithm
I really like this library. It basically masks the PII data and creates log templates from logs. So you can ask questions like "How many times has the database connection timed out?" Or "How many times have users logged out of the app?"
kvaranasi_··on Using Isolation forests to flag anomalies in log patterns
Consider you have logs at ~100k/hour. And you are looking for a log that you have never seen before or one that is rare to find in this pool of 1000s of look-alike errors and warnings.

I built a tool that flags out anomalies. The rarest of the rarest logs by clustering them. This is how it works:

1. connects to existing Loki/New Relic/Datadog, etc - pulls logs from there every few minutes

2. Applies Drain3(https://github.com/logpai/Drain3) - A template miner to retract PIIs. Also, "user 1234 crashed" and "user 5678 crashed" are the same log pattern but different logs.

3. Applies IsolationForest(https://scikit-learn.org/stable/modules/generated/sklearn.en...) - to detect anomalies. It extracts features like when it happened, how many of the logs are errors/warn. What is the log volume and error rate. Then it splits them into trees(forests). The earlier the split, the farther the anomaly. And scores these anomalies.

4. Generate a snapshot of the log clusters formed. Red dots describe the most anomalous log patterns. Clicking on it gives a few samples from that cluster.

Use cases: You can answer questions like "Have we seen this log before?". We stream a compact snapshot of the clusters formed to an endpoint of your choice. Your developer can write a cheap LLM pass to check if it needs to wake a developer at 3 a.m for this? Or just store them in Slack.

kvaranasi_··on Ask HN: Cheaper Datadog anyone?
Grafana sucks imo. Their UI is bad, it takes time to setup. It's very difficult to maintain it all together. There should be a free alternative. I'm surprised there is literally no free alternative to Datadog.
kvaranasi_··on Ask HN: Cheaper Datadog anyone?
APM, logs, metrics and alerting all on a single pane of glass.
kvaranasi_··on Ask HN: Moved to SF to build a startup. What next?
Got it. Yeah I'm building a monitoring tool for web applications. I guess I should start going to some conferences or something. Still figuring it out.
kvaranasi_··on Ask HN: Grafana or Datadog?
can you please email me at kaushik [at] rocketgraph.io
kvaranasi_··on Ask HN: Grafana or Datadog?
can you please email me at kaushik@rocketgraph.io
kvaranasi_··on Ask HN: Grafana or Datadog?
ok wow. I will check them out and start reaching out. Also any industries I should target with the current idea? Company size/position you have in mind?
kvaranasi_··on Ask HN: Grafana or Datadog?
Okay, I reached out to a few who are cursing DataDog, but also are not fully committed to buying what I'm building. How do I reach out to more people? I mean, it's like I KNOW there is some way here. Because they are not like "I'm happy with DataDog", but it's also not like "We're ready to abandon it for yours". I talked to ones paying like $40k/mo and $80k/mo(DHH).
kvaranasi_··on Ask HN: Grafana or Datadog?
Makes a lot of sense. So I am thinking of building an AI-powered Datadog alternative. Why now? is because with AI I can rapidly build integrations to Ruby, Python and other languages. But I'm really low-confidence on this one, because how do I make it reach a lot of people? Is there a need for this? Because I can make it really cheap.
kvaranasi_··on Ask HN: What are some preventive fault tolerance tools
What could be one such business domain?
kvaranasi_··on Ask HN: What do you think about CSV to Postgres?
Yeah. Needs to be more concrete.
kvaranasi_··on Ask HN: What do you think about CSV to Postgres?
Correct they come into CSV -> analytics. They don't care if we use Postgres or Mongo.
kvaranasi_··on Ask HN: What do you think about CSV to Postgres?
I think this is probably by using a COPY command. Assuming the file is on the same server as Postgres. But from a windows/linux machine, if a user wants to upload the CSV file, I don't see any options in the market.
kvaranasi_··on Ask HN: What do you think about CSV to Postgres?
Ok, but what if we create an analytics dashboard for them. Basically the user will upload a CSV and a dashboard with charts will be created. I too don't know the use case exactly. Just thinking loud here.
kvaranasi_··on PgLater: Asynchronous Postgres Queries
I just found out about this extension that runs your Pg Queries in the background and returns a job id. You can come back later and get results from that job id.
kvaranasi_··on There Is a Microsoft Excel World Championship [video]
At this point, anything is meh!
kvaranasi_··on WormGPT: Powerful AI chatbot designed to assist hackers with their hacking
lol. true. I was wondering the same.
kvaranasi_··on WormGPT: Powerful AI chatbot designed to assist hackers with their hacking
I'm still looking for ways in which this is better than ChatGPT. It says that it's different in the sense that it doesn't shy away from giving you malicious content that might otherwise be useful in harming someone or some system. Let me know how you found it different than the normal GPT.
kvaranasi_··on It's pretty simple to build a chatbot using OpenAI
Yes, follow the next article to see how to use those embeddings to query the model and generate a human friendly answer.
kvaranasi_··on It's pretty simple to build a chatbot using OpenAI
This is insane. You can use OpenAI's API to tokenise a large text, do a vector search and generate a formal answer using it's chat completion API.

It's in the following 2 links on the OpenAI website:

- https://cookbook.openai.com/examples/question_answering_usin... - https://cookbook.openai.com/examples/embedding_wikipedia_art...

I trained a chatbot on the Godfather script for example and asked Open AI to give the exact response to a dialogue in the film. I'll open-source that too pretty soon if you guys are interested.

kvaranasi_··on Install PgAudit on Your AWS RDS Postgres Instance
Hey HN,

I Previously wrote about Postgres and pgAudit in detail here: https://news.ycombinator.com/item?id=37247275 https://news.ycombinator.com/item?id=37082827

Since a lot of you are interested, I put together an article on how to install pgAudit on your own Postgres instance here: https://blog.rocketgraph.io/posts/install-pgaudit

Using pgAudit will help you debug your postgres instances better. Further you can add cloudwatch to query these logs in a timeframe.

kvaranasi_··on Hasura: Instant GraphQL on your Postgres data
Hasura GraphQLises your Postgres data so you can query/subscribe to your database directly from the frontend.
kvaranasi_··on Show HN: I built this Postgres logger
Sort of. I created this page to just show what can be done with pgAudit. But what I do at Rocketgraph is more. I provide Authentication, Postgres and GraphQl console. Postgres logger is an extension for demo purposes. In the future I plan to add slack alerts when a developer DROP's a database accidentally. And much more. Configuring AWS RDS is a pain.

I wrote about it here: https://blog.rocketgraph.io/posts/install-pgaudit

That's why I automated the process. Now every project comes with Postgres and pgAudit configured, Authentication, GraphQL and front-end SDKs right out of the box so it will be easier to develop web applications.

kvaranasi_··on Show HN: I built this Postgres logger
Ok, yes this makes sense.
kvaranasi_··on Show HN: I built this Postgres logger
Postgres is one of the most amazing inventions that exit truly.
kvaranasi_··on Show HN: I built this Postgres logger
This is great. I plan on providing Postgres trigger templates that developers can easily load on Rocketgraph.
Page 1 of 2Next →