explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0h2

Settings
# exclusive inclusive rows x rows loops node
1. 400.878 400.878 ↓ 3.8 150,820 1

Index Scan using boxes_fc_country_production_site_production_date_index on boxes b (cost=0.56..4,891.49 rows=39,868 width=48) (actual time=0.167..400.878 rows=150,820 loops=1)

  • Index Cond: ((fc_country = 'us'::text) AND (production_site = ANY ('{NYC1,TEX1,CA1}'::text[])) AND (production_date >= '2018-12-29'::date))
  • Filter: (status = ANY ('{placed,complete}'::text[]))