Abstract: One method of identifying resource intensive queries involves receiving queries from at least one database server into an ingestion pipeline within a computing device, wherein keywords are extracted from the queries at multiple intervals; applying tokenization in the ingestion pipeline to remove uninformative terms; detecting at least one query from the received set of queries that are resource intensive at a fleet level, individual server level, or user level based on the keywords and using an enrichment analysis module, wherein the at least one query detected to be resource intensive is given a drill-down analysis to capture insights from execution profiles; and providing alerts based on the at least one query detected to be resource intensive.