explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nLL1

Settings
# exclusive inclusive rows x rows loops node
1. 63.483 102.118 ↓ 0.0 0 1

Bitmap Heap Scan on audits audit (cost=8,996.06..38,775.65 rows=1 width=4) (actual time=102.118..102.118 rows=0 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: (((event)::text = 'DELETE'::text) AND (((((json_object)::json -> 'Credito'::text) -> 'pedidolivro_id'::text))::text = '32736'::text))
  • Rows Removed by Filter: 13651
  • Heap Blocks: exact=6375
2. 1.438 38.635 ↓ 0.0 0 1

BitmapAnd (cost=8,996.06..8,996.06 rows=10,288 width=0) (actual time=38.634..38.635 rows=0 loops=1)

3. 6.292 6.292 ↑ 1.0 40,759 1

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

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

Bitmap Index Scan on idx_data (cost=0.00..8,044.84 rows=379,641 width=0) (actual time=30.904..30.905 rows=397,187 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))