PgHero

Live Queries

2 queries

Pid Duration State
2799264 0.4 s idle in transaction
erps2
SELECT     "ip_supplementary_bills".* FROM       "ip_supplementary_bills"  WHERE     ("ip_supplementary_bills".inpatient_detail_id = 355664) ORDER BY  id desc LIMIT 1
2784310 -0.0 s active
cims1
            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 = '"menu_contexts_menu_lists"'::regclass
               AND a.attnum > 0 AND NOT a.attisdropped
             ORDER BY a.attnum

You may need to restart your app servers afterwards.