explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JeHI

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

Aggregate (cost=15.77..15.78 rows=1 width=8) (actual time=0.021..0.021 rows=1 loops=1)

2. 0.002 0.020 ↓ 0.0 0 1

Bitmap Heap Scan on "order" o (cost=11.74..15.77 rows=1 width=0) (actual time=0.019..0.020 rows=0 loops=1)

  • Recheck Cond: (((customer_email)::text = 'asdasa'::text) AND (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)
3. 0.000 0.018 ↓ 0.0 0 1

BitmapAnd (cost=11.74..11.74 rows=1 width=0) (actual time=0.018..0.018 rows=0 loops=1)

4. 0.018 0.018 ↓ 0.0 0 1

Bitmap Index Scan on ix_order_customer_email (cost=0.00..4.56 rows=18 width=0) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((customer_email)::text = 'asdasa'::text)
5. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix_order_create_date (cost=0.00..6.93 rows=250 width=0) (never executed)

  • 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))
Planning time : 0.212 ms
Execution time : 0.061 ms