explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vcBA

Settings
# exclusive inclusive rows x rows loops node
1. 3.938 7.875 ↓ 2.8 3,034 1

Hash Left Join (cost=46.26..741.47 rows=1,085 width=1,759) (actual time=1.025..7.875 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.083 3.721 ↓ 2.8 3,034 1

Bitmap Heap Scan on courier t1 (cost=39.28..708.72 rows=1,085 width=1,759) (actual time=0.788..3.721 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.000 0.638 ↓ 0.0 0 1

BitmapOr (cost=39.28..39.28 rows=3,475 width=0) (actual time=0.638..0.638 rows=0 loops=1)

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.162..0.163 rows=419 loops=1)

  • Index Cond: (agency_id = '3624'::numeric)
5. 0.475 0.475 ↓ 1.0 3,057 1

Bitmap Index Scan on idx_courier_agency_id (cost=0.00..33.11 rows=3,056 width=0) (actual time=0.475..0.475 rows=3,057 loops=1)

  • Index Cond: (agency_id IS NULL)
6. 0.130 0.216 ↑ 1.0 177 1

Hash (cost=4.77..4.77 rows=177 width=13) (actual time=0.216..0.216 rows=177 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 17kB
7. 0.086 0.086 ↑ 1.0 177 1

Seq Scan on user_role t0 (cost=0.00..4.77 rows=177 width=13) (actual time=0.006..0.086 rows=177 loops=1)