explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GNd5

Settings
# exclusive inclusive rows x rows loops node
1. 150.797 6,134.380 ↑ 1.8 3,713 1

Gather (cost=1,894,718.58..1,905,747.30 rows=6,740 width=193) (actual time=5,987.640..6,134.380 rows=3,713 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
2. 19.898 5,983.583 ↑ 2.3 928 4 / 4

Parallel Hash Join (cost=1,893,718.58..1,904,073.30 rows=2,174 width=193) (actual time=5,971.920..5,983.583 rows=928 loops=4)

  • Hash Cond: (((dev_vm_devis_vtm_com_q.numero_devis_id)::text = (dev_vm_vehicule_q.devis_id)::text) AND (dev_vm_devis_vtm_com_q.objet_id = dev_vm_vehicule_q.objet_id))
3. 8.524 8.786 ↑ 1.9 924 4 / 4

Parallel Bitmap Heap Scan on dev_vm_devis_vtm_com_q (cost=116.04..10,433.67 rows=1,767 width=122) (actual time=2.504..8.786 rows=924 loops=4)

  • Recheck Cond: ((((canal_souscription_cd)::text = 'SA'::text) AND ((sid_publie_in = 1) OR (sid_frachr_in = 1))) OR (((evt_devis_cd)::text = 'ACTE'::text) AND ((sid_publie_in = 1) OR (sid_frachr_in = 1))))
  • Filter: ((creation_devis_dt >= '2019-04-01 00:00:00'::timestamp without time zone) AND (numero_maj_id = 1) AND (sid_publie_in = 1))
  • Rows Removed by Filter: 1,332
  • Heap Blocks: exact=1,043
4. 0.001 0.262 ↓ 0.0 0 1 / 4

BitmapOr (cost=116.04..116.04 rows=10,594 width=0) (actual time=1.048..1.048 rows=0 loops=1)

5. 0.228 0.228 ↓ 1.0 8,789 1 / 4

Bitmap Index Scan on xfk_dev_vm_devis_vtm_com_q_2 (cost=0.00..93.83 rows=8,787 width=0) (actual time=0.913..0.913 rows=8,789 loops=1)

  • Index Cond: ((canal_souscription_cd)::text = 'SA'::text)
6. 0.033 0.033 ↑ 1.0 1,770 1 / 4

Bitmap Index Scan on xfk_dev_vm_devis_vtm_com_q_3 (cost=0.00..19.48 rows=1,807 width=0) (actual time=0.132..0.132 rows=1,770 loops=1)

  • Index Cond: ((evt_devis_cd)::text = 'ACTE'::text)
7. 517.591 5,954.899 ↓ 1.6 1,113,704 4 / 4

Parallel Hash (cost=1,883,413.07..1,883,413.07 rows=679,298 width=44) (actual time=5,954.899..5,954.899 rows=1,113,704 loops=4)

  • Buckets: 8,388,608 Batches: 1 Memory Usage: 419,680kB
8. 5,437.308 5,437.308 ↓ 1.6 1,113,704 4 / 4

Parallel Seq Scan on dev_vm_vehicule_q (cost=0.00..1,883,413.07 rows=679,298 width=44) (actual time=1,578.753..5,437.308 rows=1,113,704 loops=4)

  • Filter: ((numero_maj_id = 1) AND (sid_publie_in = 1))
  • Rows Removed by Filter: 11,823,518
Planning time : 1.419 ms
Execution time : 6,134.620 ms