# Great Expectations only returns partial failed rows (20)

**URL:** <https://discourse.greatexpectations.io/t/great-expectations-only-returns-partial-failed-rows-20/2325>\
**Category:** GX Core Support\
**Created:** [January 21, 2026, 7:53am UTC](https://discourse.greatexpectations.io/t/great-expectations-only-returns-partial-failed-rows-20/2325 "2026-01-21T07:53:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rishabh-o-97](https://avatars.discourse-cdn.com/v4/letter/r/9dc877/32.png) [@rishabh-o-97](https://discourse.greatexpectations.io/u/rishabh-o-97)\
**Post date:** [January 21, 2026, 7:53am UTC](https://discourse.greatexpectations.io/t/great-expectations-only-returns-partial-failed-rows-20/2325/1 "2026-01-21T07:53:29Z")

</div>

Hello  
We are using Gx to run our data quality checks with result format set to “COMPLETE”. But still we only are receiving 20 records in the unexpected\_index\_list param.

Version: 1.10.0  
Data Source: SQL - Postgres  
Expectation we are using: ExpectColumnValuesToBeUnique

`result_format = {`  
` "result_format": "COMPLETE",`  
` "unexpected_index_query": True,`  
` "unexpected_index_column_names”: [“primary_key_column”]`  
`}`

Similar to this open ticket here: [Great expectation is only returning 20 rows of failed records](https://discourse.greatexpectations.io/t/great-expectation-is-only-returning-20-rows-of-failed-records/1991)

Can you please tell us what am I doing wrong here.  
Why does it not return all the rows that have failed and just 20 ?

Thank You