explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e718

Settings
# exclusive inclusive rows x rows loops node
1. 401.641 1,729.499 ↓ 38.0 55,677 1

Sort (cost=66,681.46..66,685.12 rows=1,466 width=587) (actual time=1,635.927..1,729.499 rows=55,677 loops=1)

  • Sort Key: sillonbd0_.sillon_id
  • Sort Method: external merge Disk: 29616kB
  • Buffers: shared hit=404677, temp read=3705 written=3705
2. 169.611 1,327.858 ↓ 38.0 55,677 1

Nested Loop Left Join (cost=62,490.38..66,604.36 rows=1,466 width=587) (actual time=67.823..1,327.858 rows=55,677 loops=1)

  • Buffers: shared hit=404676
3. 88.830 805.096 ↓ 32.0 39,239 1

Nested Loop Left Join (cost=62,489.95..65,860.41 rows=1,228 width=447) (actual time=67.798..805.096 rows=39,239 loops=1)

  • Buffers: shared hit=241279
4. 80.487 559.310 ↓ 32.0 39,239 1

Nested Loop Left Join (cost=62,489.66..65,469.52 rows=1,228 width=413) (actual time=67.779..559.310 rows=39,239 loops=1)

  • Buffers: shared hit=162613
5. 62.849 243.389 ↓ 32.0 39,239 1

Nested Loop Left Join (cost=62,489.24..64,913.46 rows=1,228 width=346) (actual time=67.756..243.389 rows=39,239 loops=1)

  • Buffers: shared hit=38455
6. 5.808 115.137 ↓ 5.7 1,521 1

Nested Loop Left Join (cost=62,488.81..62,852.84 rows=269 width=270) (actual time=67.715..115.137 rows=1,521 loops=1)

  • Buffers: shared hit=31417
7. 6.036 94.119 ↓ 5.7 1,521 1

Nested Loop (cost=62,488.39..62,681.86 rows=269 width=215) (actual time=67.688..94.119 rows=1,521 loops=1)

  • Buffers: shared hit=25306
8. 4.622 69.831 ↓ 32.4 1,521 1

HashAggregate (cost=62,487.98..62,488.45 rows=47 width=16) (actual time=67.651..69.831 rows=1,521 loops=1)

  • Group Key: pointremar6_.pr_sillon_id
  • Buffers: shared hit=19202
9. 8.044 65.209 ↓ 2.0 1,521 1

Nested Loop (cost=249.00..62,486.08 rows=758 width=16) (actual time=7.042..65.209 rows=1,521 loops=1)

  • Buffers: shared hit=19202
10. 23.416 26.735 ↑ 1.1 3,043 1

Bitmap Heap Scan on t_sil_pr pointremar6_ (cost=248.57..23,063.43 rows=3,320 width=32) (actual time=5.990..26.735 rows=3,043 loops=1)

  • Recheck Cond: ((pr_lieu)::text = '0087;271007;44'::text)
  • Filter: ((pr_sillon_date_circulation >= '2019-02-07 00:00:00+01'::timestamp with time zone) AND (pr_sillon_date_circulation < '2019-02-09 00:00:00+01'::timestamp with time zone))
  • Rows Removed by Filter: 5840
  • Heap Blocks: exact=6949
  • Buffers: shared hit=6993
11. 3.319 3.319 ↑ 1.0 8,883 1

Bitmap Index Scan on t_sil_pr_pr_lieu_idx (cost=0.00..247.74 rows=8,974 width=0) (actual time=3.319..3.319 rows=8,883 loops=1)

  • Index Cond: ((pr_lieu)::text = '0087;271007;44'::text)
  • Buffers: shared hit=44
12. 30.430 30.430 ↓ 0.0 0 3,043

Index Scan using horaire_pr_id_idx on t_sil_horaire prhoraireb8_ (cost=0.43..11.86 rows=1 width=16) (actual time=0.009..0.010 rows=0 loops=3,043)

  • Index Cond: (horaire_pr_id = pointremar6_.pr_id)
  • Filter: ((horaire_date_heure_planifie >= '2019-02-08 00:00:00+01'::timestamp with time zone) AND (horaire_date_heure_planifie < '2019-02-09 00:00:00+01'::timestamp with time zone))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=12209
13. 18.252 18.252 ↑ 1.0 1 1,521

Index Scan using t_sil_sillon_pkey on t_sil_sillon sillonbd0_ (cost=0.42..4.11 rows=1 width=215) (actual time=0.011..0.012 rows=1 loops=1,521)

  • Index Cond: ((sillon_id = pointremar6_.pr_sillon_id) AND (sillon_date_circulation >= '2019-02-07 00:00:00+01'::timestamp with time zone) AND (sillon_date_circulation < '2019-02-09 00:00:00+01'::timestamp with time zone))
  • Filter: (NOT sillon_supprime)
  • Buffers: shared hit=6104
14. 15.210 15.210 ↑ 1.0 1 1,521

Index Scan using commande_sillon_id_idx on t_sil_commande silloncomm1_ (cost=0.42..0.63 rows=1 width=55) (actual time=0.009..0.010 rows=1 loops=1,521)

  • Index Cond: ((sillonbd0_.sillon_id = commande_sillon_id) AND (sillonbd0_.sillon_date_circulation = commande_sillon_date_circulation))
  • Buffers: shared hit=6111
15. 65.403 65.403 ↓ 2.6 26 1,521

Index Scan using pr_sillon_id_idx on t_sil_pr sillonpoin2_ (cost=0.43..7.56 rows=10 width=76) (actual time=0.012..0.043 rows=26 loops=1,521)

  • Index Cond: ((sillonbd0_.sillon_id = pr_sillon_id) AND (sillonbd0_.sillon_date_circulation = pr_sillon_date_circulation))
  • Buffers: shared hit=7038
16. 235.434 235.434 ↓ 0.0 0 39,239

Index Scan using voie_locale_pr_id_idx on t_sil_voie_locale prvoieloca4_ (cost=0.42..0.44 rows=1 width=67) (actual time=0.005..0.006 rows=0 loops=39,239)

  • Index Cond: (sillonpoin2_.pr_id = voie_locale_pr_id)
  • Buffers: shared hit=124158
17. 156.956 156.956 ↓ 0.0 0 39,239

Index Scan using signe_conventionnel_pr_id_idx on t_sil_signe_conventionnel prsignecon5_ (cost=0.29..0.31 rows=1 width=34) (actual time=0.004..0.004 rows=0 loops=39,239)

  • Index Cond: (sillonpoin2_.pr_id = signe_conv_pr_id)
  • Buffers: shared hit=78666
18. 353.151 353.151 ↑ 2.0 1 39,239

Index Scan using horaire_pr_id_idx on t_sil_horaire prhoraireb3_ (cost=0.43..0.59 rows=2 width=140) (actual time=0.008..0.009 rows=1 loops=39,239)

  • Index Cond: (sillonpoin2_.pr_id = horaire_pr_id)
  • Buffers: shared hit=163397