explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cufj

Settings
# exclusive inclusive rows x rows loops node
1. 0.076 0.184 ↓ 1.0 440 1

Sort (cost=84.26..85.35 rows=435 width=36) (actual time=0.164..0.184 rows=440 loops=1)

  • Sort Key: vehicles.ts DESC
  • Sort Method: quicksort Memory: 59kB
2. 0.031 0.108 ↓ 1.0 440 1

Append (cost=0.00..65.20 rows=435 width=36) (actual time=0.012..0.108 rows=440 loops=1)

3. 0.075 0.075 ↓ 1.0 440 1

Seq Scan on vehicles (cost=0.00..11.28 rows=423 width=36) (actual time=0.012..0.075 rows=440 loops=1)

  • Filter: (class_label = 2)
  • Rows Removed by Filter: 80
4. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on vehicles vehicles_1 (cost=0.00..25.88 rows=6 width=36) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (class_label = 2)
5. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on vehicles vehicles_2 (cost=0.00..25.88 rows=6 width=36) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (class_label = 2)
Planning time : 0.250 ms
Execution time : 0.219 ms