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 |
1 min
24%
|
28 ms
|
1,991
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
2%
|
40 ms
|
121
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*/
|