explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FIBg

Settings
# exclusive inclusive rows x rows loops node
1. 939.545 53,791.796 ↑ 26.4 22,478 1

Gather (cost=198,951.48..812,170.41 rows=593,903 width=56) (actual time=7,968.100..53,791.796 rows=22,478 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 45,618.645 52,852.251 ↑ 33.0 7,493 3

Parallel Hash Join (cost=197,951.48..751,780.11 rows=247,460 width=56) (actual time=7,966.488..52,852.251 rows=7,493 loops=3)

  • Hash Cond: (raw_financial_statement.company_id = stock_price.company_id)
  • Join Filter: (date_trunc('day'::text, (raw_financial_statement.announced + '7 days'::interval)) = date_trunc('day'::text, stock_price.date))
  • Rows Removed by Join Filter: 49175938
3. 58.100 63.532 ↑ 1.3 8,697 3

Parallel Bitmap Heap Scan on raw_financial_statement (cost=495.46..44,054.05 rows=10,923 width=963) (actual time=8.275..63.532 rows=8,697 loops=3)

  • Recheck Cond: (d_quarter_idx = 1)
  • Heap Blocks: exact=5561
4. 5.432 5.432 ↑ 1.0 26,090 1

Bitmap Index Scan on raw_financial_statement_d_quarter_idx (cost=0.00..488.90 rows=26,215 width=0) (actual time=5.432..5.432 rows=26,090 loops=1)

  • Index Cond: (d_quarter_idx = 1)
5. 6,019.505 7,170.074 ↑ 1.3 3,266,454 3

Parallel Hash (cost=122,492.68..122,492.68 rows=4,083,068 width=24) (actual time=7,170.074..7,170.074 rows=3,266,454 loops=3)

  • Buckets: 65536 (originally 65536) Batches: 512 (originally 256) Memory Usage: 4128kB
6. 1,150.569 1,150.569 ↑ 1.3 3,266,454 3

Parallel Seq Scan on stock_price (cost=0.00..122,492.68 rows=4,083,068 width=24) (actual time=0.036..1,150.569 rows=3,266,454 loops=3)

Planning time : 0.463 ms
Execution time : 53,796.428 ms