explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VaBk

Settings
# exclusive inclusive rows x rows loops node
1. 1,283.447 1,546.973 ↑ 1.0 1 1

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

2. 198.329 263.526 ↓ 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.798..263.526 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. 65.197 65.197 ↓ 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=65.197..65.197 rows=355,048 loops=1)

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