explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DVft

Settings
# exclusive inclusive rows x rows loops node
1. 102.002 115.377 ↓ 1.0 31,442 1

Bitmap Heap Scan on invoice i (cost=1,237.17..69,497.11 rows=29,987 width=28) (actual time=17.332..115.377 rows=31,442 loops=1)

  • Recheck Cond: ((company_id = 11504) AND (deleted IS NULL) AND (status = 0) AND (type = ANY ('{0,1,3}'::integer[])) AND (total_final > '0'::double precision) AND (ppr_id IS NULL))
  • Heap Blocks: exact=23768
2. 13.375 13.375 ↓ 1.0 31,442 1

Bitmap Index Scan on test_2 (cost=0.00..1,229.68 rows=29,987 width=0) (actual time=13.375..13.375 rows=31,442 loops=1)

  • Index Cond: ((company_id = 11504) AND (deleted IS NULL) AND (status = 0) AND (type = ANY ('{0,1,3}'::integer[])) AND (total_final > '0'::double precision) AND (ppr_id IS NULL))
Planning time : 0.180 ms
Execution time : 116.744 ms