explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kfAf

Settings
# exclusive inclusive rows x rows loops node
1. 4.125 7.773 ↓ 2.8 3,034 1

Hash Left Join (cost=46.24..741.38 rows=1,084 width=1,759) (actual time=0.977..7.773 rows=3,034 loops=1)

  • Hash Cond: (t1.user_role_id = t0.id)
  • Filter: (((t1.modification_date >= '2012-12-14 13:33:43.922'::timestamp without time zone) AND (t1.modification_date < '2020-04-21 13:17:33.871'::timestamp without time zone)) OR ((t0.modification_date >= '2012-12-14 13:33:43.922'::timestamp without time zone) AND (t0.modification_date < '2020-02-12 08:15:54.827'::timestamp without time zone)))
2. 3.004 3.648 ↓ 2.8 3,034 1

Bitmap Heap Scan on courier t1 (cost=39.26..708.66 rows=1,084 width=1,759) (actual time=0.794..3.648 rows=3,034 loops=1)

  • Recheck Cond: ((agency_id = '3624'::numeric) OR (agency_id IS NULL))
  • Filter: deleted
  • Rows Removed by Filter: 442
  • Heap Blocks: exact=468
3. 0.481 0.644 ↓ 0.0 0 1

BitmapOr (cost=39.26..39.26 rows=3,472 width=0) (actual time=0.644..0.644 rows=0 loops=1)

  • -> Bitmap Index Scan on idx_courier_agency_id (cost=0.00..33.09 rows=3,053 width=0) (actual time=0.479..0.480 rows=3,057 loops=1)" Index Cond: (agency_id IS NULL)
4. 0.163 0.163 ↑ 1.0 419 1

Bitmap Index Scan on idx_courier_agency_id (cost=0.00..5.63 rows=419 width=0) (actual time=0.163..0.163 rows=419 loops=1)

  • Index Cond: (agency_id = '3624'::numeric)