explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GiG2

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

XN HashAggregate (cost=13,723,333,771,126.56..13,723,334,171,126.56 rows=8,000,000 width=38) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Hash Left Join DS_BCAST_INNER (cost=168,608.33..13,613,768,618,407.20 rows=5,478,257,635,968 width=38) (actual rows= loops=)

  • Hash Cond: ("outer".jobkey = "inner".jobkey)
3. 0.000 0.000 ↓ 0.0

XN Hash Left Join DS_BCAST_INNER (cost=125,558.11..11,636,768,642,078.50 rows=318,131,858 width=32) (actual rows= loops=)

  • Hash Cond: (("outer".aid = ("inner".aid)::integer) AND ("outer".cid = ("inner".cid)::integer) AND ("outer".gg_platform = "inner".gg_platform) AND (("outer".hash)::text = ("inner".hash)::text))
  • Join Filter: ("inner".jid < "outer".jid)
4. 0.000 0.000 ↓ 0.0

XN Hash Right Join DS_DIST_OUTER (cost=51,660.25..1,318,666,409,181.95 rows=318,131,858 width=148) (actual rows= loops=)

  • Outer Dist Key: exh.jid
  • Hash Cond: (("outer".gg_platform = "inner".gg_platform) AND ("outer".jid = "inner".jid))
5. 0.000 0.000 ↓ 0.0

XN Seq Scan on "#exhash" exh (cost=0.00..36,948.93 rows=3,694,893 width=132) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Hash (cost=34,440.17..34,440.17 rows=3,444,017 width=26) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

XN Seq Scan on "#newtx" tx (cost=0.00..34,440.17 rows=3,444,017 width=26) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

XN Hash (cost=36,948.93..36,948.93 rows=3,694,893 width=144) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

XN Seq Scan on "#exhash_uq" exuq (cost=0.00..36,948.93 rows=3,694,893 width=144) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

XN Hash (cost=34,440.17..34,440.17 rows=3,444,017 width=14) (actual rows= loops=)

  • -> XN Seq Scan on "#tsco_dups" tsco (cost=0.00..34440.17 rows=3,444,017 width=14)----- Tables missing statistics: #tsco_dups, #exhash_uq, #newtx, #exhash ---------- Update statistics by running the ANALYZE command on these tables -----