explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qyAoT : Optimization for: plan #wCph

Settings

Optimization path:

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

Update on factuphiststmtfinancial (cost=4,405.80..1,505,478,477.92 rows=1 width=510) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4,405.80..1,505,478,477.92 rows=1 width=510) (actual rows= loops=)

  • Join Filter: (((factuphiststmtfinancial.entityid)::text = (d.entityid)::text) AND (factuphiststmtfinancial.statementdatekey_ = d.statementdatekey_))
3. 0.000 0.000 ↓ 0.0

Seq Scan on tempmaxstatement d (cost=0.00..1,988.32 rows=83,232 width=42) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=4,405.80..1,504,927,367.42 rows=377 width=539) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,405.80..1,504,927,365.54 rows=377 width=539) (actual rows= loops=)

  • Hash Cond: (factuphiststmtfinancial.statementdatekey_ = ANY_subquery.statementdatekey_)
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,202.90..1,504,925,158.26 rows=1,657 width=507) (actual rows= loops=)

  • Hash Cond: ((factuphiststmtfinancial.entityid)::text = (ANY_subquery_1.entityid)::text)
7. 0.000 0.000 ↓ 0.0

Seq Scan on factuphiststmtfinancial (cost=0.00..1,504,921,713.66 rows=472,996 width=419) (actual rows= loops=)

  • Filter: (NOT (SubPlan 1))
8.          

SubPlan (for Seq Scan)

9. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..2,973.48 rows=83,232 width=32) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on tempmaxstatement tempmaxstatement_2 (cost=0.00..1,988.32 rows=83,232 width=32) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=2,200.40..2,200.40 rows=200 width=88) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery_1 (cost=2,196.40..2,200.40 rows=200 width=88) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,196.40..2,198.40 rows=200 width=32) (actual rows= loops=)

  • Group Key: tempmaxstatement.entityid
14. 0.000 0.000 ↓ 0.0

Seq Scan on tempmaxstatement (cost=0.00..1,988.32 rows=83,232 width=32) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=2,200.40..2,200.40 rows=200 width=32) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery (cost=2,196.40..2,200.40 rows=200 width=32) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,196.40..2,198.40 rows=200 width=4) (actual rows= loops=)

  • Group Key: tempmaxstatement_1.statementdatekey_
18. 0.000 0.000 ↓ 0.0

Seq Scan on tempmaxstatement tempmaxstatement_1 (cost=0.00..1,988.32 rows=83,232 width=4) (actual rows= loops=)