explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6ELg : Optimization for: explain ; plan #LHaY with indexes

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 299.678 ↑ 1.0 1 1

Limit (cost=28.04..20,772.93 rows=1 width=87) (actual time=299.677..299.678 rows=1 loops=1)

2. 299.124 299.676 ↑ 1.0 1 1

Bitmap Heap Scan on counters (cost=28.04..20,772.93 rows=1 width=87) (actual time=299.676..299.676 rows=1 loops=1)

  • Recheck Cond: ((enterprise = 25) AND ((date)::text = '2019_03'::text) AND ((channel)::text = 'incoming'::text))
  • Rows Removed by Index Recheck: 1267769
  • Filter: (customer = 13)
  • Rows Removed by Filter: 4
  • Heap Blocks: lossy=20071
3. 0.552 0.552 ↓ 22.5 200,960 1

Bitmap Index Scan on index_for_supplier_counters_fetch (cost=0.00..28.04 rows=8,927 width=0) (actual time=0.552..0.552 rows=200,960 loops=1)

  • Index Cond: ((enterprise = 25) AND ((date)::text = '2019_03'::text) AND ((channel)::text = 'incoming'::text))
Planning time : 0.119 ms