explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AWQd

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.088 ↓ 0.0 0 1

Unique (cost=13.30..13.45 rows=29 width=28) (actual time=0.088..0.088 rows=0 loops=1)

2. 0.043 0.088 ↓ 0.0 0 1

Sort (cost=13.30..13.38 rows=29 width=28) (actual time=0.088..0.088 rows=0 loops=1)

  • Sort Method: quicksort Memory: 25kB
  • Sort Key: campaign_id
3. 0.045 0.045 ↓ 0.0 0 1

Seq Scan on batch (cost=0.00..12.60 rows=29 width=28) (actual time=0.045..0.045 rows=0 loops=1)

  • Rows Removed by Filter: 3
  • Filter: ((total_products_sold > 0) AND (charging OR (batch_end > ('now'::cstring)::date)))
Planning time : 0.998 ms
Execution time : 0.158 ms