>smrdbprod=# select count(*) from smrr_mgr.formula where crart_id = 21507180000 and chemin = '@';
> count
>-------
> 1
>(1 row)
>
>smrdbprod=# select crart_id, chemin, count(*) from smrr_mgr.formula group by crart_id, chemin having count(*) > 1;
> crart_id | chemin | count
>----------+--------+-------
>(0 rows)
Small update:
smrdbprod=# set enable_indexscan to off;
SET
smrdbprod=# select crart_id, chemin, count(*) from smrr_mgr.formula group by crart_id, chemin having count(*) > 1;
crart_id | chemin | count
-------------+--------+-------
35054630000 | @ | 2
4737310000 | @ | 2
10632380000 | @ | 2
14680880000 | @ | 2
4627230000 | @ | 2
10993780000 | @ | 2
....
I think I know what I have to do.
