explain.depesz.com

PostgreSQL's explain analyze made readable

Result: giXU

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 2.612 ↑ 1.0 1 1

Aggregate (cost=11,181.73..11,181.74 rows=1 width=64) (actual time=2.612..2.612 rows=1 loops=1)

2. 0.007 2.606 ↓ 0.0 0 1

Nested Loop (cost=0.84..11,166.54 rows=3,036 width=8) (actual time=2.606..2.606 rows=0 loops=1)

3. 0.939 0.939 ↑ 1.0 1 1

Index Only Scan using c_elementvalue_pkey on c_elementvalue ev (cost=0.29..8.30 rows=1 width=6) (actual time=0.937..0.939 rows=1 loops=1)

  • Index Cond: (c_elementvalue_id = '1004776'::numeric)
  • Heap Fetches: 1
4. 1.660 1.660 ↓ 0.0 0 1

Index Scan using fact_acct_account on fact_acct fa (cost=0.56..11,127.88 rows=3,036 width=15) (actual time=1.660..1.660 rows=0 loops=1)

  • Index Cond: ((ad_client_id = '1000046'::numeric) AND (ad_org_id = ANY ('{0,1000067}'::numeric[])) AND (c_acctschema_id = '1000042'::numeric) AND (account_id = '1004776'::numeric))
  • Filter: (dateacct < to_timestamp('2020-08-01 00:00:00.0'::text, 'YYYY-MM-DD HH24:MI:SS'::text))