explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w8Tg

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.426 ↑ 1.0 200 1

Limit (cost=0.00..167.94 rows=200 width=165) (actual time=0.020..0.426 rows=200 loops=1)

2. 0.016 0.416 ↑ 2,860.3 200 1

Seq Scan on sensor_data t (cost=0.00..480,355.90 rows=572,066 width=165) (actual time=0.019..0.416 rows=200 loops=1)

  • Filter: (SubPlan 1)
3.          

SubPlan (forSeq Scan)

4. 0.200 0.400 ↑ 1.0 1 200

Limit (cost=0.00..0.32 rows=1 width=1) (actual time=0.002..0.002 rows=1 loops=200)

5. 0.200 0.200 ↑ 4.0 1 200

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

  • Filter: ((n)::text ~~* 'TAG_%'::text)
Planning time : 0.063 ms
Execution time : 0.446 ms