explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y0Nx

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=6,183,394.01..6,183,394.13 rows=47 width=206) (actual rows= loops=)

  • Sort Key: ev.value, ev.name, f.account_id, (CASE ad_column_identifier(''::character varying, (''::character varying), 'en_US'::character varying) WHEN '**'::text THEN ''::character varying ELSE ad_colu
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,182,625.32..6,183,392.70 rows=47 width=206) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=6,182,624.91..6,182,626.54 rows=93 width=52) (actual rows= loops=)

  • Filter: ((sum(CASE WHEN ((f.dateacct < '2019-01-01 00:00:00'::timestamp without time zone) OR ((f.dateacct = '2019-01-01 00:00:00'::timestamp without time zone) AND ((f.factaccttype)::text
4. 0.000 0.000 ↓ 0.0

Seq Scan on fact_acct f (cost=0.00..5,131,302.70 rows=14,500,996 width=52) (actual rows= loops=)

  • Filter: (((ad_client_id)::text = ANY ('{0,E8CB1F6B0B244CA1A8B461979EA1D539}'::text[])) AND (dateacct < '2019-01-27 00:00:00'::timestamp without time zone) AND ((c_acctschema_id)::text
5. 0.000 0.000 ↓ 0.0

Index Scan using c_elementvalue_key on c_elementvalue ev (cost=0.41..7.96 rows=1 width=78) (actual rows= loops=)

  • Index Cond: ((c_elementvalue_id)::text = (f.account_id)::text)
  • Filter: (((value)::text <= 'T10002'::text) AND ((elementlevel)::text = 'S'::text))