SELECT to_char(fi.data,'yyyy/mm') as Mês, count(fi.*) as valor
  FROM financeiro fi
  WHERE fi.status = '1'
  GROUP BY Mês
  ORDER BY Mês;

select to_char(d.data,'yyyy/mm') as Mês, count(fi.*) as valor
from
    financeiro fi
    right join
    generate_series(
        '2016-01-01'::date, '2016-12-01, '1 month'
    ) gs (d) on d = date_trunc('month', fi.data)
where fi.status = '1'
group by mês
order by mês;

nvl(fi.valor,0)

WITH consulta AS (
SELECT to_char(fi.data,'yyyy/mm') as Mes, count(fi.*) as valor
FROM financeiro fi
WHERE fi.status = '1'
GROUP BY Mês
ORDER BY Mês;
)
SELECT mes,
CASE WHEN valor IS NULL THEN '0'
ELSE valor
END
FROM consulta