GSC Indexing Issues

I would like to know why my blog with 1000 blog posts has only indexed 196 posts only, anyone with knowledge about GSC and how it index a site…

Welcome to the forums, @bwiresantoes.

The first thing to note is that Google does not guarantee to index every page.

I suggest you take time to read the comprehensive guidelines Google provides, and follow all the advice given there, to give your site the best chance of being indexed and appearing in search results.