explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2tdO

Settings
# exclusive inclusive rows x rows loops node
1. 16.996 69.212 ↑ 1.3 2,965 1

Gather (cost=1,117.18..21,810.90 rows=3,724 width=674) (actual time=4.251..69.212 rows=2,965 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
2. 0.820 52.216 ↑ 1.6 741 4 / 4

Nested Loop (cost=117.18..20,438.50 rows=1,201 width=674) (actual time=0.942..52.216 rows=741 loops=4)

3. 0.777 30.941 ↑ 1.7 787 4 / 4

Nested Loop (cost=116.62..15,233.79 rows=1,335 width=123) (actual time=0.847..30.941 rows=787 loops=4)

4. 8.499 8.976 ↑ 2.3 785 4 / 4

Parallel Bitmap Heap Scan on dev_vm_devis_vtm_com_q (cost=116.07..10,425.16 rows=1,785 width=109) (actual time=0.731..8.976 rows=785 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-09-22 00:00:00'::timestamp without time zone) AND (sid_publie_in = 1))
  • Rows Removed by Filter: 1,471
  • Heap Blocks: exact=1,148
5. 0.000 0.477 ↓ 0.0 0 1 / 4

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

6. 0.433 0.433 ↓ 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=1.732..1.732 rows=8,789 loops=1)

  • Index Cond: ((canal_souscription_cd)::text = 'SA'::text)
7. 0.044 0.044 ↑ 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.177..0.177 rows=1,770 loops=1)

  • Index Cond: ((evt_devis_cd)::text = 'ACTE'::text)
8. 21.188 21.188 ↑ 1.0 1 3,139 / 4

Index Scan using xpk_dev_vm_vehicule_q_1 on dev_vm_vehicule_q (cost=0.56..2.68 rows=1 width=47) (actual time=0.027..0.027 rows=1 loops=3,139)

  • Index Cond: (((devis_id)::text = (dev_vm_devis_vtm_com_q.numero_devis_id)::text) AND (numero_maj_id = dev_vm_devis_vtm_com_q.numero_maj_id) AND (objet_id = dev_vm_devis_vtm_com_q.objet_id))
  • Filter: (sid_publie_in = 1)
9. 20.456 20.456 ↑ 1.0 1 3,147 / 4

Index Scan using xpk_per_vm_prospect_q on per_vm_prospect_q (cost=0.56..3.88 rows=1 width=508) (actual time=0.026..0.026 rows=1 loops=3,147)

  • Index Cond: ((prospect_id)::text = (dev_vm_devis_vtm_com_q.prospect_id)::text)
  • Filter: ((sid_publie_in = 1) AND (((telephone_perso_nu IS NOT NULL) AND (length((telephone_perso_nu)::text) <> 0)) OR (dev_vm_devis_vtm_com_q.societaire_nu <> 0) OR ((telephone_pro_nu IS NOT NULL) AND (length((telephone_pro_nu)::text) <> 0)) OR ((telephone_mobile_nu IS NOT NULL) AND (length((telephone_mobile_nu)::text) <> 0)) OR ((telephone_mobile_nu IS NOT NULL) AND (length((telephone_mobile_nu)::text) <> 0) AND (strpos((mail_lb)::text, '@'::text) > 0))))
  • Rows Removed by Filter: 0
Planning time : 8.368 ms
Execution time : 69.513 ms