explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g2vm

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 130.813 ↑ 1.0 1 1

Aggregate (cost=272.61..272.62 rows=1 width=8) (actual time=130.813..130.813 rows=1 loops=1)

2. 130.809 130.809 ↑ 1.0 1 1

Index Scan using ix_order_create_date on "order" o (cost=0.43..272.60 rows=1 width=0) (actual time=130.449..130.809 rows=1 loops=1)

  • Index Cond: ((created_date >= '2019-11-05 20:36:45'::timestamp without time zone) AND (created_date <= '2019-11-05 21:36:45'::timestamp without time zone))
  • Filter: ((((order_details)::json -> 'shipping_address'::text) ->> 'zip'::text) = '25055-009'::text)
  • Rows Removed by Filter: 378
Planning time : 0.197 ms
Execution time : 130.857 ms