explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fyg7f

Settings
# exclusive inclusive rows x rows loops node
1. 805.065 806.934 ↓ 0.0 0 1

"Bitmap Heap Scan on ""T_EVENT_VE"" (cost=161.81..32,989.88 rows=1 width=767) (actual time=806.934..806.934 rows=0 loops=1)

  • Recheck Cond: (""EVVE_K_VE_ID"" = 1)
  • Filter: (((""EVVE_CODE_SERVICE"" = 2) OR (""EVVE_CODE_SERVICE"" = 1)) AND (""EVVE_DATE_EVENT"" >= (now() - '28 days'::interval)) AND (""EVVE_DATE_EVENT"" <= (now() - '14 days'::interval)))
  • Rows Removed by Filter: 6568
  • Heap Blocks: exact=4083
2. 1.869 1.869 ↑ 1.3 6,568 1

Bitmap Index Scan on ""INDEX_T_EVENT_VE_EVVE_K_VE_ID"" (cost=0.00..161.81 rows=8,717 width=0) (actual time=1.869..1.869 rows=6,568 loops=1)

  • Index Cond: (""EVVE_K_VE_ID"" = 1)
Planning time : 0.287 ms
Execution time : 807.196 ms