explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pOP : before index

Settings
# exclusive inclusive rows x rows loops node
1. 108,562.213 466,705.863 ↑ 11,965.5 8,057 1

Hash Left Join (cost=14,223,489.08..21,209,195.27 rows=96,406,047 width=92) (actual time=397,768.162..466,705.863 rows=8,057 loops=1)

  • Hash Cond: (((a.cusip)::bpchar = b.cusip) AND (a.company_number = b.company_number) AND (a.as_of_date = b.as_of_date))
  • Filter: ((b.company_number IS NULL) OR (b."position" <> a."position"))
  • Rows Removed by Filter: 96416868
2. 13,422.664 13,422.664 ↑ 1.0 96,424,925 1

Seq Scan on own_fund_hist_unadjusted_nonfi_0 a (cost=0.00..1,672,718.28 rows=96,424,928 width=26) (actual time=0.124..13,422.664 rows=96,424,925 loops=1)

3. 142,701.243 344,720.986 ↓ 1.0 297,027,878 1

Hash (cost=6,996,618.12..6,996,618.12 rows=296,962,912 width=26) (actual time=344,720.986..344,720.986 rows=297,027,878 loops=1)

  • Buckets: 65536 Batches: 8192 Memory Usage: 2728kB
4. 202,019.743 202,019.743 ↓ 1.0 297,027,878 1

Seq Scan on own_fund_hist_unadjusted_nonfi b (cost=0.00..6,996,618.12 rows=296,962,912 width=26) (actual time=0.004..202,019.743 rows=297,027,878 loops=1)

Planning time : 84.884 ms
Execution time : 466,707.832 ms