NotificationsYou must be signed in to change notification settings
Fork3
Star76

Commite59fbbd

committed

Added explicit definition of si alias in metrics related to indexes

1 parente9f2c31 commite59fbbdCopy full SHA for e59fbbd

File tree

1 file changed

-5

lines changed

config/pgwatch-prometheus
- metrics.yml

1 file changed

-5

lines changed

`‎config/pgwatch-prometheus/metrics.yml‎`

Lines changed: 5 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -1465,7 +1465,7 @@ metrics:`
`1465`	`1465`	`join pg_class cr on cr.oid = i.indrelid and cr.relkind = 'r'`
`1466`	`1466`	`join pg_namespace n on n.oid = ci.relnamespace`
`1467`	`1467`	`join pg_constraint cn on cn.conrelid = cr.oid`
`1468`		`- left join pg_stat_user_indexes si on si.indexrelid = i.indexrelid`
	`1468`	`+ left join pg_stat_user_indexesassi on si.indexrelid = i.indexrelid`
`1469`	`1469`	`where`
`1470`	`1470`	`contype = 'f'`
`1471`	`1471`	`and i.indisunique isfalse`
`@@ -1620,7 +1620,7 @@ metrics:`
`1620`	`1620`	`join pg_class cr on cr.oid = i.indrelid and cr.relkind = 'r'`
`1621`	`1621`	`join pg_namespace n on n.oid = ci.relnamespace`
`1622`	`1622`	`join pg_constraint cn on cn.conrelid = cr.oid`
`1623`		`- left join pg_stat_user_indexes si on si.indexrelid = i.indexrelid`
	`1623`	`+ left join pg_stat_user_indexesassi on si.indexrelid = i.indexrelid`
`1624`	`1624`	`where`
`1625`	`1625`	`contype = 'f'`
`1626`	`1626`	`and i.indisunique isfalse`
`@@ -1653,7 +1653,7 @@ metrics:`
`1653`	`1653`	`join pg_class cr on cr.oid = i.indrelid and cr.relkind = 'r'`
`1654`	`1654`	`join pg_namespace n on n.oid = ci.relnamespace`
`1655`	`1655`	`join pg_am a ON ci.relam = a.oid`
`1656`		`- left join pg_stat_user_indexes si on si.indexrelid = i.indexrelid`
	`1656`	`+ left join pg_stat_user_indexesassi on si.indexrelid = i.indexrelid`
`1657`	`1657`	`where`
`1658`	`1658`	`i.indisunique =false`
`1659`	`1659`	`and i.indisvalid =true`
`@@ -1732,7 +1732,7 @@ metrics:`
`1732`	`1732`	`join pg_class cr on cr.oid = i.indrelid and cr.relkind = 'r'`
`1733`	`1733`	`join pg_namespace n on n.oid = ci.relnamespace`
`1734`	`1734`	`join pg_constraint cn on cn.conrelid = cr.oid`
`1735`		`- left join pg_stat_user_indexes si on si.indexrelid = i.indexrelid`
	`1735`	`+ left join pg_stat_user_indexesassi on si.indexrelid = i.indexrelid`
`1736`	`1736`	`where`
`1737`	`1737`	`contype = 'f'`
`1738`	`1738`	`and i.indisunique isfalse`
`@@ -1767,7 +1767,7 @@ metrics:`
`1767`	`1767`	`join pg_class cr on cr.oid = i.indrelid and cr.relkind = 'r'`
`1768`	`1768`	`join pg_namespace n on n.oid = ci.relnamespace`
`1769`	`1769`	`join pg_am a ON ci.relam = a.oid`
`1770`		`- left join pg_stat_user_indexes si on si.indexrelid = i.indexrelid`
	`1770`	`+ left join pg_stat_user_indexesassi on si.indexrelid = i.indexrelid`
`1771`	`1771`	`where`
`1772`	`1772`	`i.indisunique =false`
`1773`	`1773`	`and i.indisvalid =true`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commite59fbbd

File tree

1 file changed

1 file changed

`‎config/pgwatch-prometheus/metrics.yml‎`

0 commit comments