explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QSjD

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.063 ↑ 3.0 1 1

Hash Join (cost=10.14..15.56 rows=3 width=338) (actual time=0.058..0.063 rows=1 loops=1)

  • Hash Cond: ((ic.integration_id)::text = (i.id)::text)
2. 0.045 0.045 ↑ 34.0 1 1

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

  • Filter: (((status)::text = 'ACTIVE'::text) AND (((integration_secrets ->> 'bofaReportingApiRefreshExpire'::text))::date <= '2025-12-29'::date))
  • Rows Removed by Filter: 102
3. 0.002 0.011 ↑ 1.0 1 1

Hash (cost=10.12..10.12 rows=1 width=516) (actual time=0.011..0.011 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
4. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on integration i (cost=0.00..10.12 rows=1 width=516) (actual time=0.009..0.009 rows=1 loops=1)

  • Filter: ((name)::text = 'BofA API'::text)
  • Rows Removed by Filter: 29