explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ts5t

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

HashAggregate (cost=579,585.59..579,605.48 rows=1,326 width=40) (actual rows= loops=)

  • Group Key: c.itemid
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=118.92..533,303.24 rows=3,702,588 width=16) (actual rows= loops=)

  • Hash Cond: ((z.filingid)::numeric = enyse_tt_tmpprior12filings.filingid)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=101.67..422,208.36 rows=7,405,175 width=24) (actual rows= loops=)

  • Hash Cond: (z.itemid = c.itemid)
4. 0.000 0.000 ↓ 0.0

Seq Scan on filingitem z (cost=0.00..305,269.96 rows=11,409,330 width=24) (actual rows= loops=)

  • Filter: ((itemvalue IS NOT NULL) AND (((SubPlan 1))[1] IS NOT NULL))
5.          

SubPlan (forSeq Scan)

6. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=85.09..85.09 rows=1,326 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on item c (cost=0.00..85.09 rows=1,326 width=8) (actual rows= loops=)

  • Filter: (itemtypecode = ANY ('{NUM,PCT,ABS}'::bpchar[]))
9. 0.000 0.000 ↓ 0.0

Hash (cost=14.75..14.75 rows=200 width=32) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

HashAggregate (cost=12.75..14.75 rows=200 width=32) (actual rows= loops=)

  • Group Key: enyse_tt_tmpprior12filings.filingid
11. 0.000 0.000 ↓ 0.0

Function Scan on enyse_tt_tmpprior12filings (cost=0.25..10.25 rows=1,000 width=32) (actual rows= loops=)