explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z3Sc : sequential scan

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.078 ↑ 1.0 1 1

Limit (cost=0.00..81,402.61 rows=1 width=93) (actual time=0.077..0.078 rows=1 loops=1)

2. 0.007 0.077 ↑ 1.0 1 1

LockRows (cost=0.00..81,402.61 rows=1 width=93) (actual time=0.077..0.077 rows=1 loops=1)

3. 0.070 0.070 ↑ 1.0 1 1

Seq Scan on counters (cost=0.00..81,402.60 rows=1 width=93) (actual time=0.069..0.070 rows=1 loops=1)

  • Filter: ((enterprise = 25) AND (supplier = 13) AND ((date)::text = '2019_03'::text) AND ((channel)::text = 'incoming'::text))
  • Rows Removed by Filter: 417
Planning time : 0.078 ms