explain.depesz.com

PostgreSQL's explain analyze made readable

Result: boX7

Settings
# exclusive inclusive rows x rows loops node
1. 0.098 0.735 ↑ 1.0 1 1

Aggregate (cost=40.03..40.04 rows=1 width=8) (actual time=0.734..0.735 rows=1 loops=1)

2. 0.637 0.637 ↓ 3.3 170 1

Seq Scan on device_6964 (cost=0.00..39.90 rows=51 width=8) (actual time=0.460..0.637 rows=170 loops=1)

  • Filter: (gpsdatetime >= '2019-02-02 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 94