explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JVZS

Settings
# exclusive inclusive rows x rows loops node
1. 0.200 51,680.948 ↑ 276.8 122 1

Hash Left Join (cost=2,048,862.74..2,135,024.32 rows=33,768 width=140) (actual time=51,075.692..51,680.948 rows=122 loops=1)

  • Hash Cond: (dc1.tracker_code = da.tracker_code)
2. 0.077 51,599.429 ↑ 4.2 122 1

Merge Right Join (cost=1,453,726.21..1,539,121.56 rows=513 width=88) (actual time=50,994.351..51,599.429 rows=122 loops=1)

  • Merge Cond: (dc1.tracker_code = t.code)
3. 0.059 50,885.635 ↑ 5,417.0 33 1

Subquery Scan on dc1 (cost=879,203.90..901,102.00 rows=178,760 width=48) (actual time=50,864.525..50,885.635 rows=33 loops=1)

4. 16.863 50,885.576 ↑ 5,417.0 33 1

GroupAggregate (cost=879,203.90..893,951.60 rows=178,760 width=185) (actual time=50,864.522..50,885.576 rows=33 loops=1)

  • Group Key: point_2019_08_01.tracker_code, md.speed_avg, md.mileage
  • Filter: (count(*) > 12)
5. 37.435 50,868.713 ↑ 3.3 53,635 1

Sort (cost=879,203.90..879,650.80 rows=178,760 width=60) (actual time=50,864.155..50,868.713 rows=53,635 loops=1)

  • Sort Key: point_2019_08_01.tracker_code, md.speed_avg, md.mileage
  • Sort Method: quicksort Memory: 5696kB
6. 26.049 50,831.278 ↑ 3.3 53,635 1

Hash Left Join (cost=288,674.48..863,609.18 rows=178,760 width=60) (actual time=24,279.453..50,831.278 rows=53,635 loops=1)

  • Hash Cond: (point_2019_08_01.tracker_code = md.tracker_code)
7. 26,556.288 26,594.594 ↑ 3.3 53,635 1

Bitmap Heap Scan on point_2019_08_01 (cost=3,425.44..576,103.41 rows=178,760 width=20) (actual time=68.696..26,594.594 rows=53,635 loops=1)

  • Recheck Cond: (tracker_code = ANY ('{1021240979,1021241132,1021241191,1021243047,1021243062,1021243070,1021244516,1021246644,1021253673,1021253731,1021299140,1021303173,1021305160,1021313552,1021375015,1021451087,1021454420,1021457654,1021460559,1021461946,1021462530,1021462795,1021463850,1021464919,1021467265,1021471820,1021472539,1021473727,1021474576,1021482473,1021483588,1021483711,1021485773,1021485872,1021489817,1021491640,1021492050,1021502734,1021502890,1021504409,1021505596,1021507717,1021553299,1021554008,1021554982,1021729055,1021766032,1021798589,1021804704,1021805016,1021869935,1021871972,1021874802,1021880486,1021882052,1021882763,1021884769,1021889529,1021890840,1021892564,1021895070,1021895096,1021898181,1021898215,1021905069,1021907875,1021936528,1021937369,1021938029,1021950377,1021950529,1021951219,1021961351,1021988724,1021990910,1021998624,1021999010,1022005189,1022007094,1022012259,1022013897,1022017433,1022020172,1022029436,1022035750,1022035867,1022036584,1022037160,1022037822,1022052552,1022059800,1022061160,1022062069,1022063091,1022063109,1022064123,1022064644,1022064847,1022065190,1022066094}'::integer[]))
  • Heap Blocks: exact=32170
8. 38.306 38.306 ↑ 3.3 53,635 1

Bitmap Index Scan on point_2019_08_01_tracker_code_idx (cost=0.00..3,380.75 rows=178,760 width=0) (actual time=38.306..38.306 rows=53,635 loops=1)

  • Index Cond: (tracker_code = ANY ('{1021240979,1021241132,1021241191,1021243047,1021243062,1021243070,1021244516,1021246644,1021253673,1021253731,1021299140,1021303173,1021305160,1021313552,1021375015,1021451087,1021454420,1021457654,1021460559,1021461946,1021462530,1021462795,1021463850,1021464919,1021467265,1021471820,1021472539,1021473727,1021474576,1021482473,1021483588,1021483711,1021485773,1021485872,1021489817,1021491640,1021492050,1021502734,1021502890,1021504409,1021505596,1021507717,1021553299,1021554008,1021554982,1021729055,1021766032,1021798589,1021804704,1021805016,1021869935,1021871972,1021874802,1021880486,1021882052,1021882763,1021884769,1021889529,1021890840,1021892564,1021895070,1021895096,1021898181,1021898215,1021905069,1021907875,1021936528,1021937369,1021938029,1021950377,1021950529,1021951219,1021961351,1021988724,1021990910,1021998624,1021999010,1022005189,1022007094,1022012259,1022013897,1022017433,1022020172,1022029436,1022035750,1022035867,1022036584,1022037160,1022037822,1022052552,1022059800,1022061160,1022062069,1022063091,1022063109,1022064123,1022064644,1022064847,1022065190,1022066094}'::integer[]))
9. 0.024 24,210.635 ↑ 452.3 29 1

Hash (cost=285,085.08..285,085.08 rows=13,117 width=48) (actual time=24,210.635..24,210.635 rows=29 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 130kB
10. 0.012 24,210.611 ↑ 452.3 29 1

Subquery Scan on md (cost=281,346.73..285,085.08 rows=13,117 width=48) (actual time=24,189.402..24,210.611 rows=29 loops=1)

11. 92.822 24,210.599 ↑ 452.3 29 1

HashAggregate (cost=281,346.73..284,953.91 rows=13,117 width=48) (actual time=24,189.399..24,210.599 rows=29 loops=1)

  • Group Key: point_2019_08_01_1.tracker_code
  • Filter: (count(*) > 12)
  • Rows Removed by Filter: 2
12. 24,064.324 24,117.777 ↑ 1.9 38,851 1

Bitmap Heap Scan on point_2019_08_01 point_2019_08_01_1 (cost=3,456.17..280,609.87 rows=73,686 width=42) (actual time=60.087..24,117.777 rows=38,851 loops=1)

  • Recheck Cond: ((tracker_code = ANY ('{1021240979,1021241132,1021241191,1021243047,1021243062,1021243070,1021244516,1021246644,1021253673,1021253731,1021299140,1021303173,1021305160,1021313552,1021375015,1021451087,1021454420,1021457654,1021460559,1021461946,1021462530,1021462795,1021463850,1021464919,1021467265,1021471820,1021472539,1021473727,1021474576,1021482473,1021483588,1021483711,1021485773,1021485872,1021489817,1021491640,1021492050,1021502734,1021502890,1021504409,1021505596,1021507717,1021553299,1021554008,1021554982,1021729055,1021766032,1021798589,1021804704,1021805016,1021869935,1021871972,1021874802,1021880486,1021882052,1021882763,1021884769,1021889529,1021890840,1021892564,1021895070,1021895096,1021898181,1021898215,1021905069,1021907875,1021936528,1021937369,1021938029,1021950377,1021950529,1021951219,1021961351,1021988724,1021990910,1021998624,1021999010,1022005189,1022007094,1022012259,1022013897,1022017433,1022020172,1022029436,1022035750,1022035867,1022036584,1022037160,1022037822,1022052552,1022059800,1022061160,1022062069,1022063091,1022063109,1022064123,1022064644,1022064847,1022065190,1022066094}'::integer[])) AND ((nsat > 3) OR (nsat IS NULL)) AND ((pdop < 8) OR (pdop IS NULL)) AND (speed > 2) AND (speed < 150) AND (NOT (geom ~= '0101000020E610000000000000000000000000000000000000'::geometry)))
  • Filter: (speed > 5)
  • Rows Removed by Filter: 2722
  • Heap Blocks: exact=23375
13. 53.453 53.453 ↑ 1.9 41,573 1

Bitmap Index Scan on point_2019_08_01_tc_nt_geom_partial_idx_5 (cost=0.00..3,437.75 rows=78,142 width=0) (actual time=53.453..53.453 rows=41,573 loops=1)

  • Index Cond: (tracker_code = ANY ('{1021240979,1021241132,1021241191,1021243047,1021243062,1021243070,1021244516,1021246644,1021253673,1021253731,1021299140,1021303173,1021305160,1021313552,1021375015,1021451087,1021454420,1021457654,1021460559,1021461946,1021462530,1021462795,1021463850,1021464919,1021467265,1021471820,1021472539,1021473727,1021474576,1021482473,1021483588,1021483711,1021485773,1021485872,1021489817,1021491640,1021492050,1021502734,1021502890,1021504409,1021505596,1021507717,1021553299,1021554008,1021554982,1021729055,1021766032,1021798589,1021804704,1021805016,1021869935,1021871972,1021874802,1021880486,1021882052,1021882763,1021884769,1021889529,1021890840,1021892564,1021895070,1021895096,1021898181,1021898215,1021905069,1021907875,1021936528,1021937369,1021938029,1021950377,1021950529,1021951219,1021961351,1021988724,1021990910,1021998624,1021999010,1022005189,1022007094,1022012259,1022013897,1022017433,1022020172,1022029436,1022035750,1022035867,1022036584,1022037160,1022037822,1022052552,1022059800,1022061160,1022062069,1022063091,1022063109,1022064123,1022064644,1022064847,1022065190,1022066094}'::integer[]))
14. 0.046 713.717 ↓ 1.5 122 1

Materialize (cost=574,522.32..637,565.18 rows=83 width=40) (actual time=129.822..713.717 rows=122 loops=1)

15. 0.062 713.671 ↓ 1.5 122 1

Merge Left Join (cost=574,522.32..637,564.97 rows=83 width=40) (actual time=129.819..713.671 rows=122 loops=1)

  • Merge Cond: (t.code = tca1.tracker_code)
16. 0.068 303.368 ↓ 1.5 122 1

Merge Left Join (cost=287,955.26..311,509.53 rows=83 width=32) (actual time=71.761..303.368 rows=122 loops=1)

  • Merge Cond: (t.code = tcd1.tracker_code)
17. 0.065 15.751 ↓ 1.5 122 1

Sort (cost=1,388.20..1,388.41 rows=83 width=24) (actual time=15.729..15.751 rows=122 loops=1)

  • Sort Key: t.code
  • Sort Method: quicksort Memory: 34kB
18. 0.080 15.686 ↓ 1.5 122 1

Nested Loop (cost=326.63..1,385.56 rows=83 width=24) (actual time=14.504..15.686 rows=122 loops=1)

19. 0.081 15.482 ↓ 1.4 124 1

Nested Loop (cost=326.36..1,359.00 rows=90 width=24) (actual time=14.492..15.482 rows=124 loops=1)

20. 0.066 15.029 ↓ 1.3 124 1

Nested Loop (cost=326.07..1,319.98 rows=92 width=12) (actual time=14.471..15.029 rows=124 loops=1)

21. 0.151 14.576 ↓ 1.1 129 1

Bitmap Heap Scan on tracker t (cost=325.78..593.60 rows=119 width=12) (actual time=14.440..14.576 rows=129 loops=1)

  • Recheck Cond: ((code = ANY ('{1021240979,1021241132,1021241191,1021243047,1021243062,1021243070,1021244516,1021246644,1021253673,1021253731,1021299140,1021303173,1021305160,1021313552,1021375015,1021451087,1021454420,1021457654,1021460559,1021461946,1021462530,1021462795,1021463850,1021464919,1021467265,1021471820,1021472539,1021473727,1021474576,1021482473,1021483588,1021483711,1021485773,1021485872,1021489817,1021491640,1021492050,1021502734,1021502890,1021504409,1021505596,1021507717,1021553299,1021554008,1021554982,1021729055,1021766032,1021798589,1021804704,1021805016,1021869935,1021871972,1021874802,1021880486,1021882052,1021882763,1021884769,1021889529,1021890840,1021892564,1021895070,1021895096,1021898181,1021898215,1021905069,1021907875,1021936528,1021937369,1021938029,1021950377,1021950529,1021951219,1021961351,1021988724,1021990910,1021998624,1021999010,1022005189,1022007094,1022012259,1022013897,1022017433,1022020172,1022029436,1022035750,1022035867,1022036584,1022037160,1022037822,1022052552,1022059800,1022061160,1022062069,1022063091,1022063109,1022064123,1022064644,1022064847,1022065190,1022066094}'::integer[])) AND (deleted IS NULL))
  • Heap Blocks: exact=47
22. 14.425 14.425 ↓ 1.1 129 1

Bitmap Index Scan on tracker_code_contractor_deleted_unique_idx (cost=0.00..325.75 rows=119 width=0) (actual time=14.425..14.425 rows=129 loops=1)

  • Index Cond: (code = ANY ('{1021240979,1021241132,1021241191,1021243047,1021243062,1021243070,1021244516,1021246644,1021253673,1021253731,1021299140,1021303173,1021305160,1021313552,1021375015,1021451087,1021454420,1021457654,1021460559,1021461946,1021462530,1021462795,1021463850,1021464919,1021467265,1021471820,1021472539,1021473727,1021474576,1021482473,1021483588,1021483711,1021485773,1021485872,1021489817,1021491640,1021492050,1021502734,1021502890,1021504409,1021505596,1021507717,1021553299,1021554008,1021554982,1021729055,1021766032,1021798589,1021804704,1021805016,1021869935,1021871972,1021874802,1021880486,1021882052,1021882763,1021884769,1021889529,1021890840,1021892564,1021895070,1021895096,1021898181,1021898215,1021905069,1021907875,1021936528,1021937369,1021938029,1021950377,1021950529,1021951219,1021961351,1021988724,1021990910,1021998624,1021999010,1022005189,1022007094,1022012259,1022013897,1022017433,1022020172,1022029436,1022035750,1022035867,1022036584,1022037160,1022037822,1022052552,1022059800,1022061160,1022062069,1022063091,1022063109,1022064123,1022064644,1022064847,1022065190,1022066094}'::integer[]))
23. 0.387 0.387 ↑ 1.0 1 129

Index Scan using vehicle_tracker_ca3b814c on vehicle_tracker vt (cost=0.29..6.09 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=129)

  • Index Cond: (tracker_id = t.id)
  • Filter: ((deleted IS NULL) AND (date_start <= '2019-08-01 00:00:00'::timestamp without time zone) AND ((date_finish >= '2019-08-02 00:00:00'::timestamp without time zone) OR (date_finish IS NULL)))
  • Rows Removed by Filter: 0
24. 0.372 0.372 ↑ 1.0 1 124

Index Scan using vehicle_pkey on vehicle v (cost=0.29..0.42 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=124)

  • Index Cond: (id = vt.vehicle_id)
  • Filter: (deleted IS NULL)
25. 0.124 0.124 ↑ 1.0 1 124

Index Scan using contractor_pkey on contractor c (cost=0.28..0.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=124)

  • Index Cond: (id = v.contractor_id)
  • Filter: (deleted IS NULL)
  • Rows Removed by Filter: 0
26. 0.029 287.549 ↑ 454.0 29 1

Subquery Scan on tcd1 (cost=286,567.06..310,087.62 rows=13,165 width=16) (actual time=56.028..287.549 rows=29 loops=1)

27. 17.257 287.520 ↑ 454.0 29 1

GroupAggregate (cost=286,567.06..309,758.49 rows=13,165 width=48) (actual time=56.026..287.520 rows=29 loops=1)

  • Group Key: point_2019_08_01_2.tracker_code
  • Filter: (count(*) > 12)
  • Rows Removed by Filter: 2
28. 212.570 270.263 ↑ 1.9 38,851 1

WindowAgg (cost=286,567.06..307,936.00 rows=73,686 width=48) (actual time=52.433..270.263 rows=38,851 loops=1)

29. 20.669 57.693 ↑ 1.9 38,851 1

Sort (cost=286,567.06..286,751.27 rows=73,686 width=32) (actual time=52.412..57.693 rows=38,851 loops=1)

  • Sort Key: point_2019_08_01_2.tracker_code, point_2019_08_01_2.navigation_time
  • Sort Method: quicksort Memory: 4572kB
30. 32.700 37.024 ↑ 1.9 38,851 1

Bitmap Heap Scan on point_2019_08_01 point_2019_08_01_2 (cost=3,456.17..280,609.87 rows=73,686 width=32) (actual time=7.217..37.024 rows=38,851 loops=1)

  • Recheck Cond: ((tracker_code = ANY ('{1021240979,1021241132,1021241191,1021243047,1021243062,1021243070,1021244516,1021246644,1021253673,1021253731,1021299140,1021303173,1021305160,1021313552,1021375015,1021451087,1021454420,1021457654,1021460559,1021461946,1021462530,1021462795,1021463850,1021464919,1021467265,1021471820,1021472539,1021473727,1021474576,1021482473,1021483588,1021483711,1021485773,1021485872,1021489817,1021491640,1021492050,1021502734,1021502890,1021504409,1021505596,1021507717,1021553299,1021554008,1021554982,1021729055,1021766032,1021798589,1021804704,1021805016,1021869935,1021871972,1021874802,1021880486,1021882052,1021882763,1021884769,1021889529,1021890840,1021892564,1021895070,1021895096,1021898181,1021898215,1021905069,1021907875,1021936528,1021937369,1021938029,1021950377,1021950529,1021951219,1021961351,1021988724,1021990910,1021998624,1021999010,1022005189,1022007094,1022012259,1022013897,1022017433,1022020172,1022029436,1022035750,1022035867,1022036584,1022037160,1022037822,1022052552,1022059800,1022061160,1022062069,1022063091,1022063109,1022064123,1022064644,1022064847,1022065190,1022066094}'::integer[])) AND ((nsat > 3) OR (nsat IS NULL)) AND ((pdop < 8) OR (pdop IS NULL)) AND (speed > 2) AND (speed < 150) AND (NOT (geom ~= '0101000020E610000000000000000000000000000000000000'::geometry)))
  • Filter: (speed > 5)
  • Rows Removed by Filter: 2722
  • Heap Blocks: exact=23375
31. 4.324 4.324 ↑ 1.9 41,573 1

Bitmap Index Scan on point_2019_08_01_tc_nt_geom_partial_idx_5 (cost=0.00..3,437.75 rows=78,142 width=0) (actual time=4.324..4.324 rows=41,573 loops=1)

  • Index Cond: (tracker_code = ANY ('{1021240979,1021241132,1021241191,1021243047,1021243062,1021243070,1021244516,1021246644,1021253673,1021253731,1021299140,1021303173,1021305160,1021313552,1021375015,1021451087,1021454420,1021457654,1021460559,1021461946,1021462530,1021462795,1021463850,1021464919,1021467265,1021471820,1021472539,1021473727,1021474576,1021482473,1021483588,1021483711,1021485773,1021485872,1021489817,1021491640,1021492050,1021502734,1021502890,1021504409,1021505596,1021507717,1021553299,1021554008,1021554982,1021729055,1021766032,1021798589,1021804704,1021805016,1021869935,1021871972,1021874802,1021880486,1021882052,1021882763,1021884769,1021889529,1021890840,1021892564,1021895070,1021895096,1021898181,1021898215,1021905069,1021907875,1021936528,1021937369,1021938029,1021950377,1021950529,1021951219,1021961351,1021988724,1021990910,1021998624,1021999010,1022005189,1022007094,1022012259,1022013897,1022017433,1022020172,1022029436,1022035750,1022035867,1022036584,1022037160,1022037822,1022052552,1022059800,1022061160,1022062069,1022063091,1022063109,1022064123,1022064644,1022064847,1022065190,1022066094}'::integer[]))
32. 0.017 410.241 ↑ 309.7 29 1

Subquery Scan on tca1 (cost=286,567.06..326,032.52 rows=8,981 width=16) (actual time=58.054..410.241 rows=29 loops=1)

33. 38.835 410.224 ↑ 309.7 29 1

GroupAggregate (cost=286,567.06..325,807.99 rows=8,981 width=48) (actual time=58.053..410.224 rows=29 loops=1)

  • Group Key: tca5.tracker_code
  • Filter: (count(*) > 12)
34. 57.370 371.389 ↓ 2.8 38,749 1

Subquery Scan on tca5 (cost=286,567.06..324,331.13 rows=13,646 width=88) (actual time=52.611..371.389 rows=38,749 loops=1)

  • Filter: (((('2'::double precision * sqrt((power((tca5.lat2 - tca5.lat1), '2'::double precision) + power((tca5.lng2 - tca5.lng1), '2'::double precision)))) * sqrt((power((tca5.lat2 - tca5.lat3), '2'::double precision) + power((tca5.lng2 - tca5.lng3), '2'::double precision)))) > '1e-11'::double precision) AND (('1.00001'::double precision < abs(((((((power((tca5.lat2 - tca5.lat1), '2'::double precision) + power((tca5.lng2 - tca5.lng1), '2'::double precision)) + power((tca5.lat2 - tca5.lat3), '2'::double precision)) + power((tca5.lng2 - tca5.lng3), '2'::double precision)) - power((tca5.lat1 - tca5.lat3), '2'::double precision)) - power((tca5.lng1 - tca5.lng3), '2'::double precision)) / (('2'::double precision * sqrt((power((tca5.lat2 - tca5.lat1), '2'::double precision) + power((tca5.lng2 - tca5.lng1), '2'::double precision)))) * sqrt((power((tca5.lat2 - tca5.lat3), '2'::double precision) + power((tca5.lng2 - tca5.lng3), '2'::double precision))))))) OR (abs(((((((power((tca5.lat2 - tca5.lat1), '2'::double precision) + power((tca5.lng2 - tca5.lng1), '2'::double precision)) + power((tca5.lat2 - tca5.lat3), '2'::double precision)) + power((tca5.lng2 - tca5.lng3), '2'::double precision)) - power((tca5.lat1 - tca5.lat3), '2'::double precision)) - power((tca5.lng1 - tca5.lng3), '2'::double precision)) / (('2'::double precision * sqrt((power((tca5.lat2 - tca5.lat1), '2'::double precision) + power((tca5.lng2 - tca5.lng1), '2'::double precision)))) * sqrt((power((tca5.lat2 - tca5.lat3), '2'::double precision) + power((tca5.lng2 - tca5.lng3), '2'::double precision)))))) < '1'::double precision)))
  • Rows Removed by Filter: 102
35. 254.213 314.019 ↑ 1.9 38,851 1

WindowAgg (cost=286,567.06..308,304.43 rows=73,686 width=96) (actual time=52.440..314.019 rows=38,851 loops=1)

36. 23.004 59.806 ↑ 1.9 38,851 1

Sort (cost=286,567.06..286,751.27 rows=73,686 width=32) (actual time=52.415..59.806 rows=38,851 loops=1)

  • Sort Key: point_2019_08_01_3.tracker_code, point_2019_08_01_3.navigation_time
  • Sort Method: quicksort Memory: 4572kB
37. 32.722 36.802 ↑ 1.9 38,851 1

Bitmap Heap Scan on point_2019_08_01 point_2019_08_01_3 (cost=3,456.17..280,609.87 rows=73,686 width=32) (actual time=6.918..36.802 rows=38,851 loops=1)

  • Recheck Cond: ((tracker_code = ANY ('{1021240979,1021241132,1021241191,1021243047,1021243062,1021243070,1021244516,1021246644,1021253673,1021253731,1021299140,1021303173,1021305160,1021313552,1021375015,1021451087,1021454420,1021457654,1021460559,1021461946,1021462530,1021462795,1021463850,1021464919,1021467265,1021471820,1021472539,1021473727,1021474576,1021482473,1021483588,1021483711,1021485773,1021485872,1021489817,1021491640,1021492050,1021502734,1021502890,1021504409,1021505596,1021507717,1021553299,1021554008,1021554982,1021729055,1021766032,1021798589,1021804704,1021805016,1021869935,1021871972,1021874802,1021880486,1021882052,1021882763,1021884769,1021889529,1021890840,1021892564,1021895070,1021895096,1021898181,1021898215,1021905069,1021907875,1021936528,1021937369,1021938029,1021950377,1021950529,1021951219,1021961351,1021988724,1021990910,1021998624,1021999010,1022005189,1022007094,1022012259,1022013897,1022017433,1022020172,1022029436,1022035750,1022035867,1022036584,1022037160,1022037822,1022052552,1022059800,1022061160,1022062069,1022063091,1022063109,1022064123,1022064644,1022064847,1022065190,1022066094}'::integer[])) AND ((nsat > 3) OR (nsat IS NULL)) AND ((pdop < 8) OR (pdop IS NULL)) AND (speed > 2) AND (speed < 150) AND (NOT (geom ~= '0101000020E610000000000000000000000000000000000000'::geometry)))
  • Filter: (speed > 5)
  • Rows Removed by Filter: 2722
  • Heap Blocks: exact=23375
38. 4.080 4.080 ↑ 1.9 41,573 1

Bitmap Index Scan on point_2019_08_01_tc_nt_geom_partial_idx_5 (cost=0.00..3,437.75 rows=78,142 width=0) (actual time=4.080..4.080 rows=41,573 loops=1)

  • Index Cond: (tracker_code = ANY ('{1021240979,1021241132,1021241191,1021243047,1021243062,1021243070,1021244516,1021246644,1021253673,1021253731,1021299140,1021303173,1021305160,1021313552,1021375015,1021451087,1021454420,1021457654,1021460559,1021461946,1021462530,1021462795,1021463850,1021464919,1021467265,1021471820,1021472539,1021473727,1021474576,1021482473,1021483588,1021483711,1021485773,1021485872,1021489817,1021491640,1021492050,1021502734,1021502890,1021504409,1021505596,1021507717,1021553299,1021554008,1021554982,1021729055,1021766032,1021798589,1021804704,1021805016,1021869935,1021871972,1021874802,1021880486,1021882052,1021882763,1021884769,1021889529,1021890840,1021892564,1021895070,1021895096,1021898181,1021898215,1021905069,1021907875,1021936528,1021937369,1021938029,1021950377,1021950529,1021951219,1021961351,1021988724,1021990910,1021998624,1021999010,1022005189,1022007094,1022012259,1022013897,1022017433,1022020172,1022029436,1022035750,1022035867,1022036584,1022037160,1022037822,1022052552,1022059800,1022061160,1022062069,1022063091,1022063109,1022064123,1022064644,1022064847,1022065190,1022066094}'::integer[]))
39. 0.024 81.319 ↑ 398.9 33 1

Hash (cost=594,971.96..594,971.96 rows=13,165 width=12) (actual time=81.319..81.319 rows=33 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 130kB
40. 0.017 81.295 ↑ 398.9 33 1

Subquery Scan on da (cost=591,698.14..594,971.96 rows=13,165 width=12) (actual time=57.151..81.295 rows=33 loops=1)

41. 20.700 81.278 ↑ 398.9 33 1

GroupAggregate (cost=591,698.14..594,544.10 rows=13,165 width=16) (actual time=57.149..81.278 rows=33 loops=1)

  • Group Key: point_2019_08_01_4.tracker_code
  • Filter: (count(*) > 12)
42. 12.022 60.578 ↑ 3.3 53,635 1

Sort (cost=591,698.14..592,145.04 rows=178,760 width=24) (actual time=56.634..60.578 rows=53,635 loops=1)

  • Sort Key: point_2019_08_01_4.tracker_code
  • Sort Method: quicksort Memory: 5727kB
43. 42.465 48.556 ↑ 3.3 53,635 1

Bitmap Heap Scan on point_2019_08_01 point_2019_08_01_4 (cost=3,425.44..576,103.41 rows=178,760 width=24) (actual time=10.664..48.556 rows=53,635 loops=1)

  • Recheck Cond: (tracker_code = ANY ('{1021240979,1021241132,1021241191,1021243047,1021243062,1021243070,1021244516,1021246644,1021253673,1021253731,1021299140,1021303173,1021305160,1021313552,1021375015,1021451087,1021454420,1021457654,1021460559,1021461946,1021462530,1021462795,1021463850,1021464919,1021467265,1021471820,1021472539,1021473727,1021474576,1021482473,1021483588,1021483711,1021485773,1021485872,1021489817,1021491640,1021492050,1021502734,1021502890,1021504409,1021505596,1021507717,1021553299,1021554008,1021554982,1021729055,1021766032,1021798589,1021804704,1021805016,1021869935,1021871972,1021874802,1021880486,1021882052,1021882763,1021884769,1021889529,1021890840,1021892564,1021895070,1021895096,1021898181,1021898215,1021905069,1021907875,1021936528,1021937369,1021938029,1021950377,1021950529,1021951219,1021961351,1021988724,1021990910,1021998624,1021999010,1022005189,1022007094,1022012259,1022013897,1022017433,1022020172,1022029436,1022035750,1022035867,1022036584,1022037160,1022037822,1022052552,1022059800,1022061160,1022062069,1022063091,1022063109,1022064123,1022064644,1022064847,1022065190,1022066094}'::integer[]))
  • Heap Blocks: exact=32170
44. 6.091 6.091 ↑ 3.3 53,635 1

Bitmap Index Scan on point_2019_08_01_tracker_code_idx (cost=0.00..3,380.75 rows=178,760 width=0) (actual time=6.091..6.091 rows=53,635 loops=1)

  • Index Cond: (tracker_code = ANY ('{1021240979,1021241132,1021241191,1021243047,1021243062,1021243070,1021244516,1021246644,1021253673,1021253731,1021299140,1021303173,1021305160,1021313552,1021375015,1021451087,1021454420,1021457654,1021460559,1021461946,1021462530,1021462795,1021463850,1021464919,1021467265,1021471820,1021472539,1021473727,1021474576,1021482473,1021483588,1021483711,1021485773,1021485872,1021489817,1021491640,1021492050,1021502734,1021502890,1021504409,1021505596,1021507717,1021553299,1021554008,1021554982,1021729055,1021766032,1021798589,1021804704,1021805016,1021869935,1021871972,1021874802,1021880486,1021882052,1021882763,1021884769,1021889529,1021890840,1021892564,1021895070,1021895096,1021898181,1021898215,1021905069,1021907875,1021936528,1021937369,1021938029,1021950377,1021950529,1021951219,1021961351,1021988724,1021990910,1021998624,1021999010,1022005189,1022007094,1022012259,1022013897,1022017433,1022020172,1022029436,1022035750,1022035867,1022036584,1022037160,1022037822,1022052552,1022059800,1022061160,1022062069,1022063091,1022063109,1022064123,1022064644,1022064847,1022065190,1022066094}'::integer[]))
Planning time : 20.152 ms