explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b1t2 : Optimization for: Test; plan #Nsh2K

Settings

Optimization path:

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

Limit (cost=0.00..181.89 rows=3 width=33) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on notification (cost=0.00..574,054.12 rows=9,468 width=33) (actual rows= loops=)

  • Filter: ((media @> '{webhook}'::character varying[]) AND (created_date >= '2019-02-07 00:00:00+00'::timestamp with time zone) AND (created_date <= '2019-02-07 01:01:00+00'::timestamp with time zone))