-
Notifications
You must be signed in to change notification settings - Fork 2
/
ql -d postgres
17 lines (16 loc) · 1.92 KB
/
ql -d postgres
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
pid | state | usename | query
---------+-------+---------+-------------------------------------------------------------------------------------------------------------
2261401 | idle | root | SELECT "active_storage_blobs".* FROM "active_storage_blobs" WHERE "active_storage_blobs"."id" = $1 LIMIT $2
1501693 | idle | root | SELECT a.attname +
| | | FROM ( +
| | | SELECT indrelid, indkey, generate_subscripts(indkey, 1) idx +
| | | FROM pg_index +
| | | WHERE indrelid = '"events"'::regclass +
| | | AND indisprimary +
| | | ) i +
| | | JOIN pg_attribute a +
| | | ON a.attrelid = i.indrelid +
| | | AND a.attnum = i.indkey[i.idx] +
| | | ORDER BY i.idx +
| | |
(2 rows)