Slow Queries
Slow queries take 20 ms or more on average and have been called at least 100 times.
Explain queries to see where to add indexes.
Total Time |
Average Time |
Calls |
3 min
36%
|
39 ms
|
4,704
pghero
·
details
|
SELECT n.nspname AS schema, c.relname AS relation, CASE WHEN c.relkind = $1 THEN $2 ELSE $3 END AS type, pg_table_size(c.oid) AS size_bytes FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname NOT IN ($4, $5) AND n.nspname !~ $6 AND c.relkind IN ($7, $8) ORDER BY pg_table_size(c.oid) DESC, 2 ASC /*pghero*/
|
1 min
12%
|
21 ms
|
2,777
parasapp
·
details
|
SELECT itd.* FROM "inv_tran_details" as itd inner join inventory_transactions as it on it.id = itd.inventory_transaction_id inner join item_with_details as iwd on itd.item_with_detail_id = iwd.id WHERE (it.reference2 = $1 and iwd.item_id = $2) ORDER BY it.id desc LIMIT $3
|
0 min
1%
|
54 ms
|
103
parasapp
·
details
|
SELECT id,name,rc_code,item_subtype_id FROM "items" WHERE ("items"."is_consignment" = $1) AND (id in(select iwd.item_id from inventory_statuses as iss inner join item_with_details as iwd on iss.item_with_detail_id=iwd.id where iss.quantity > $2 and iss.inventory_head_id=$3 and iss.flag=$4 and (iwd.expiry_date >= $5 or iwd.expiry_date is null)) and is_asset = $6 and is_consignment = $7 and status = $8) ORDER BY name, lower(name)
|