explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FoPJ

Settings
# exclusive inclusive rows x rows loops node
1. 372.283 469.971 ↓ 1.6 307,823 1

Bitmap Heap Scan on t_batida_rel br (cost=4,955.59..272,173.97 rows=192,292 width=52) (actual time=99.905..469.971 rows=307,823 loops=1)

  • Recheck Cond: ((data >= (date_trunc('month'::text, ((('now'::cstring)::date - 10))::timestamp with time zone))::date) AND (data <= (((date_trunc('month'::text, ((('now'::cstring)::date - 10))::timestamp with time zone) + '1 mon'::interval) - '1 day'::interval))::date))
  • Heap Blocks: exact=5,875
2. 97.688 97.688 ↓ 1.9 367,109 1

Bitmap Index Scan on xak_batida_rel (cost=0.00..4,907.52 rows=192,292 width=0) (actual time=97.688..97.688 rows=367,109 loops=1)

  • Index Cond: ((data >= (date_trunc('month'::text, ((('now'::cstring)::date - 10))::timestamp with time zone))::date) AND (data <= (((date_trunc('month'::text, ((('now'::cstring)::date - 10))::timestamp with time zone) + '1 mon'::interval) - '1 day'::interval))::date))
Planning time : 1.918 ms
Execution time : 718.238 ms