explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ECvN

Settings
# exclusive inclusive rows x rows loops node
1. 2,406.372 2,406.372 ↓ 203.0 203 1

Seq Scan on "DossierCacheEntries" j (cost=0.00..4,768.68 rows=1 width=61) (actual time=594.898..2,406.372 rows=203 loops=1)

  • Filter: ("IsLatest" AND (("DossierJson" ->> 'dossierNumber'::text) ~~ 'GMPMessage%'::text) AND (("DossierJson" ->> 'entityStatus'::text) = 'Active'::text) AND (((("DossierJson" -> 'dataObject'::text) -> 'jsonData'::text) ->> 'assets'::text) ~~ '%reportedby%mprofileId%d5b71cc9-40eb-480c-a14a-259859292fb7%'::text) AND (((("DossierJson" -> 'dataObject'::text) -> 'jsonData'::text) ->> 'assets'::text) ~~ '%reportedfor%mprofileId%d5b71cc9-40eb-480c-a14a-259859292fb7%'::text))
  • Rows Removed by Filter: 84039