explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VJl8

Settings
# exclusive inclusive rows x rows loops node
1. 8.599 9.964 ↑ 5.6 82 1

Bitmap Heap Scan on billing_loan (cost=367.42..4,358.79 rows=458 width=98) (actual time=1.594..9.964 rows=82 loops=1)

  • Recheck Cond: (billing_loan_state_id = ANY ('{1,26}'::integer[]))
  • Filter: ((init_obj_id = 4,560) AND (term_end_date < (now())::date))
  • Rows Removed by Filter: 20,367
  • Heap Blocks: exact=1,612
2. 1.365 1.365 ↓ 1.0 20,449 1

Bitmap Index Scan on billing_loan_state_id (cost=0.00..367.31 rows=20,061 width=0) (actual time=1.365..1.365 rows=20,449 loops=1)

  • Index Cond: (billing_loan_state_id = ANY ('{1,26}'::integer[]))
Planning time : 0.216 ms
Execution time : 10.012 ms