explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SlT

Settings
# exclusive inclusive rows x rows loops node
1. 0.047 0.047 ↑ 34.0 1 1

Seq Scan on integration_config ic (cost=0.00..5.32 rows=34 width=338) (actual time=0.042..0.047 rows=1 loops=1)

  • Filter: (((status)::text = 'ACTIVE'::text) AND (((integration_secrets ->> 'bofaReportingApiRefreshExpire'::text))::date <= '2025-12-29'::date))
  • Rows Removed by Filter: 102