explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bKzS

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.027 ↑ 1.0 1 1

Aggregate (cost=6,990.48..6,990.49 rows=1 width=64) (actual time=0.027..0.027 rows=1 loops=1)

2. 0.001 0.023 ↓ 0.0 0 1

Nested Loop (cost=0.72..6,990.47 rows=1 width=8) (actual time=0.023..0.023 rows=0 loops=1)

3. 0.022 0.022 ↓ 0.0 0 1

Index Scan using factaccountid on fact_acct fa (cost=0.43..6,982.16 rows=1 width=15) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (account_id = '1000034'::numeric)
  • Filter: ((c_acctschema_id = '1000000'::numeric) AND (ad_client_id = '1000046'::numeric) AND (dateacct < to_timestamp('2020-08-01 00:00:00.0'::text, 'YYYY-MM-DD HH24:MI:SS'::text)))
4. 0.000 0.000 ↓ 0.0 0

Index Only Scan using c_elementvalue_pkey on c_elementvalue ev (cost=0.29..8.30 rows=1 width=6) (never executed)

  • Index Cond: (c_elementvalue_id = '1000034'::numeric)
  • Heap Fetches: 0