explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l9Fw

Settings
# exclusive inclusive rows x rows loops node
1. 1,023.247 2,166.279 ↓ 2.0 1,143,032 1

Seq Scan on sensor_data sd (cost=0.00..202,268.26 rows=572,066 width=165) (actual time=0.022..2,166.279 rows=1,143,032 loops=1)

  • Filter: (SubPlan 1)
2.          

SubPlan (forSeq Scan)

3. 0.000 1,143.032 ↑ 1.0 1 1,143,032

Limit (cost=0.00..0.07 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1,143,032)

4. 1,143.032 1,143.032 ↑ 18.0 1 1,143,032

Function Scan on unnest n (cost=0.00..1.25 rows=18 width=1) (actual time=0.001..0.001 rows=1 loops=1,143,032)

  • Filter: ((n)::text ~~* 'TA_%'::text)