explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8eXw

Settings
# exclusive inclusive rows x rows loops node
1. 150.856 5,239.518 ↑ 1.8 3,713 1

Gather (cost=1,894,602.54..1,953,599.75 rows=6,548 width=193) (actual time=5,032.929..5,239.518 rows=3,713 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 18.583 5,088.662 ↑ 2.2 743 5 / 5

Parallel Hash Join (cost=1,893,602.54..1,951,944.95 rows=1,637 width=193) (actual time=5,024.652..5,088.662 rows=743 loops=5)

  • 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. 74.258 74.258 ↑ 1.8 740 5 / 5

Parallel Seq Scan on dev_vm_devis_vtm_com_q (cost=0.00..58,314.48 rows=1,331 width=122) (actual time=14.661..74.258 rows=740 loops=5)

  • Filter: ((creation_devis_dt >= '2019-04-01 00:00:00'::timestamp without time zone) AND (numero_maj_id = 1) AND (sid_publie_in = 1) AND (((canal_souscription_cd)::text = 'SA'::text) OR ((evt_devis_cd)::text = 'ACTE'::text)))
  • Rows Removed by Filter: 87,989
4. 450.276 4,995.821 ↓ 1.3 890,963 5 / 5

Parallel Hash (cost=1,883,413.07..1,883,413.07 rows=679,298 width=44) (actual time=4,995.820..4,995.821 rows=890,963 loops=5)

  • Buckets: 8,388,608 Batches: 1 Memory Usage: 419,712kB
5. 4,545.545 4,545.545 ↓ 1.3 890,963 5 / 5

Parallel Seq Scan on dev_vm_vehicule_q (cost=0.00..1,883,413.07 rows=679,298 width=44) (actual time=1,351.292..4,545.545 rows=890,963 loops=5)

  • Filter: ((numero_maj_id = 1) AND (sid_publie_in = 1))
  • Rows Removed by Filter: 9,458,815
Planning time : 3.804 ms
Execution time : 5,239.759 ms