explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H3jV

Settings
# exclusive inclusive rows x rows loops node
1. 1.636 3.637 ↓ 2.8 3,034 1

Hash Left Join (cost=46.26..741.47 rows=1,085 width=1,759) (actual time=0.463..3.637 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. 1.620 1.918 ↓ 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.363..1.918 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.001 0.298 ↓ 0.0 0 1

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

4. 0.087 0.087 ↑ 1.0 419 1

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

  • Index Cond: (agency_id = '3624'::numeric)
5. 0.210 0.210 ↓ 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.210..0.210 rows=3,057 loops=1)

  • Index Cond: (agency_id IS NULL)
6. 0.043 0.083 ↑ 1.0 177 1

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

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

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