explain.depesz.com

PostgreSQL's explain analyze made readable

Result: onQ9

Settings
# exclusive inclusive rows x rows loops node
1. 654.196 94,230.792 ↑ 1.0 1 1

Aggregate (cost=1,366,465.51..1,366,465.52 rows=1 width=8) (actual time=94,230.792..94,230.792 rows=1 loops=1)

2. 229.816 93,576.596 ↓ 1.5 2,065,675 1

Nested Loop (cost=52,092.70..1,359,789.62 rows=1,335,176 width=8) (actual time=5,984.025..93,576.596 rows=2,065,675 loops=1)

3. 2.473 2.473 ↑ 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=2.467..2.473 rows=1 loops=1)

  • Index Cond: (c_elementvalue_id = '1000055'::numeric)
  • Heap Fetches: 1
4. 87,470.241 93,344.307 ↓ 1.5 2,065,675 1

Bitmap Heap Scan on fact_acct fa (cost=52,092.43..1,346,429.57 rows=1,335,176 width=15) (actual time=5,981.527..93,344.307 rows=2,065,675 loops=1)

  • Recheck Cond: ((ad_client_id = '1000000'::numeric) AND (ad_org_id = ANY ('{0,1000000,1000038,1000001,1000002,1000003,1000004,1000005,1000006,1000007,1000008,1000009,1000010,1000013,1000014,1000015,1000016,1000017,1000018,1000019,1000021,1000022,1000023,1000024,1000025,1000026,1000027,1000028,1000029,1000030,1000031,1000032,1000033,1000034,1000035,1000036,1000037,1000050,1000051,1000052,1000020}'::numeric[])) AND (c_acctschema_id = '1000000'::numeric) AND (account_id = '1000055'::numeric))
  • Rows Removed by Index Recheck: 14,950,100
  • Filter: (dateacct < '2020-07-23'::date)
  • Rows Removed by Filter: 6,030
  • Heap Blocks: exact=298,939 lossy=509,315
5. 5,874.066 5,874.066 ↓ 1.6 2,073,151 1

Bitmap Index Scan on fact_acct_account (cost=0.00..51,758.64 rows=1,335,706 width=0) (actual time=5,874.066..5,874.066 rows=2,073,151 loops=1)

  • Index Cond: ((ad_client_id = '1000000'::numeric) AND (ad_org_id = ANY ('{0,1000000,1000038,1000001,1000002,1000003,1000004,1000005,1000006,1000007,1000008,1000009,1000010,1000013,1000014,1000015,1000016,1000017,1000018,1000019,1000021,1000022,1000023,1000024,1000025,1000026,1000027,1000028,1000029,1000030,1000031,1000032,1000033,1000034,1000035,1000036,1000037,1000050,1000051,1000052,1000020}'::numeric[])) AND (c_acctschema_id = '1000000'::numeric) AND (account_id = '1000055'::numeric))