explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QqdB

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=2,675.10..2,675.11 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Append (cost=25.29..2,671.46 rows=1,459 width=0) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on uphiststmtfinancials (cost=25.29..2,647.72 rows=1,457 width=0) (actual rows= loops=)

  • Recheck Cond: (jsondoc_ @> '{"FinancialTemplate": "MMAS"}'::jsonb)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_uphiststmtfinancials (cost=0.00..24.93 rows=1,457 width=0) (actual rows= loops=)

  • Index Cond: (jsondoc_ @> '{"FinancialTemplate": "MMAS"}'::jsonb)
5. 0.000 0.000 ↓ 0.0

Seq Scan on uphiststmtfinancialshist (cost=0.00..1.44 rows=1 width=0) (actual rows= loops=)

  • Filter: (jsondoc_ @> '{"FinancialTemplate": "MMAS"}'::jsonb)
6. 0.000 0.000 ↓ 0.0

Seq Scan on uphiststmtfinancialsarch (cost=0.00..15.00 rows=1 width=0) (actual rows= loops=)