explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gsSk

Settings
# exclusive inclusive rows x rows loops node
1. 0.047 3.595 ↑ 1.0 200 1

Limit (cost=0.00..542.94 rows=200 width=165) (actual time=0.067..3.595 rows=200 loops=1)

2. 0.348 3.548 ↑ 2,860.3 200 1

Seq Scan on sensor_data t (cost=0.00..1,552,979.65 rows=572,066 width=165) (actual time=0.065..3.548 rows=200 loops=1)

  • Filter: (SubPlan 1)
3.          

SubPlan (forSeq Scan)

4. 0.200 3.200 ↑ 1.0 1 200

Limit (cost=0.00..1.25 rows=1 width=1) (actual time=0.016..0.016 rows=1 loops=200)

5. 3.000 3.000 ↑ 1.0 1 200

Function Scan on unnest n (cost=0.00..1.25 rows=1 width=1) (actual time=0.015..0.015 rows=1 loops=200)

  • Filter: ((n)::text ~~* 'TAG_14%'::text)
  • Rows Removed by Filter: 4
Planning time : 0.257 ms
Execution time : 3.677 ms