explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oHSJ : Optimization for: plan #GmeK

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1,288.207 1,551.142 ↑ 1.0 1 1

Aggregate (cost=137,567.80..137,567.81 rows=1 width=16) (actual time=1,551.142..1,551.142 rows=1 loops=1)

2. 198.858 262.935 ↓ 1.0 355,048 1

Bitmap Heap Scan on \"trial-by-year\" (cost=11,671.10..135,830.09 rows=347,542 width=28) (actual time=86.116..262.935 rows=355,048 loops=1)

  • Recheck Cond: ((\"StartYear\" >= 2,015) AND (\"StartYear\" <= 2,020) AND (lead_sponsor_type = 'industry'::text))
  • Heap Blocks: exact=112,138
3. 64.077 64.077 ↓ 1.0 355,048 1

Bitmap Index Scan on \"RqgMlFarpKcSaDSVYoCfwFlsfwUAUZQ_StartYear_lead_sponsor_type_idx\" (cost=0.00..11,584.22 rows=347,542 width=0) (actual time=64.077..64.077 rows=355,048 loops=1)

  • Index Cond: ((\"StartYear\" >= 2,015) AND (\"StartYear\" <= 2,020) AND (lead_sponsor_type = 'industry'::text))
Planning time : 0.109 ms
Execution time : 1,551.278 ms