explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aa6

Settings
# exclusive inclusive rows x rows loops node
1. 49.184 86.373 ↓ 15.1 3,180 1

Bitmap Heap Scan on audits audit (cost=8,996.17..38,621.43 rows=211 width=267) (actual time=56.574..86.373 rows=3,180 loops=1)

  • Recheck Cond: (((model)::text = 'Credito'::text) AND (created >= '2018-07-23 00:00:00'::timestamp without time zone) AND (created <= '2019-02-07 23:59:59'::timestamp without time zone))
  • Filter: ((id <> 2642699) AND ((event)::text = 'DELETE'::text))
  • Rows Removed by Filter: 10471
  • Heap Blocks: exact=6375
2. 1.449 37.189 ↓ 0.0 0 1

BitmapAnd (cost=8,996.17..8,996.17 rows=10,288 width=0) (actual time=37.188..37.189 rows=0 loops=1)

3. 6.283 6.283 ↑ 1.0 40,759 1

Bitmap Index Scan on idx_model (cost=0.00..950.98 rows=42,473 width=0) (actual time=6.282..6.283 rows=40,759 loops=1)

  • Index Cond: ((model)::text = 'Credito'::text)
4. 29.457 29.457 ↓ 1.0 397,190 1

Bitmap Index Scan on idx_data (cost=0.00..8,044.84 rows=379,641 width=0) (actual time=29.456..29.457 rows=397,190 loops=1)

  • Index Cond: ((created >= '2018-07-23 00:00:00'::timestamp without time zone) AND (created <= '2019-02-07 23:59:59'::timestamp without time zone))