explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J0JQ

Settings
# exclusive inclusive rows x rows loops node
1. 54.994 92.163 ↓ 0.0 0 1

Bitmap Heap Scan on audits audit (cost=8,996.06..38,775.65 rows=1 width=4) (actual time=92.163..92.163 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 = '33406'::text))
  • Rows Removed by Filter: 13651
  • Heap Blocks: exact=6375
2. 1.473 37.169 ↓ 0.0 0 1

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

3. 6.157 6.157 ↑ 1.0 40,759 1

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

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

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