explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BKuJ

Settings
# exclusive inclusive rows x rows loops node
1. 65.804 569.575 ↑ 1.0 1 1

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

2. 57.942 503.771 ↑ 1.0 1,004,389 1

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

3. 55.958 55.958 ↑ 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.008..55.958 rows=152,046 loops=1)

4. 82.377 389.871 ↑ 1.0 852,343 1

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

5. 307.494 307.494 ↑ 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.009..307.494 rows=852,343 loops=1)