explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6EZT

Settings
# exclusive inclusive rows x rows loops node
1. 1,278.140 245,913.821 ↑ 1.0 1 1

Aggregate (cost=1,447,764.72..1,447,764.73 rows=1 width=8) (actual time=245,913.821..245,913.821 rows=1 loops=1)

2. 366.564 244,635.681 ↓ 1.6 3,721,224 1

Nested Loop (cost=93,641.21..1,435,822.67 rows=2,388,408 width=8) (actual time=17,274.954..244,635.681 rows=3,721,224 loops=1)

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

  • Index Cond: (c_elementvalue_id = '1000034'::numeric)
  • Heap Fetches: 1
4. 227,116.753 244,269.109 ↓ 1.6 3,721,224 1

Bitmap Heap Scan on fact_acct fa (cost=93,640.94..1,411,930.30 rows=2,388,408 width=15) (actual time=17,274.937..244,269.109 rows=3,721,224 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 = '1000034'::numeric))
  • Rows Removed by Index Recheck: 18,253,912
  • Filter: (dateacct < to_timestamp('2020-07-23 23:59:59.0'::text, 'YYYY-MM-DD HH24:MI:SS'::text))
  • Rows Removed by Filter: 7,893
  • Heap Blocks: exact=236,150 lossy=677,636
5. 17,152.356 17,152.356 ↓ 1.6 3,730,982 1

Bitmap Index Scan on fact_acct_account (cost=0.00..93,043.83 rows=2,388,588 width=0) (actual time=17,152.356..17,152.356 rows=3,730,982 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 = '1000034'::numeric))