explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k48L

Settings
# exclusive inclusive rows x rows loops node
1. 187.604 42,764.992 ↑ 1.0 1 1

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

2. 177.414 42,577.388 ↓ 942.9 1,375,720 1

Append (cost=25.29..2,671.46 rows=1,459 width=0) (actual time=149.469..42,577.388 rows=1,375,720 loops=1)

3. 42,254.495 42,397.131 ↓ 944.2 1,375,683 1

Bitmap Heap Scan on uphiststmtfinancials (cost=25.29..2,647.72 rows=1,457 width=0) (actual time=149.468..42,397.131 rows=1,375,683 loops=1)

  • Recheck Cond: (jsondoc_ @> '{"FinancialTemplate": "MMAS"}'::jsonb)
  • Heap Blocks: exact=40,561
4. 142.636 142.636 ↓ 944.2 1,375,683 1

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

  • Index Cond: (jsondoc_ @> '{"FinancialTemplate": "MMAS"}'::jsonb)
5. 2.839 2.839 ↓ 37.0 37 1

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

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

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

  • Filter: (jsondoc_ @> '{"FinancialTemplate": "MMAS"}'::jsonb)