explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FZj

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 4,157.292 ↓ 0.0 0 1

Limit (cost=0.00..542.94 rows=200 width=165) (actual time=4,157.292..4,157.292 rows=0 loops=1)

2. 728.195 4,157.291 ↓ 0.0 0 1

Seq Scan on sensor_data t (cost=0.00..1,552,979.65 rows=572,066 width=165) (actual time=4,157.291..4,157.291 rows=0 loops=1)

  • Filter: (SubPlan 1)
  • Rows Removed by Filter: 1143032
3.          

SubPlan (forSeq Scan)

4. 0.000 3,429.096 ↓ 0.0 0 1,143,032

Limit (cost=0.00..1.25 rows=1 width=1) (actual time=0.003..0.003 rows=0 loops=1,143,032)

5. 3,429.096 3,429.096 ↓ 0.0 0 1,143,032

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

  • Filter: ((n)::text ~~* 'TAGr_%'::text)
  • Rows Removed by Filter: 6
Planning time : 0.135 ms
Execution time : 4,157.334 ms