explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sGU6

Settings
# exclusive inclusive rows x rows loops node
1. 1.761 19,193.375 ↑ 1.0 1 1

Aggregate (cost=3,534,037.43..3,534,037.44 rows=1 width=8) (actual time=19,193.375..19,193.375 rows=1 loops=1)

2. 30.022 19,191.614 ↑ 1.0 32,764 1

Group (cost=3,532,338.37..3,533,618.85 rows=33,486 width=46) (actual time=19,056.798..19,191.614 rows=32,764 loops=1)

  • Group Key: vcarticle.vcarticle_tag
3. 1,751.565 19,161.592 ↓ 1.6 421,718 1

Sort (cost=3,532,338.37..3,532,978.61 rows=256,096 width=14) (actual time=19,056.796..19,161.592 rows=421,718 loops=1)

  • Sort Key: vcarticle.vcarticle_tag
  • Sort Method: external merge Disk: 10,144kB
4. 966.966 17,410.027 ↓ 1.6 421,718 1

Hash Join (cost=1,953,022.77..3,509,332.85 rows=256,096 width=14) (actual time=13,880.515..17,410.027 rows=421,718 loops=1)

  • Hash Cond: (vcligne.vcligne_vcarticle_id = vcarticle.vcarticle_id)
5. 1,201.704 8,588.215 ↓ 2.5 1,502,118 1

Hash Join (cost=778,845.84..2,281,386.79 rows=609,081 width=8) (actual time=6,021.660..8,588.215 rows=1,502,118 loops=1)

  • Hash Cond: (vcligne.vcligne_vcentete_id = vcentete.vcentete_id)
6. 1,388.340 1,587.107 ↓ 1.0 1,873,292 1

Bitmap Heap Scan on vcligne (cost=51,715.97..1,508,119.77 rows=1,835,256 width=12) (actual time=221.435..1,587.107 rows=1,873,292 loops=1)

  • Recheck Cond: ((vcligne_dossier_id = 15) AND (vcligne_date >= '2019-01-01 00:00:00'::timestamp without time zone) AND (vcligne_date <= '2019-09-30 23:59:59.999999'::timestamp without time zone))
  • Rows Removed by Index Recheck: 102,676
  • Filter: ((vcligne_typelotcalc)::text = ANY ('{"Article simple","Article lot détail","Article assemblé détail"}'::text[]))
  • Rows Removed by Filter: 186
  • Heap Blocks: exact=124,470 lossy=66,870
7. 198.767 198.767 ↓ 1.0 1,876,520 1

Bitmap Index Scan on vcligne_date_sk (cost=0.00..51,257.16 rows=1,836,848 width=0) (actual time=198.767..198.767 rows=1,876,520 loops=1)

  • Index Cond: ((vcligne_dossier_id = 15) AND (vcligne_date >= '2019-01-01 00:00:00'::timestamp without time zone) AND (vcligne_date <= '2019-09-30 23:59:59.999999'::timestamp without time zone))
8. 896.378 5,799.404 ↓ 2.4 6,509,953 1

Hash (cost=682,392.29..682,392.29 rows=2,726,846 width=8) (actual time=5,799.404..5,799.404 rows=6,509,953 loops=1)

  • Buckets: 262,144 (originally 262144) Batches: 32 (originally 16) Memory Usage: 10,004kB
9. 2,710.342 4,903.026 ↓ 2.4 6,509,953 1

Hash Join (cost=16.15..682,392.29 rows=2,726,846 width=8) (actual time=0.122..4,903.026 rows=6,509,953 loops=1)

  • Hash Cond: (vcentete.vcentete_adhetablissement_id = adhetablissement.adhetablissement_id)
10. 2,192.589 2,192.589 ↓ 1.0 8,182,216 1

Seq Scan on vcentete (cost=0.00..624,455.20 rows=8,180,537 width=12) (actual time=0.018..2,192.589 rows=8,182,216 loops=1)

  • Filter: (vcentete_dossier_id = 15)
  • Rows Removed by Filter: 34,445
11. 0.016 0.095 ↓ 1.0 108 1

Hash (cost=14.81..14.81 rows=107 width=8) (actual time=0.095..0.095 rows=108 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
12. 0.079 0.079 ↓ 1.0 108 1

Seq Scan on adhetablissement (cost=0.00..14.81 rows=107 width=8) (actual time=0.009..0.079 rows=108 loops=1)

  • Filter: ((adhetablissement_dossier_id = 15) AND ((adhetablissement_enseignelib)::text = 'Ambiance & Styles'::text))
  • Rows Removed by Filter: 218
13. 1,516.393 7,854.846 ↓ 1.0 6,836,060 1

Hash (cost=1,050,111.23..1,050,111.23 rows=6,757,576 width=22) (actual time=7,854.846..7,854.846 rows=6,836,060 loops=1)

  • Buckets: 262,144 Batches: 64 Memory Usage: 7,932kB
14. 6,338.453 6,338.453 ↓ 1.0 6,836,060 1

Seq Scan on vcarticle (cost=0.00..1,050,111.23 rows=6,757,576 width=22) (actual time=0.013..6,338.453 rows=6,836,060 loops=1)

  • Filter: ((vcarticle_dossier_id = 15) AND ((vcarticle_vcclassif1)::text = 'CUISINE'::text))
  • Rows Removed by Filter: 9,235,704