explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E6Qq : cfgh

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 199.428 ↑ 250.0 2 1

Limit (cost=1,467,628.90..1,467,658.90 rows=500 width=88) (actual time=199.426..199.428 rows=2 loops=1)

2. 0.011 199.425 ↑ 4,070.0 2 1

GroupAggregate (cost=1,467,628.90..1,468,117.30 rows=8,140 width=88) (actual time=199.424..199.425 rows=2 loops=1)

  • Group Key: fftp.tp_timestamp, fftp.tp_latitude, fftp.tp_longitude, fftp.tp_speed, fftp.tp_io_engineon, fftp.tp_bak1, fftp.tp_bak2, fftp.tp_bak3, fftp.tp_bak4, fftp.tp_bak1_filter, fftp.tp_bak2_filter, fftp.tp_bak1_predict, fftp.tp_bak2_predict, fft (...)
3. 0.045 199.414 ↑ 4,070.0 2 1

Sort (cost=1,467,628.90..1,467,649.25 rows=8,140 width=88) (actual time=199.414..199.414 rows=2 loops=1)

  • Sort Key: fftp.tp_timestamp, fftp.tp_latitude, fftp.tp_longitude, fftp.tp_speed, fftp.tp_io_engineon, fftp.tp_bak1, fftp.tp_bak2, fftp.tp_bak3, fftp.tp_bak4, fftp.tp_bak1_filter, fftp.tp_bak2_filter, fftp.tp_bak1_predict, fftp.tp_bak2_predict (...)
  • Sort Method: quicksort Memory: 25kB
4. 0.004 199.369 ↑ 4,070.0 2 1

Result (cost=0.00..1,467,100.17 rows=8,140 width=88) (actual time=17.620..199.369 rows=2 loops=1)

5. 0.013 199.365 ↑ 4,070.0 2 1

Append (cost=0.00..1,467,018.77 rows=8,140 width=88) (actual time=17.618..199.365 rows=2 loops=1)

6. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on uzgps_track_point fftp (cost=0.00..0.00 rows=1 width=88) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_unit_id = 1060) AND (tp_status = 'A (...)
7. 0.035 0.035 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m01_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2018m01 fftp_1 (cost=0.57..12.60 rows=1 width=88) (actual time=0.035..0.035 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
8. 0.020 0.020 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m02_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2018m02 fftp_2 (cost=0.57..12.57 rows=1 width=88) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
9. 0.044 0.044 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m03_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2018m03 fftp_3 (cost=0.57..16.65 rows=1 width=88) (actual time=0.044..0.044 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
10. 0.020 0.020 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m04_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2018m04 fftp_4 (cost=0.57..16.53 rows=1 width=88) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
11. 0.019 0.019 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m05_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2018m05 fftp_5 (cost=0.57..16.58 rows=1 width=88) (actual time=0.018..0.019 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
12. 0.019 0.019 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m06_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2018m06 fftp_6 (cost=0.57..16.39 rows=1 width=88) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
13. 3.480 5.364 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_track_point_2018m07 fftp_7 (cost=700.56..92,899.04 rows=1,444 width=88) (actual time=5.363..5.364 rows=0 loops=1)

  • Recheck Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
  • Rows Removed by Filter: 13997
  • Heap Blocks: exact=440
14. 1.884 1.884 ↑ 1.8 13,997 1

Bitmap Index Scan on uzgps_track_point_2018m07_tp_unit_id_tp_timestamp_idx (cost=0.00..700.20 rows=24,930 width=0) (actual time=1.884..1.884 rows=13,997 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
15. 43.392 48.357 ↑ 1,034.0 2 1

Bitmap Heap Scan on uzgps_track_point_2018m08 fftp_8 (cost=963.33..125,274.77 rows=2,068 width=88) (actual time=12.092..48.357 rows=2 loops=1)

  • Recheck Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
  • Rows Removed by Filter: 21291
  • Heap Blocks: exact=18448
16. 4.965 4.965 ↑ 1.6 21,293 1

Bitmap Index Scan on uzgps_track_point_2018m08_tp_unit_id_tp_timestamp_idx (cost=0.00..962.81 rows=34,419 width=0) (actual time=4.965..4.965 rows=21,293 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
17. 42.662 46.442 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_track_point_2018m09 fftp_9 (cost=895.79..117,322.05 rows=2,114 width=88) (actual time=46.442..46.442 rows=0 loops=1)

  • Recheck Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
  • Rows Removed by Filter: 19470
  • Heap Blocks: exact=17083
18. 3.780 3.780 ↑ 1.6 19,470 1

Bitmap Index Scan on uzgps_track_point_2018m09_tp_unit_id_tp_timestamp_idx (cost=0.00..895.26 rows=31,895 width=0) (actual time=3.780..3.780 rows=19,470 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
19. 37.909 41.548 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_track_point_2018m10 fftp_10 (cost=1,045.11..127,758.16 rows=2,343 width=88) (actual time=41.548..41.548 rows=0 loops=1)

  • Recheck Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
  • Rows Removed by Filter: 17995
  • Heap Blocks: exact=16152
20. 3.639 3.639 ↑ 1.9 17,995 1

Bitmap Index Scan on uzgps_track_point_2018m10_tp_unit_id_tp_timestamp_idx (cost=0.00..1,044.53 rows=34,556 width=0) (actual time=3.639..3.639 rows=17,995 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
21. 25.513 25.513 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m11_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2018m11 fftp_11 (cost=0.57..11.60 rows=1 width=88) (actual time=25.513..25.513 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
  • Rows Removed by Filter: 15044
22. 26.956 26.956 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2018m12_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2018m12 fftp_12 (cost=0.57..903,379.34 rows=1 width=88) (actual time=26.956..26.956 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
  • Rows Removed by Filter: 15403
23. 0.004 0.046 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_track_point_9999m99 fftp_13 (cost=5.61..329.14 rows=1 width=88) (actual time=0.046..0.046 rows=0 loops=1)

  • Recheck Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
24. 0.042 0.042 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_track_point_9999m99_tp_unit_id_tp_timestamp_idx (cost=0.00..5.61 rows=95 width=0) (actual time=0.042..0.042 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
25. 4.310 4.796 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_track_point_2019m01 fftp_14 (cost=1,244.51..99,793.98 rows=150 width=88) (actual time=4.796..4.796 rows=0 loops=1)

  • Recheck Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
  • Rows Removed by Filter: 2065
  • Heap Blocks: exact=1868
26. 0.486 0.486 ↑ 14.6 2,065 1

Bitmap Index Scan on uzgps_track_point_2019m01_tp_unit_id_tp_timestamp_idx (cost=0.00..1,244.47 rows=30,072 width=0) (actual time=0.485..0.486 rows=2,065 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
27. 0.002 0.032 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_track_point_2019m02 fftp_15 (cost=4.32..14.62 rows=1 width=88) (actual time=0.032..0.032 rows=0 loops=1)

  • Recheck Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
28. 0.030 0.030 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_track_point_2019m02_tp_unit_id_tp_timestamp_idx (cost=0.00..4.32 rows=3 width=0) (actual time=0.030..0.030 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
29. 0.010 0.010 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2019m03_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2019m03 fftp_16 (cost=0.15..8.18 rows=1 width=88) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
30. 0.024 0.024 ↓ 0.0 0 1

Seq Scan on uzgps_track_point_2019m04 fftp_17 (cost=0.00..4.02 rows=1 width=88) (actual time=0.024..0.024 rows=0 loops=1)

  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_unit_id = 1060) AND (tp_status = 'A (...)
  • Rows Removed by Filter: 37
31. 0.008 0.008 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2019m05_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2019m05 fftp_18 (cost=0.15..8.17 rows=1 width=88) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
32. 0.007 0.007 ↓ 0.0 0 1

Index Scan using uzgps_track_point_2019m06_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2019m06 fftp_19 (cost=0.15..8.17 rows=1 width=88) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
33. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on uzgps_track_point_2019m07 fftp_20 (cost=0.00..1.39 rows=1 width=88) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_unit_id = 1060) AND (tp_status = 'A (...)
  • Rows Removed by Filter: 14
34. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on uzgps_track_point_2019m08 fftp_21 (cost=0.00..2.85 rows=1 width=88) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_unit_id = 1060) AND (tp_status = 'A (...)
  • Rows Removed by Filter: 31
35. 0.003 0.015 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_track_point_2019m09 fftp_22 (cost=4.61..90.07 rows=1 width=88) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
36. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_track_point_2019m09_tp_unit_id_tp_timestamp_idx (cost=0.00..4.61 rows=25 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
37. 0.001 0.012 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_track_point_2019m10 fftp_23 (cost=4.32..14.51 rows=1 width=88) (actual time=0.012..0.012 rows=0 loops=1)

  • Recheck Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND (tp_status = 'A'::bpchar))
38. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_track_point_2019m10_tp_unit_id_tp_timestamp_idx (cost=0.00..4.32 rows=3 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((tp_unit_id = 1060) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_timestamp > (('now'::cstring)::date - '6 mons'::interval)))
39. 0.034 0.034 ↓ 0.0 0 1

Seq Scan on uzgps_track_point_2019m11 fftp_24 (cost=0.00..6.34 rows=1 width=88) (actual time=0.034..0.034 rows=0 loops=1)

  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_unit_id = 1060) AND (tp_status = 'A (...)
  • Rows Removed by Filter: 85
40. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on uzgps_track_point_2019m12 fftp_25 (cost=0.00..1.05 rows=1 width=88) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (((tp_bak1 IS NOT NULL) OR (tp_bak2 IS NOT NULL) OR (tp_bak3 IS NOT NULL) OR (tp_bak4 IS NOT NULL)) AND ('2018-01-01 00:00:00'::timestamp without time zone <= tp_timestamp) AND (tp_unit_id = 1060) AND (tp_status = 'A (...)
  • Rows Removed by Filter: 2