explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LRhm : after index

Settings
# exclusive inclusive rows x rows loops node
1. 114,158.033 367,887.494 ↑ 11,965.5 8,057 1

Hash Left Join (cost=14,223,489.08..21,209,193.32 rows=96,405,983 width=92) (actual time=298,662.734..367,887.494 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,501.094 13,501.094 ↓ 1.0 96,424,925 1

Seq Scan on own_fund_hist_unadjusted_nonfi_0 a (cost=0.00..1,672,717.64 rows=96,424,864 width=26) (actual time=0.136..13,501.094 rows=96,424,925 loops=1)

3. 165,119.880 240,228.367 ↓ 1.0 297,027,878 1

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

  • Buckets: 65536 Batches: 8192 Memory Usage: 2728kB
4. 75,108.487 75,108.487 ↓ 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.005..75,108.487 rows=297,027,878 loops=1)

Planning time : 9.029 ms
Execution time : 367,889.490 ms