explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5yrl

Settings
# exclusive inclusive rows x rows loops node
1. 12.724 45.445 ↑ 1.7 3,713 1

Gather (cost=1,116.60..18,827.81 rows=6,383 width=193) (actual time=3.372..45.445 rows=3,713 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
2. 0.214 32.721 ↑ 2.2 928 4 / 4

Nested Loop (cost=116.60..17,189.51 rows=2,059 width=193) (actual time=0.745..32.721 rows=928 loops=4)

3. 7.114 7.545 ↑ 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=0.639..7.545 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,238
4. 0.000 0.431 ↓ 0.0 0 1 / 4

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

5. 0.393 0.393 ↓ 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.571..1.571 rows=8,789 loops=1)

  • Index Cond: ((canal_souscription_cd)::text = 'SA'::text)
6. 0.038 0.038 ↑ 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.152..0.152 rows=1,770 loops=1)

  • Index Cond: ((evt_devis_cd)::text = 'ACTE'::text)
7. 24.962 24.962 ↑ 1.0 1 3,698 / 4

Index Scan using xpk_dev_vm_vehicule_q_1 on dev_vm_vehicule_q (cost=0.56..3.80 rows=1 width=44) (actual time=0.026..0.027 rows=1 loops=3,698)

  • Index Cond: (((devis_id)::text = (dev_vm_devis_vtm_com_q.numero_devis_id)::text) AND (numero_maj_id = 1) AND (objet_id = dev_vm_devis_vtm_com_q.objet_id))
  • Filter: (sid_publie_in = 1)
Planning time : 2.037 ms
Execution time : 45.660 ms