explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MWav

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.660 ↑ 1.0 1 1

Limit (cost=0.14..3.65 rows=1 width=16) (actual time=0.660..0.660 rows=1 loops=1)

2. 0.659 0.659 ↑ 50.0 1 1

Index Scan using device_6964_index01 on device_6964 (cost=0.14..175.19 rows=50 width=16) (actual time=0.659..0.659 rows=1 loops=1)

  • Filter: ((spn917 IS NOT NULL) AND (to_char(gpsdatetime, 'YYYY-MM-DD HH24:MI:SS'::text) >= '2019-02-02 00:00:00'::text))
  • Rows Removed by Filter: 94