explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YEeF

Settings
# exclusive inclusive rows x rows loops node
1. 64.712 601.613 ↑ 1.0 1 1

Aggregate (cost=34,752.75..34,752.75 rows=1 width=8) (actual time=601.613..601.613 rows=1 loops=1)

2. 57.931 536.901 ↑ 1.0 1,004,389 1

Append (cost=0.00..31,237.39 rows=1,004,389 width=116) (actual time=0.017..536.901 rows=1,004,389 loops=1)

3. 72.763 72.763 ↑ 1.0 152,046 1

Seq Scan on productcharge__c pc (cost=0.00..6,918.16 rows=152,046 width=67) (actual time=0.017..72.763 rows=152,046 loops=1)

4. 82.235 406.207 ↑ 1.0 852,343 1

Subquery Scan on *SELECT* 2 (cost=0.00..23,863.09 rows=852,343 width=116) (actual time=0.021..406.207 rows=852,343 loops=1)

5. 323.972 323.972 ↑ 1.0 852,343 1

Seq Scan on "Fact_ProductCharges_History" (cost=0.00..21,306.06 rows=852,343 width=116) (actual time=0.020..323.972 rows=852,343 loops=1)