explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QASb

Settings
# exclusive inclusive rows x rows loops node
1. 1,416.606 31,996.580 ↑ 1.0 1 1

Aggregate (cost=1,240,732.20..1,240,732.21 rows=1 width=8) (actual time=31,996.580..31,996.580 rows=1 loops=1)

2. 814.635 30,579.974 ↓ 1.0 3,720,745 1

Nested Loop (cost=68,821.86..1,222,355.62 rows=3,675,316 width=8) (actual time=996.092..30,579.974 rows=3,720,745 loops=1)

3. 0.090 0.090 ↑ 1.0 1 1

Index Only Scan using c_elementvalue_pkey on c_elementvalue ev (cost=0.28..8.29 rows=1 width=5) (actual time=0.081..0.090 rows=1 loops=1)

  • Index Cond: (c_elementvalue_id = '1000034'::numeric)
  • Heap Fetches: 1
4. 28,779.783 29,765.249 ↓ 1.0 3,720,745 1

Bitmap Heap Scan on fact_acct fa (cost=68,821.59..1,185,594.16 rows=3,675,316 width=15) (actual time=996.003..29,765.249 rows=3,720,745 loops=1)

  • Recheck Cond: (account_id = '1000034'::numeric)
  • Rows Removed by Index Recheck: 23,982,378
  • Filter: ((c_acctschema_id = '1000000'::numeric) AND (ad_client_id = '1000000'::numeric) AND (dateacct < to_timestamp('2020-07-23 23:59:59.0'::text, 'YYYY-MM-DD HH24:MI:SS'::text)))
  • Rows Removed by Filter: 3,945
  • Heap Blocks: exact=35,304 lossy=842,850
5. 985.466 985.466 ↓ 1.0 3,724,690 1

Bitmap Index Scan on factaccountid (cost=0.00..67,902.76 rows=3,676,559 width=0) (actual time=985.466..985.466 rows=3,724,690 loops=1)

  • Index Cond: (account_id = '1000034'::numeric)