explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ntVI

Settings
# exclusive inclusive rows x rows loops node
1. 0.662 4.129 ↓ 0.0 0 1

Hash Left Join (cost=46.87..771.75 rows=1 width=1,759) (actual time=4.129..4.129 rows=0 loops=1)

  • Hash Cond: (t1.user_role_id = t0.id)
  • Filter: (((t1.modification_date >= '2020-06-17 08:14:50'::timestamp without time zone) AND (t1.modification_date < '2020-06-17 11:15:34.802'::timestamp without time zone)) OR ((t0.modification_date >= '2020-06-17 08:14:50'::timestamp without time zone) AND (t0.modification_date < '2020-06-17 11:15:34.802'::timestamp without time zone)))
  • Rows Removed by Filter: 442
2. 2.826 3.467 ↑ 5.3 442 1

Bitmap Heap Scan on courier t1 (cost=39.88..709.28 rows=2,336 width=1,759) (actual time=0.789..3.467 rows=442 loops=1)

  • Recheck Cond: ((agency_id = '3624'::numeric) OR (agency_id IS NULL))
  • Filter: (NOT deleted)
  • Rows Removed by Filter: 3,034
  • Heap Blocks: exact=468
3. 0.002 0.641 ↓ 0.0 0 1

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

4. 0.161 0.161 ↑ 1.0 419 1

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

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

Bitmap Index Scan on idx_courier_agency_id (cost=0.00..33.09 rows=3,053 width=0) (actual time=0.478..0.478 rows=3,057 loops=1)

6. 0.165 0.165 ↑ 1.0 177 1

Index Cond: (agency_id IS NULL)" -> Hash (cost=4.77..4.77 rows=177 width=13) (actual time=0.165..0.165 rows=177 loops=1)