explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V2xt

Settings
# exclusive inclusive rows x rows loops node
1. 10.092 77,890.847 ↑ 8.1 270 1

GroupAggregate (cost=3,255,005.36..3,255,196.19 rows=2,181 width=317) (actual time=77,879.026..77,890.847 rows=270 loops=1)

  • Buffers: shared hit=23273730 read=35744 written=12
  • I/O Timings: read=5116.879 write=1.985
2. 166.905 77,880.755 ↓ 4.8 10,404 1

Sort (cost=3,255,005.36..3,255,010.81 rows=2,181 width=317) (actual time=77,878.927..77,880.755 rows=10,404 loops=1)

  • Sort Key: t.nom_tournee, t.id_tournee_pc7, vt.version_tournee, vt.id_version_tournee, (count(vtp.id_version_tournee_point)), vtp_1.heure_passage_theorique, vtp_2.heure_passage_theorique, (CASE WHEN ((u.nom)::text <> ''::text) THEN u.nom ELSE u.username END), o.date, o_1.date, (count(vtpprogress.sequence)), tmp.date, tmp.date_reference, tmp.heure_passage_theorique, o_4.date, a_1.nom, pc.code_point, pc.raison_sociale, pc.ville, c.codeclient, c.nom, (count(n.id_notification)), (count(n_1.id_notification)), (CASE WHEN (odem.id_action = 100) THEN 1 WHEN (odem.id_action = 101) THEN 2 ELSE 0 END), (count(DISTINCT o_5.sn))
  • Sort Method: quicksort Memory: 3540kB
  • Buffers: shared hit=23273730 read=35744 written=12
  • I/O Timings: read=5116.879 write=1.985
3. 11.236 77,713.850 ↓ 4.8 10,404 1

Nested Loop Left Join (cost=1,492.19..3,254,884.41 rows=2,181 width=317) (actual time=3.021..77,713.850 rows=10,404 loops=1)

  • Buffers: shared hit=23273730 read=35744 written=12
  • I/O Timings: read=5116.879 write=1.985
4. 13.482 51,307.666 ↓ 4.8 10,404 1

Nested Loop Left Join (cost=1,249.78..2,726,109.31 rows=2,181 width=317) (actual time=3.010..51,307.666 rows=10,404 loops=1)

  • Buffers: shared hit=21640830 read=7429 written=9
  • I/O Timings: read=1328.654 write=0.161
5. 19.577 51,086.104 ↓ 4.8 10,404 1

Nested Loop Left Join (cost=1,239.60..2,703,852.21 rows=2,181 width=313) (actual time=2.983..51,086.104 rows=10,404 loops=1)

  • Buffers: shared hit=21547317 read=7429 written=9
  • I/O Timings: read=1328.654 write=0.161
6. 13.833 39,434.855 ↓ 4.8 10,404 1

Nested Loop Left Join (cost=956.16..2,085,604.14 rows=2,181 width=305) (actual time=1.402..39,434.855 rows=10,404 loops=1)

  • Buffers: shared hit=19986717 read=7429 written=9
  • I/O Timings: read=1328.654 write=0.161
7. 15.559 27,529.250 ↓ 4.8 10,404 1

Nested Loop Left Join (cost=672.72..1,467,356.07 rows=2,181 width=297) (actual time=0.243..27,529.250 rows=10,404 loops=1)

  • Buffers: shared hit=18426117 read=7429 written=9
  • I/O Timings: read=1328.654 write=0.161
8. 8.609 7,548.415 ↓ 4.8 10,404 1

Nested Loop Left Join (cost=353.62..771,357.75 rows=2,181 width=142) (actual time=0.228..7,548.415 rows=10,404 loops=1)

  • Buffers: shared hit=6520998 read=7403 written=9
  • I/O Timings: read=1322.564 write=0.161
9. 17.730 4,678.706 ↓ 4.8 10,404 1

Nested Loop Left Join (cost=200.54..437,431.46 rows=2,181 width=120) (actual time=0.223..4,678.706 rows=10,404 loops=1)

  • Buffers: shared hit=3421886 read=5439 written=9
  • I/O Timings: read=1104.151 write=0.161
10. 15.137 1,903.916 ↓ 4.8 10,404 1

Nested Loop Left Join (cost=47.58..103,766.88 rows=2,181 width=112) (actual time=0.218..1,903.916 rows=10,404 loops=1)

  • Buffers: shared hit=314229 read=1860 written=9
  • I/O Timings: read=876.828 write=0.161
11. 8.678 1,815.951 ↓ 4.8 10,404 1

Nested Loop Left Join (cost=40.99..89,323.21 rows=2,181 width=104) (actual time=0.213..1,815.951 rows=10,404 loops=1)

  • Buffers: shared hit=262607 read=1657 written=9
  • I/O Timings: read=871.208 write=0.161
12. 11.005 870.913 ↓ 4.8 10,404 1

Nested Loop (cost=28.08..61,111.97 rows=2,181 width=64) (actual time=0.193..870.913 rows=10,404 loops=1)

  • Buffers: shared hit=220954 read=1478 written=9
  • I/O Timings: read=52.586 write=0.161
13. 14.204 797.484 ↓ 4.8 10,404 1

Nested Loop (cost=27.79..60,409.11 rows=2,181 width=55) (actual time=0.172..797.484 rows=10,404 loops=1)

  • Buffers: shared hit=189598 read=1478 written=9
  • I/O Timings: read=52.586 write=0.161
14. 10.495 627.220 ↓ 4.8 10,404 1

Nested Loop (cost=19.23..41,691.93 rows=2,181 width=49) (actual time=0.162..627.220 rows=10,404 loops=1)

  • Buffers: shared hit=140686 read=1478 written=9
  • I/O Timings: read=52.586 write=0.161
15. 11.573 429.453 ↓ 4.8 10,404 1

Nested Loop (cost=10.67..22,974.75 rows=2,181 width=43) (actual time=0.146..429.453 rows=10,404 loops=1)

  • Buffers: shared hit=91774 read=1478 written=9
  • I/O Timings: read=52.586 write=0.161
16. 8.871 188.992 ↓ 4.8 10,404 1

Nested Loop (cost=2.24..4,513.83 rows=2,181 width=35) (actual time=0.127..188.992 rows=10,404 loops=1)

  • Buffers: shared hit=43033 read=1307 written=9
  • I/O Timings: read=10.091 write=0.161
17. 26.093 65.677 ↓ 4.8 10,404 1

Hash Join (cost=1.82..2,775.32 rows=2,181 width=16) (actual time=0.101..65.677 rows=10,404 loops=1)

  • Hash Cond: (vtd.id_agence = a.id_agence)
  • Buffers: shared hit=1325 read=1257 written=9
  • I/O Timings: read=8.804 write=0.161
18. 39.575 39.575 ↓ 1.2 77,451 1

Index Scan using date_reference_index on version_tournee_dispo vtd (cost=0.44..2,506.78 rows=65,424 width=20) (actual time=0.028..39.575 rows=77,451 loops=1)

  • Index Cond: (date_reference = '2019-11-13 00:00:00'::timestamp without time zone)
  • Buffers: shared hit=1324 read=1257 written=9
  • I/O Timings: read=8.804 write=0.161
19. 0.002 0.009 ↑ 1.0 1 1

Hash (cost=1.38..1.38 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
  • Buffers: shared hit=1
20. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on agence a (cost=0.00..1.38 rows=1 width=4) (actual time=0.005..0.007 rows=1 loops=1)

  • Filter: (cp = 15)
  • Rows Removed by Filter: 29
  • Buffers: shared hit=1
21. 114.444 114.444 ↑ 1.0 1 10,404

Index Scan using version_tournee_info_pkey on version_tournee vt (cost=0.41..0.79 rows=1 width=19) (actual time=0.010..0.011 rows=1 loops=10,404)

  • Index Cond: (id_version_tournee = vtd.id_version_tournee)
  • Buffers: shared hit=41708 read=50
  • I/O Timings: read=1.287
22. 41.616 228.888 ↑ 1.0 1 10,404

Aggregate (cost=8.43..8.44 rows=1 width=8) (actual time=0.022..0.022 rows=1 loops=10,404)

  • Buffers: shared hit=48741 read=171
  • I/O Timings: read=42.495
23. 187.272 187.272 ↑ 2.3 22 10,404

Index Scan using version_tournee_point_index1 on version_tournee_point vtp (cost=0.43..8.31 rows=50 width=8) (actual time=0.010..0.018 rows=22 loops=10,404)

  • Index Cond: (id_version_tournee = vtd.id_version_tournee)
  • Buffers: shared hit=48741 read=171
  • I/O Timings: read=42.495
24. 10.404 187.272 ↑ 1.0 1 10,404

Limit (cost=8.56..8.56 rows=1 width=8) (actual time=0.018..0.018 rows=1 loops=10,404)

  • Buffers: shared hit=48912
25. 72.828 176.868 ↑ 50.0 1 10,404

Sort (cost=8.56..8.68 rows=50 width=8) (actual time=0.017..0.017 rows=1 loops=10,404)

  • Sort Key: vtp_1.sequence
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=48912
26. 104.040 104.040 ↑ 2.3 22 10,404

Index Scan using version_tournee_point_index1 on version_tournee_point vtp_1 (cost=0.43..8.31 rows=50 width=8) (actual time=0.003..0.010 rows=22 loops=10,404)

  • Index Cond: (id_version_tournee = vtd.id_version_tournee)
  • Buffers: shared hit=48912
27. 10.404 156.060 ↑ 1.0 1 10,404

Limit (cost=8.56..8.56 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=10,404)

  • Buffers: shared hit=48912
28. 52.020 145.656 ↑ 50.0 1 10,404

Sort (cost=8.56..8.68 rows=50 width=8) (actual time=0.014..0.014 rows=1 loops=10,404)

  • Sort Key: vtp_2.sequence
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=48912
29. 93.636 93.636 ↑ 2.3 22 10,404

Index Scan using version_tournee_point_index1 on version_tournee_point vtp_2 (cost=0.43..8.31 rows=50 width=8) (actual time=0.003..0.009 rows=22 loops=10,404)

  • Index Cond: (id_version_tournee = vtd.id_version_tournee)
  • Buffers: shared hit=48912
30. 62.424 62.424 ↑ 1.0 1 10,404

Index Scan using id_tournee_id_agence_index on tournee t (cost=0.28..0.31 rows=1 width=17) (actual time=0.005..0.006 rows=1 loops=10,404)

  • Index Cond: (id_tournee = vt.id_tournee)
  • Buffers: shared hit=31356
31. 10.404 936.360 ↓ 0.0 0 10,404

Limit (cost=12.91..12.92 rows=1 width=26) (actual time=0.090..0.090 rows=0 loops=10,404)

  • Buffers: shared hit=41653 read=179
  • I/O Timings: read=818.622
32. 20.808 925.956 ↓ 0.0 0 10,404

Sort (cost=12.91..12.92 rows=1 width=26) (actual time=0.089..0.089 rows=0 loops=10,404)

  • Sort Key: o.date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=41653 read=179
  • I/O Timings: read=818.622
33. 0.000 905.148 ↓ 0.0 0 10,404

Nested Loop (cost=0.84..12.90 rows=1 width=26) (actual time=0.087..0.087 rows=0 loops=10,404)

  • Buffers: shared hit=41653 read=179
  • I/O Timings: read=818.622
34. 905.148 905.148 ↓ 0.0 0 10,404

Index Scan using index5 on operation o (cost=0.56..6.59 rows=1 width=12) (actual time=0.087..0.087 rows=0 loops=10,404)

  • Index Cond: ((id_version_tournee = vtd.id_version_tournee) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone) AND (id_action = 100))
  • Buffers: shared hit=41509 read=179
  • I/O Timings: read=818.622
35. 0.192 0.192 ↑ 1.0 1 48

Index Scan using user_pkey on "user" u (cost=0.28..6.30 rows=1 width=22) (actual time=0.004..0.004 rows=1 loops=48)

  • Index Cond: (id_user = o.id_user)
  • Buffers: shared hit=144
36. 0.000 72.828 ↑ 1.0 1 10,404

Limit (cost=6.60..6.60 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=10,404)

  • Buffers: shared hit=51622 read=203
  • I/O Timings: read=5.620
37. 20.808 72.828 ↑ 1.0 1 10,404

Sort (cost=6.60..6.60 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=10,404)

  • Sort Key: o_1.date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=51622 read=203
  • I/O Timings: read=5.620
38. 52.020 52.020 ↑ 1.0 1 10,404

Index Scan using index5 on operation o_1 (cost=0.56..6.59 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=10,404)

  • Index Cond: ((id_version_tournee = vtd.id_version_tournee) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone) AND (id_action = 101))
  • Buffers: shared hit=51622 read=203
  • I/O Timings: read=5.620
39. 31.212 2,757.060 ↑ 1.0 1 10,404

Aggregate (cost=152.96..152.97 rows=1 width=2) (actual time=0.265..0.265 rows=1 loops=10,404)

  • Buffers: shared hit=3107657 read=3579
  • I/O Timings: read=227.323
40. 208.080 2,725.848 ↑ 1.5 11 10,404

HashAggregate (cost=152.57..152.74 rows=17 width=10) (actual time=0.260..0.262 rows=11 loops=10,404)

  • Buffers: shared hit=3107657 read=3579
  • I/O Timings: read=227.323
41. 387.822 2,517.768 ↓ 4.0 68 10,404

Nested Loop (cost=0.99..152.49 rows=17 width=10) (actual time=0.018..0.242 rows=68 loops=10,404)

  • Buffers: shared hit=3107657 read=3579
  • I/O Timings: read=227.323
42. 717.876 717.876 ↓ 4.0 68 10,404

Index Scan using index5 on operation o_2 (cost=0.56..42.71 rows=17 width=16) (actual time=0.012..0.069 rows=68 loops=10,404)

  • Index Cond: ((id_version_tournee = vtd.id_version_tournee) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone) AND (id_action = 4))
  • Buffers: shared hit=281425 read=3561
  • I/O Timings: read=224.970
43. 1,412.070 1,412.070 ↑ 1.0 1 706,035

Index Scan using version_tournee_point_pkey on version_tournee_point vtpprogress (cost=0.43..6.45 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=706,035)

  • Index Cond: (id_version_tournee_point = o_2.id_version_tournee_point)
  • Buffers: shared hit=2826232 read=18
  • I/O Timings: read=2.353
44. 10.404 2,861.100 ↑ 1.0 1 10,404

Limit (cost=153.08..153.09 rows=1 width=24) (actual time=0.275..0.275 rows=1 loops=10,404)

  • Buffers: shared hit=3099112 read=1964
  • I/O Timings: read=218.413
45. 52.020 2,850.696 ↑ 17.0 1 10,404

Sort (cost=153.08..153.13 rows=17 width=24) (actual time=0.274..0.274 rows=1 loops=10,404)

  • Sort Key: tmp.sequence
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3099112 read=1964
  • I/O Timings: read=218.413
46. 31.212 2,798.676 ↑ 1.5 11 10,404

Subquery Scan on tmp (cost=152.66..153.00 rows=17 width=24) (actual time=0.266..0.269 rows=11 loops=10,404)

  • Buffers: shared hit=3099112 read=1964
  • I/O Timings: read=218.413
47. 291.312 2,767.464 ↑ 1.5 11 10,404

HashAggregate (cost=152.66..152.83 rows=17 width=24) (actual time=0.265..0.266 rows=11 loops=10,404)

  • Buffers: shared hit=3099112 read=1964
  • I/O Timings: read=218.413
48. 425.658 2,476.152 ↓ 4.0 68 10,404

Nested Loop (cost=0.99..152.49 rows=17 width=24) (actual time=0.021..0.238 rows=68 loops=10,404)

  • Buffers: shared hit=3099112 read=1964
  • I/O Timings: read=218.413
49. 645.048 645.048 ↓ 4.0 68 10,404

Index Scan using index5 on operation o_3 (cost=0.56..42.71 rows=17 width=24) (actual time=0.018..0.062 rows=68 loops=10,404)

  • Index Cond: ((id_version_tournee = vtd.id_version_tournee) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone) AND (id_action = 1))
  • Buffers: shared hit=286110 read=1964
  • I/O Timings: read=218.413
50. 1,405.446 1,405.446 ↑ 1.0 1 702,723

Index Scan using version_tournee_point_pkey on version_tournee_point vtplastpoint (cost=0.43..6.45 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=702,723)

  • Index Cond: (id_version_tournee_point = o_3.id_version_tournee_point)
  • Buffers: shared hit=2813002
51. 10.404 19,965.276 ↑ 1.0 1 10,404

Limit (cost=319.09..319.10 rows=1 width=155) (actual time=1.919..1.919 rows=1 loops=10,404)

  • Buffers: shared hit=11905119 read=26
  • I/O Timings: read=6.090
52. 457.776 19,954.872 ↑ 1.0 1 10,404

Sort (cost=319.09..319.10 rows=1 width=155) (actual time=1.918..1.918 rows=1 loops=10,404)

  • Sort Key: o_4.date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=11905119 read=26
  • I/O Timings: read=6.090
53. 640.782 19,497.096 ↓ 137.0 137 10,404

Nested Loop (cost=15.44..319.08 rows=1 width=155) (actual time=0.049..1.874 rows=137 loops=10,404)

  • Buffers: shared hit=11905119 read=26
  • I/O Timings: read=6.090
54. 3,418.650 16,011.756 ↓ 137.0 137 10,404

Nested Loop (cost=15.16..318.77 rows=1 width=134) (actual time=0.045..1.539 rows=137 loops=10,404)

  • Join Filter: (o_4.id_action = a_1.id_action)
  • Rows Removed by Join Filter: 2324
  • Buffers: shared hit=7635986 read=26
  • I/O Timings: read=6.090
55. 257.706 9,748.548 ↓ 137.0 137 10,404

Nested Loop (cost=15.16..317.37 rows=1 width=56) (actual time=0.042..0.937 rows=137 loops=10,404)

  • Buffers: shared hit=6213707 read=26
  • I/O Timings: read=6.090
56. 665.856 957.168 ↓ 4.4 137 10,404

Bitmap Heap Scan on operation o_4 (cost=14.74..117.26 rows=31 width=23) (actual time=0.033..0.092 rows=137 loops=10,404)

  • Recheck Cond: (((id_version_tournee = vtd.id_version_tournee) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone) AND (id_action = 1)) OR ((id_version_tournee = vtd.id_version_tournee) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone) AND (id_action = 4)) OR ((id_version_tournee = vtd.id_version_tournee) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone) AND (id_action = 100)) OR ((id_version_tournee = vtd.id_version_tournee) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone) AND (id_action = 101)))
  • Buffers: shared hit=497075
57. 20.808 291.312 ↓ 0.0 0 10,404

BitmapOr (cost=14.74..14.74 rows=34 width=0) (actual time=0.028..0.028 rows=0 loops=10,404)

  • Buffers: shared hit=176297
58. 124.848 124.848 ↓ 4.0 68 10,404

Bitmap Index Scan on index5 (cost=0.00..3.78 rows=17 width=0) (actual time=0.012..0.012 rows=68 loops=10,404)

  • Index Cond: ((id_version_tournee = vtd.id_version_tournee) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone) AND (id_action = 1))
  • Buffers: shared hit=46358
59. 104.040 104.040 ↓ 4.0 68 10,404

Bitmap Index Scan on index5 (cost=0.00..3.78 rows=17 width=0) (actual time=0.010..0.010 rows=68 loops=10,404)

  • Index Cond: ((id_version_tournee = vtd.id_version_tournee) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone) AND (id_action = 4))
  • Buffers: shared hit=46563
60. 20.808 20.808 ↓ 0.0 0 10,404

Bitmap Index Scan on index5 (cost=0.00..3.58 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=10,404)

  • Index Cond: ((id_version_tournee = vtd.id_version_tournee) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone) AND (id_action = 100))
  • Buffers: shared hit=41640
61. 20.808 20.808 ↑ 1.0 1 10,404

Bitmap Index Scan on index5 (cost=0.00..3.58 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=10,404)

  • Index Cond: ((id_version_tournee = vtd.id_version_tournee) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone) AND (id_action = 101))
  • Buffers: shared hit=41736
62. 8,533.674 8,533.674 ↑ 1.0 1 1,422,279

Index Scan using id_client_code_point_index on point_client pc (cost=0.42..6.44 rows=1 width=40) (actual time=0.005..0.006 rows=1 loops=1,422,279)

  • Index Cond: ((id_client = o_4.id_client) AND ((code_point)::text = (o_4.code_point)::text))
  • Buffers: shared hit=5716632 read=26
  • I/O Timings: read=6.090
63. 2,844.558 2,844.558 ↑ 1.0 18 1,422,279

Seq Scan on action a_1 (cost=0.00..1.18 rows=18 width=86) (actual time=0.001..0.002 rows=18 loops=1,422,279)

  • Buffers: shared hit=1422279
64. 2,844.558 2,844.558 ↑ 1.0 1 1,422,279

Index Scan using client_pkey on client c (cost=0.28..0.30 rows=1 width=33) (actual time=0.002..0.002 rows=1 loops=1,422,279)

  • Index Cond: (id_client = pc.id_client)
  • Buffers: shared hit=4269133
65. 20.808 11,891.772 ↑ 1.0 1 10,404

Aggregate (cost=283.44..283.45 rows=1 width=8) (actual time=1.143..1.143 rows=1 loops=10,404)

  • Buffers: shared hit=1560600
66. 11,870.964 11,870.964 ↓ 0.0 0 10,404

Seq Scan on notification n (cost=0.00..283.44 rows=1 width=8) (actual time=1.141..1.141 rows=0 loops=10,404)

  • Filter: ((lu_par IS NULL) AND (id_version_tournee = vtd.id_version_tournee) AND (id_sens = 1) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 7839
  • Buffers: shared hit=1560600
67. 20.808 11,631.672 ↑ 1.0 1 10,404

Aggregate (cost=283.44..283.45 rows=1 width=8) (actual time=1.118..1.118 rows=1 loops=10,404)

  • Buffers: shared hit=1560600
68. 11,610.864 11,610.864 ↓ 0.0 0 10,404

Seq Scan on notification n_1 (cost=0.00..283.44 rows=1 width=8) (actual time=1.116..1.116 rows=0 loops=10,404)

  • Filter: ((lu_par IS NULL) AND (id_version_tournee = vtd.id_version_tournee) AND (id_sens = 2) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 7839
  • Buffers: shared hit=1560600
69. 20.808 208.080 ↑ 1.0 1 10,404

Limit (cost=10.18..10.19 rows=1 width=12) (actual time=0.020..0.020 rows=1 loops=10,404)

  • Buffers: shared hit=93513
70. 62.424 187.272 ↑ 1.0 1 10,404

Sort (cost=10.18..10.19 rows=1 width=12) (actual time=0.018..0.018 rows=1 loops=10,404)

  • Sort Key: odem.date
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=93513
71. 124.848 124.848 ↑ 1.0 1 10,404

Index Scan using index5 on operation odem (cost=0.56..10.17 rows=1 width=12) (actual time=0.011..0.012 rows=1 loops=10,404)

  • Index Cond: ((id_version_tournee = vtd.id_version_tournee) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone) AND (id_action = ANY ('{100,101}'::integer[])))
  • Buffers: shared hit=93513
72. 18,082.152 26,394.948 ↑ 1.0 1 10,404

Aggregate (cost=242.42..242.43 rows=1 width=10) (actual time=2.536..2.537 rows=1 loops=10,404)

  • Buffers: shared hit=1632900 read=28315 written=3
  • I/O Timings: read=3788.225 write=1.824
73. 8,312.796 8,312.796 ↓ 13.6 1,428 10,404

Index Scan using index5 on operation o_5 (cost=0.56..242.15 rows=105 width=10) (actual time=0.006..0.799 rows=1,428 loops=10,404)

  • Index Cond: ((id_version_tournee = vtd.id_version_tournee) AND (date_reference = '2019-11-13 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=1632900 read=28315 written=3
  • I/O Timings: read=3788.225 write=1.824
Total runtime : 77,891.376 ms