Live Queries

            SELECT a.attname, format_type(a.atttypid, a.atttypmod), pg_get_expr(d.adbin, d.adrelid), a.attnotnull
              FROM pg_attribute a LEFT JOIN pg_attrdef d
                ON a.attrelid = d.adrelid AND a.attnum = d.adnum
             WHERE a.attrelid = '"snapshot_content_details"'::regclass
               AND a.attnum > 0 AND NOT a.attisdropped
             ORDER BY a.attnum

WITH query_stats AS ( SELECT query_hash AS query_hash, pghero_query_stats.user AS user, array_agg(LEFT(query, 10000) ORDER BY REPLACE(LEFT(query, 1000), '?', '!') COLLATE "C" ASC) AS query, (SUM(total_time) / 1000 / 60) AS total_minutes, (SUM(total_time) / SUM(calls)) AS average_time, SUM(calls) AS calls FROM pghero_query_stats WHERE database = 'primary' AND query_hash IS NOT NULL AND captured_at >= '2025-12-06 01:55:41.382500' GROUP BY 1, 2 ) SELECT query_hash, query_stats.user, query[1] AS query, query[array_length(query, 1)] AS explainable_query, total_minutes, average_time, calls, total_minutes * 100.0 / (SELECT SUM(total_minutes) FROM query_stats) AS total_percent, (SELECT SUM(total_minutes) FROM query_stats) AS all_queries_total_minutes FROM query_stats ORDER BY "total_minutes" DESC LIMIT 100 /*pghero*/

SELECT ltrd.id as detail_id,lab_test_results.id as result_id,lab_test_results.service_unit_id,s.id as service_id, s.name as service_name,sp.name as specimen_name,sp.id as specimen_id,ltr.patient_id as patientid,ltr.id as ltrid,ltr.*,ltrd.*,lab_test_results.status as bbtr_status,lts.extid as lextid, ltrd.status as ltrd_status,s.report_type,ltr.location_id as location_id FROM "lab_test_results" inner join lab_test_request_details as ltrd on ltrd.id = lab_test_results.lab_test_request_detail_id
        inner join lab_test_requests as ltr on ltr.id = ltrd.lab_test_request_id
        inner join lab_test_specimens as lts on lts.lab_test_request_detail_id = ltrd.id
        inner join services as s on s.id = ltrd.service_id
        inner join specimens as sp on sp.id = ltrd.specimen_id
        inner join service_units as su on su.id = lab_test_results.service_unit_id WHERE (su.apk_code != '' and ltrd.specimen_recieved = 'Received' and lab_test_results.apk_status is null and ltr.location_id=25 and ltr.id = '260931' a

SELECT     "employees".* FROM       "employees"  WHERE     ("employees"."personnel_id" = 7122) LIMIT 1