>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.
