explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7tu8

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

Aggregate (cost=433.04..433.07 rows=1 width=16) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using ix_report_data_from on report (cost=0.42..432.99 rows=1 width=1,124) (actual rows= loops=)

  • Index Cond: ((immutable_timestamptz((data ->> 'From'::text)) >= $1) AND (immutable_timestamptz((data ->> 'From'::text)) < $2))
  • Filter: ((((data -> 'Metadata'::text) ->> 'Type'::text) = ANY ('{CL}'::text[])) AND ((data ->> 'AreaId'::text) = ANY ('{70,215,216,217,218,219,234,233,232,231,230}'::text[])))