explain.depesz.com

PostgreSQL's explain analyze made readable

Result: foGg

Settings
# exclusive inclusive rows x rows loops node
1. 7,835.603 15,282.014 ↓ 2.1 127 1

HashAggregate (cost=2,711,245.58..2,711,246.19 rows=61 width=52) (actual time=15,281.958..15,282.014 rows=127 loops=1)

2. 7,446.411 7,446.411 ↑ 1.2 5,287,141 1

Seq Scan on fact_acct f (cost=0.00..2,474,470.70 rows=6,313,997 width=52) (actual time=0.007..7,446.411 rows=5,287,141 loops=1)

  • Filter: ((dateacct < '2018-11-01 00:00:00'::timestamp without time zone) AND ((c_acctschema_id)::text = '0DCC39FCD8DC47159ED82C3F74ECA5CD'::text) AND (isactive = 'Y'::bpchar))
  • Rows Removed by Filter: 5743670