explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uu8b

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 356,195.003 ↓ 0.0 0 1

Limit (cost=3.71..133.20 rows=1 width=549) (actual time=356,194.901..356,195.003 rows=0 loops=1)

2. 0.112 356,194.990 ↓ 0.0 0 1

Merge Append (cost=3.71..1,029,958.87 rows=7,954 width=549) (actual time=356,194.893..356,194.990 rows=0 loops=1)

  • Sort Key: records_data.ts_rec DESC
3. 0.007 0.007 ↓ 0.0 0 1

Index Scan Backward using udx_ts__device__records_data on records_data (cost=0.12..3.14 rows=1 width=252) (actual time=0.006..0.007 rows=0 loops=1)

  • Filter: (vehicle_device_id = 44)
4. 1.194 1.194 ↓ 0.0 0 1

Index Scan Backward using idx_ts_rec__vehicle_device__records_data_202006 on records_data_202006 (cost=0.28..153.03 rows=1 width=591) (actual time=1.189..1.194 rows=0 loops=1)

  • Index Cond: (vehicle_device_id = 44)
5. 0.633 0.633 ↓ 0.0 0 1

Index Scan Backward using idx_ts_rec__vehicle_device__records_data_202005 on records_data_202005 (cost=0.28..70.35 rows=1 width=775) (actual time=0.632..0.633 rows=0 loops=1)

  • Index Cond: (vehicle_device_id = 44)
6. 23,999.896 23,999.896 ↓ 0.0 0 1

Index Scan Backward using idx_ts_rec__vehicle_device__records_data_202008 on records_data_202008 (cost=0.43..68,715.59 rows=1 width=561) (actual time=23,999.892..23,999.896 rows=0 loops=1)

  • Index Cond: (vehicle_device_id = 44)
7. 247.685 247.685 ↓ 0.0 0 1

Index Scan Backward using idx_ts_rec__vehicle_device__records_data_202007 on records_data_202007 (cost=0.29..295.89 rows=1 width=665) (actual time=247.678..247.685 rows=0 loops=1)

  • Index Cond: (vehicle_device_id = 44)
8. 0.042 0.042 ↓ 0.0 0 1

Index Scan Backward using udx_ts__device__records_data_201912 on records_data_201912 (cost=0.12..3.14 rows=1 width=252) (actual time=0.042..0.042 rows=0 loops=1)

  • Filter: (vehicle_device_id = 44)
  • Rows Removed by Filter: 1
9. 16.180 16.180 ↓ 0.0 0 1

Index Scan Backward using idx_ts_rec__vehicle_device__records_data_202003 on records_data_202003 (cost=0.14..4.75 rows=1 width=252) (actual time=16.180..16.180 rows=0 loops=1)

  • Index Cond: (vehicle_device_id = 44)
10. 56.516 56.516 ↓ 0.0 0 1

Index Scan Backward using idx_ts_rec__vehicle_device__records_data_202001 on records_data_202001 (cost=0.28..20.98 rows=1 width=768) (actual time=56.512..56.516 rows=0 loops=1)

  • Index Cond: (vehicle_device_id = 44)
11. 8.453 8.453 ↓ 0.0 0 1

Index Scan Backward using idx_ts_rec__vehicle_device__records_data_202004 on records_data_202004 (cost=0.14..5.14 rows=1 width=427) (actual time=8.453..8.453 rows=0 loops=1)

  • Index Cond: (vehicle_device_id = 44)
12. 254,899.075 254,899.075 ↓ 0.0 0 1

Index Scan Backward using idx_ts_rec__vehicle_device__records_data_202009 on records_data_202009 (cost=0.56..634,065.97 rows=5,376 width=549) (actual time=254,899.071..254,899.075 rows=0 loops=1)

  • Index Cond: (vehicle_device_id = 44)
13. 0.595 0.595 ↓ 0.0 0 1

Index Scan Backward using idx_ts_rec__vehicle_device__records_data_202002 on records_data_202002 (cost=0.28..19.58 rows=1 width=770) (actual time=0.591..0.595 rows=0 loops=1)

  • Index Cond: (vehicle_device_id = 44)
14. 76,964.602 76,964.602 ↓ 0.0 0 1

Index Scan Backward using idx_ts_rec__vehicle_device__records_data_202010 on records_data_202010 (cost=0.56..326,418.74 rows=2,568 width=550) (actual time=76,964.598..76,964.602 rows=0 loops=1)

  • Index Cond: (vehicle_device_id = 44)
Planning time : 17.053 ms