explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4CfS

Settings
# exclusive inclusive rows x rows loops node
1. 3.998 24.272 ↓ 2.8 3,034 1

Hash Left Join (cost=46.26..741.47 rows=1,085 width=1,759) (actual time=17.415..24.272 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.015 20.119 ↓ 2.8 3,034 1

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

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

4. 16.718 16.718 ↑ 1.0 419 1

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

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

  • Index Cond: (agency_id IS NULL)
6. 0.087 0.155 ↑ 1.0 177 1

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

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

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