explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mKUk

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 32,157.055 ↑ 1.0 200 1

Limit (cost=0.00..514.87 rows=200 width=160) (actual time=32,155.447..32,157.055 rows=200 loops=1)

2. 17,448.930 32,157.040 ↑ 2,636,507.2 200 1

Seq Scan on sensor_data i (cost=0.00..1,357,458,199.00 rows=527,301,440 width=160) (actual time=32,155.446..32,157.040 rows=200 loops=1)

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

SubPlan (forSeq Scan)

4. 0.000 14,708.110 ↓ 0.0 0 14,708,110

Limit (cost=0.00..1.25 rows=1 width=1) (actual time=0.001..0.001 rows=0 loops=14,708,110)

5. 14,708.110 14,708.110 ↓ 0.0 0 14,708,110

Function Scan on unnest n (cost=0.00..1.25 rows=1 width=1) (actual time=0.001..0.001 rows=0 loops=14,708,110)

  • Filter: ((n)::text = 'TAG_1440'::text)
  • Rows Removed by Filter: 5