explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YfTc : sdfsdf

Settings
# exclusive inclusive rows x rows loops node
1. 6.251 219.245 ↓ 93.0 1,209 1

GroupAggregate (cost=27,374.33..27,466.63 rows=13 width=341) (actual time=159.482..219.245 rows=1,209 loops=1)

  • Group Key: cntr.id, mo.id, ((s.s_phone)::text), gu.gu_imei, ((round((bs.balance / '10000'::numeric), 2))::double precision), (first_value(at2.transaction_amount) OVER (?)), (first_value(at2.transaction_date) OVER (?))
2. 1.479 159.710 ↓ 93.2 1,211 1

Sort (cost=27,374.33..27,374.37 rows=13 width=268) (actual time=159.280..159.710 rows=1,211 loops=1)

  • Sort Key: cntr.id, mo.id, ((s.s_phone)::text), gu.gu_imei, ((round((bs.balance / '10000'::numeric), 2))::double precision), (first_value(at2.transaction_amount) OVER (?)), (first_value(at2.transaction_date) OVER (?))
  • Sort Method: quicksort Memory: 429kB
3. 1.165 158.231 ↓ 93.2 1,211 1

Merge Right Join (cost=27,344.48..27,374.09 rows=13 width=268) (actual time=156.711..158.231 rows=1,211 loops=1)

  • Merge Cond: (at2.account_number = bs.account_number)
4. 0.149 28.356 ↑ 4.4 298 1

Unique (cost=6,953.24..6,966.27 rows=1,303 width=28) (actual time=28.096..28.356 rows=298 loops=1)

5. 0.354 28.207 ↑ 1.0 1,287 1

Sort (cost=6,953.24..6,956.50 rows=1,303 width=28) (actual time=28.095..28.207 rows=1,287 loops=1)

  • Sort Key: at2.account_number, (first_value(at2.transaction_date) OVER (?)), (first_value(at2.transaction_amount) OVER (?))
  • Sort Method: quicksort Memory: 149kB
6. 0.712 27.853 ↑ 1.0 1,287 1

WindowAgg (cost=6,856.51..6,885.82 rows=1,303 width=28) (actual time=27.035..27.853 rows=1,287 loops=1)

7. 0.615 27.141 ↑ 1.0 1,287 1

Sort (cost=6,856.51..6,859.76 rows=1,303 width=20) (actual time=27.024..27.141 rows=1,287 loops=1)

  • Sort Key: at2.account_number, at2.transaction_date DESC
  • Sort Method: quicksort Memory: 149kB
8. 5.324 26.526 ↑ 1.0 1,287 1

Hash Join (cost=2,347.71..6,789.09 rows=1,303 width=20) (actual time=7.269..26.526 rows=1,287 loops=1)

  • Hash Cond: (at2.transaction_id = btt.id)
9. 14.283 18.167 ↑ 1.0 41,244 1

Bitmap Heap Scan on billing_account_transaction at2 (cost=1,056.01..5,323.49 rows=42,899 width=28) (actual time=4.219..18.167 rows=41,244 loops=1)

  • Recheck Cond: ((type = 1) AND (_status = 'A'::bpchar))
  • Heap Blocks: exact=2646
10. 3.884 3.884 ↑ 1.0 41,244 1

Bitmap Index Scan on billing_account_transaction_type__status_idx (cost=0.00..1,045.28 rows=42,899 width=0) (actual time=3.884..3.884 rows=41,244 loops=1)

  • Index Cond: ((type = 1) AND (_status = 'A'::bpchar))
11. 0.257 3.035 ↓ 1.0 1,650 1

Hash (cost=1,271.36..1,271.36 rows=1,627 width=8) (actual time=3.035..3.035 rows=1,650 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 81kB
12. 2.583 2.778 ↓ 1.0 1,650 1

Bitmap Heap Scan on billing_transaction btt (cost=32.90..1,271.36 rows=1,627 width=8) (actual time=0.257..2.778 rows=1,650 loops=1)

  • Recheck Cond: (sender_account_number = 100)
  • Heap Blocks: exact=560
13. 0.195 0.195 ↓ 1.0 1,650 1

Bitmap Index Scan on billing_transaction_sender_account_number_index (cost=0.00..32.49 rows=1,627 width=0) (actual time=0.195..0.195 rows=1,650 loops=1)

  • Index Cond: (sender_account_number = 100)
14. 1.291 128.710 ↓ 605.5 1,211 1

Sort (cost=20,391.25..20,391.25 rows=2 width=258) (actual time=128.588..128.710 rows=1,211 loops=1)

  • Sort Key: bs.account_number
  • Sort Method: quicksort Memory: 412kB
15. 0.444 127.419 ↓ 605.5 1,211 1

Nested Loop Left Join (cost=20,145.89..20,391.24 rows=2 width=258) (actual time=107.599..127.419 rows=1,211 loops=1)

16. 0.533 125.764 ↓ 605.5 1,211 1

Hash Left Join (cost=20,145.76..20,390.57 rows=2 width=226) (actual time=107.586..125.764 rows=1,211 loops=1)

  • Hash Cond: (cntr.id = bs.contract_id)
17. 0.274 17.813 ↓ 605.5 1,211 1

Nested Loop Left Join (cost=2.25..246.87 rows=2 width=190) (actual time=0.154..17.813 rows=1,211 loops=1)

18. 0.583 15.117 ↓ 605.5 1,211 1

Nested Loop Left Join (cost=1.96..246.11 rows=2 width=188) (actual time=0.136..15.117 rows=1,211 loops=1)

19. 0.579 12.112 ↓ 605.5 1,211 1

Nested Loop (cost=1.68..245.29 rows=2 width=188) (actual time=0.100..12.112 rows=1,211 loops=1)

20. 0.812 9.111 ↓ 605.5 1,211 1

Nested Loop (cost=1.39..244.47 rows=2 width=173) (actual time=0.083..9.111 rows=1,211 loops=1)

21. 0.334 5.863 ↓ 406.0 1,218 1

Nested Loop (cost=1.11..243.17 rows=3 width=165) (actual time=0.069..5.863 rows=1,218 loops=1)

22. 0.052 4.389 ↓ 76.0 76 1

Nested Loop Left Join (cost=0.82..232.44 rows=1 width=144) (actual time=0.060..4.389 rows=76 loops=1)

23. 2.107 4.037 ↓ 75.0 75 1

Nested Loop (cost=0.55..230.88 rows=1 width=139) (actual time=0.047..4.037 rows=75 loops=1)

  • Join Filter: (cntr.company_id = cmp.id)
  • Rows Removed by Join Filter: 27375
24. 0.580 0.580 ↓ 1.1 75 1

Index Scan using uzgps_contract_pkey on uzgps_contract cntr (cost=0.28..186.59 rows=70 width=118) (actual time=0.022..0.580 rows=75 loops=1)

  • Filter: ((c_status)::text = 'A'::text)
  • Rows Removed by Filter: 585
25. 1.113 1.350 ↓ 183.0 366 75

Materialize (cost=0.27..42.20 rows=2 width=37) (actual time=0.000..0.018 rows=366 loops=75)

26. 0.237 0.237 ↓ 183.0 366 1

Index Scan using uzgps_company_pkey on uzgps_company cmp (cost=0.27..42.19 rows=2 width=37) (actual time=0.008..0.237 rows=366 loops=1)

  • Filter: ((status)::text = 'A'::text)
  • Rows Removed by Filter: 87
27. 0.300 0.300 ↑ 1.0 1 75

Index Scan using billing_contract_settings_contract_id__status_idx on billing_contract_settings bcs (cost=0.28..1.55 rows=1 width=13) (actual time=0.004..0.004 rows=1 loops=75)

  • Index Cond: ((contract_id = cntr.id) AND (_status = 'A'::bpchar))
28. 1.140 1.140 ↓ 1.3 16 76

Index Scan using uzgps_mobject_mo_contract_id_mo_status_index on uzgps_mobject mo (cost=0.29..10.61 rows=12 width=29) (actual time=0.004..0.015 rows=16 loops=76)

  • Index Cond: ((mo_contract_id = cntr.id) AND ((mo_status)::text = 'A'::text))
29. 2.436 2.436 ↑ 1.0 1 1,218

Index Scan using uzgps_mobject_gps_units_mogu_mobject_id_mogu_status_idx on uzgps_mobject_gps_units mgu (cost=0.29..0.42 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,218)

  • Index Cond: ((mogu_mobject_id = mo.id) AND ((mogu_status)::text = 'A'::text))
30. 2.422 2.422 ↑ 1.0 1 1,211

Index Scan using uzgps_gps_unit_pkey on uzgps_gps_unit gu (cost=0.28..0.40 rows=1 width=23) (actual time=0.002..0.002 rows=1 loops=1,211)

  • Index Cond: (id = mgu.mogu_gps_unit_id)
  • Filter: ((gu_status)::text = 'A'::text)
31. 2.422 2.422 ↑ 1.0 1 1,211

Index Scan using uzgps_gps_unit_sim_gus_gps_unit_id_gus_status_idx on uzgps_gps_unit_sim gus (cost=0.29..0.40 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,211)

  • Index Cond: ((gus_gps_unit_id = gu.id) AND ((gus_status)::text = 'A'::text))
32. 2.422 2.422 ↑ 1.0 1 1,211

Index Scan using uzgps_sim_pkey on uzgps_sim s (cost=0.29..0.37 rows=1 width=18) (actual time=0.002..0.002 rows=1 loops=1,211)

  • Index Cond: (id = gus.gus_sim_id)
  • Filter: (((s_status)::text = 'A'::text) OR (s_status IS NULL))
33. 0.077 107.418 ↑ 1.9 356 1

Hash (cost=20,135.21..20,135.21 rows=664 width=44) (actual time=107.418..107.418 rows=356 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
34. 0.041 107.341 ↑ 1.8 359 1

Subquery Scan on bs (cost=20,120.27..20,135.21 rows=664 width=44) (actual time=107.218..107.341 rows=359 loops=1)

35. 23.338 107.300 ↑ 1.8 359 1

HashAggregate (cost=20,120.27..20,128.57 rows=664 width=76) (actual time=107.218..107.300 rows=359 loops=1)

  • Group Key: a.contract_id, a.account_number
36. 49.649 83.962 ↓ 1.0 104,999 1

Hash Left Join (cost=51.44..19,094.43 rows=102,584 width=24) (actual time=0.304..83.962 rows=104,999 loops=1)

  • Hash Cond: (at.account_id = a.id)
  • Join Filter: (at._status = 'A'::bpchar)
  • Rows Removed by Join Filter: 22651
37. 34.026 34.026 ↓ 1.0 104,999 1

Index Scan using billing_account_transaction_account_id__status_idx on billing_account_transaction at (cost=0.42..17,376.42 rows=102,584 width=38) (actual time=0.007..34.026 rows=104,999 loops=1)

38. 0.101 0.287 ↑ 1.0 664 1

Hash (cost=42.72..42.72 rows=664 width=20) (actual time=0.287..0.287 rows=664 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
39. 0.117 0.186 ↑ 1.0 664 1

Bitmap Heap Scan on billing_account a (cost=25.42..42.72 rows=664 width=20) (actual time=0.075..0.186 rows=664 loops=1)

  • Recheck Cond: (_status = 'A'::bpchar)
  • Heap Blocks: exact=9
40. 0.069 0.069 ↑ 1.0 664 1

Bitmap Index Scan on billing_account_contract_id__status_idx (cost=0.00..25.25 rows=664 width=0) (actual time=0.069..0.069 rows=664 loops=1)

  • Index Cond: (_status = 'A'::bpchar)
41. 1.211 1.211 ↑ 1.0 1 1,211

Index Scan using contract_status_pkey on contract_status st (cost=0.13..0.32 rows=1 width=40) (actual time=0.001..0.001 rows=1 loops=1,211)

  • Index Cond: (id = cntr.status_id)
42.          

SubPlan (for GroupAggregate)

43. 2.422 53.284 ↑ 1.0 1 1,211

Limit (cost=6.33..6.97 rows=1 width=8) (actual time=0.043..0.044 rows=1 loops=1,211)

44. 3.633 50.862 ↑ 1,043,694.0 1 1,211

Merge Append (cost=6.33..664,728.94 rows=1,043,694 width=8) (actual time=0.042..0.042 rows=1 loops=1,211)

  • Sort Key: uzgps_track_point.tp_timestamp DESC
45. 1.211 1.211 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_tp_unit_id_tp_timestamp_idx on uzgps_track_point (cost=0.12..8.15 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
46. 1.211 1.211 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2019m02_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2019m02 (cost=0.14..8.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
47. 0.000 0.000 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2019m03_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2019m03 (cost=0.14..8.16 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
48. 0.000 0.000 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2019m04_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2019m04 (cost=0.14..8.16 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
49. 1.211 1.211 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2019m05_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2019m05 (cost=0.14..8.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
50. 2.422 2.422 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2019m06_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2019m06 (cost=0.42..82,638.59 rows=84,873 width=8) (actual time=0.002..0.002 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
51. 2.422 2.422 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2019m07_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2019m07 (cost=0.43..158,060.93 rows=157,545 width=8) (actual time=0.002..0.002 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
52. 12.110 12.110 ↑ 12,297.0 1 1,211

Index Scan Backward using uzgps_track_point_2019m08_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2019m08 (cost=0.56..49,241.62 rows=12,297 width=8) (actual time=0.010..0.010 rows=1 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
  • Rows Removed by Filter: 0
53. 10.899 10.899 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2019m09_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2019m09 (cost=0.42..105,135.10 rows=52,904 width=8) (actual time=0.009..0.009 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
  • Rows Removed by Filter: 13
54. 3.633 3.633 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2019m10_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2019m10 (cost=0.42..76,141.74 rows=39,852 width=8) (actual time=0.003..0.003 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
  • Rows Removed by Filter: 1
55. 2.422 2.422 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2019m11_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2019m11 (cost=0.42..45,507.98 rows=35,439 width=8) (actual time=0.002..0.002 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
  • Rows Removed by Filter: 0
56. 1.211 1.211 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2019m12_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2019m12 (cost=0.27..39.35 rows=10 width=8) (actual time=0.001..0.001 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
57. 1.211 1.211 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_9999m99_tp_unit_id_tp_timestamp_idx on uzgps_track_point_9999m99 (cost=0.14..27.27 rows=49 width=8) (actual time=0.000..0.001 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
58. 2.422 2.422 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2020m01_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2020m01 (cost=0.42..96,728.32 rows=660,709 width=8) (actual time=0.002..0.002 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
59. 0.000 0.000 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2020m02_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2020m02 (cost=0.14..8.16 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
60. 0.000 0.000 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2020m03_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2020m03 (cost=0.14..8.16 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
61. 1.211 1.211 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2020m04_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2020m04 (cost=0.14..8.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
62. 0.000 0.000 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2020m05_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2020m05 (cost=0.14..8.16 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
63. 0.000 0.000 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2020m06_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2020m06 (cost=0.14..8.16 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
64. 0.000 0.000 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2020m07_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2020m07 (cost=0.14..8.16 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
65. 1.211 1.211 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2020m08_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2020m08 (cost=0.14..8.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
66. 0.000 0.000 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2020m09_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2020m09 (cost=0.14..8.16 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
67. 1.211 1.211 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2020m10_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2020m10 (cost=0.14..8.16 rows=1 width=8) (actual time=0.000..0.001 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
68. 0.000 0.000 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2020m11_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2020m11 (cost=0.14..8.16 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
69. 1.211 1.211 ↓ 0.0 0 1,211

Index Scan Backward using uzgps_track_point_2020m12_tp_unit_id_tp_timestamp_idx on uzgps_track_point_2020m12 (cost=0.14..8.16 rows=1 width=8) (actual time=0.000..0.001 rows=0 loops=1,211)

  • Index Cond: ((tp_unit_id = mo.id) AND (tp_timestamp >= '2019-02-10 09:54:13.391695'::timestamp without time zone))
  • Filter: (tp_status = 'A'::bpchar)
Planning time : 27.139 ms
Execution time : 220.310 ms