explain.depesz.com

PostgreSQL's explain analyze made readable

Result: heE9 : Optimization for: Optimization for: counters with ; plan #dUQ4; plan #5imA

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 0.043 ↑ 1.0 1 1

Limit (cost=0.56..8.59 rows=1 width=93) (actual time=0.042..0.043 rows=1 loops=1)

2. 0.012 0.040 ↑ 1.0 1 1

LockRows (cost=0.56..8.59 rows=1 width=93) (actual time=0.040..0.040 rows=1 loops=1)

3. 0.028 0.028 ↑ 1.0 1 1

Index Scan using index_for_customer_counters_fetch on counters (cost=0.56..8.58 rows=1 width=93) (actual time=0.028..0.028 rows=1 loops=1)

  • Index Cond: ((enterprise = 25) AND (customer = 13) AND ((date)::text = '2019_03'::text) AND ((channel)::text = 'incoming'::text))