explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RhLG

Settings
# exclusive inclusive rows x rows loops node
1. 0.072 4.509 ↑ 1.0 1 1

Aggregate (cost=44,606.54..44,606.55 rows=1 width=80) (actual time=4.509..4.509 rows=1 loops=1)

2. 4.157 4.437 ↓ 5.8 541 1

Bitmap Heap Scan on instntradesummary x0 (cost=253.29..44,605.83 rows=94 width=36) (actual time=0.371..4.437 rows=541 loops=1)

  • Recheck Cond: ((keyinstn = 4362236) AND (updoperation < 2))
  • Filter: ((((tradedatayear)::double precision > date_part('year'::text, (CURRENT_DATE + '-2 years'::interval))) AND ((tradedatayear)::double precision < date_part('year'::text, (CURRENT_DATE)::timestamp without time zone))) OR (((tradedatayear)::double precision = date_part('year'::text, (CURRENT_DATE + '-2 years'::interval))) AND ((tradedatamonth)::double precision >= date_part('month'::text, (CURRENT_DATE)::timestamp without time zone))) OR (((tradedatayear)::double precision = date_part('year'::text, (CURRENT_DATE)::timestamp without time zone)) AND ((tradedatamonth)::double precision <= date_part('month'::text, (CURRENT_DATE)::timestamp without time zone))))
  • Rows Removed by Filter: 4479
  • Heap Blocks: exact=817
3. 0.280 0.280 ↑ 2.2 5,020 1

Bitmap Index Scan on ix_instntradesummary_sk (cost=0.00..253.27 rows=11,293 width=0) (actual time=0.280..0.280 rows=5,020 loops=1)

  • Index Cond: (keyinstn = 4362236)
Planning time : 0.275 ms