explain.depesz.com

PostgreSQL's explain analyze made readable

Result: usva

Settings
# exclusive inclusive rows x rows loops node
1. 70.153 1,158.915 ↓ 6.9 523,308 1

Gather (cost=1,000.00..423,561.84 rows=75,624 width=107) (actual time=1.440..1,158.915 rows=523,308 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
2. 1,088.762 1,088.762 ↓ 5.8 87,218 6 / 6

Parallel Seq Scan on sym_vm_stat_app (cost=0.00..414,999.44 rows=15,125 width=107) (actual time=0.221..1,088.762 rows=87,218 loops=6)

  • Filter: (((application_telephone_cd)::text <> 'CGM_Vehicule'::text) AND ((application_telephone_cd)::text <> 'CGM_Transfert'::text) AND (stat_telephone_hr >= '09:00:00'::time without time zone) AND (stat_telephone_hr <= '18:00:00'::time without time zone) AND ((application_telephone_cd)::text <> 'CGM_AGPM_SCR'::text) AND ((application_telephone_cd)::text <> 'CGM_ActionT_SCR'::text) AND ((application_telephone_cd)::text <> 'CGM_Expert'::text) AND ((application_telephone_cd)::text <> 'CGM_LCDM_scr'::text) AND ((application_telephone_cd)::text <> 'CGM_Nuit'::text) AND ((application_telephone_cd)::text <> 'CGM_RappelLAR_SCR'::text) AND ((application_telephone_cd)::text <> 'CGM_Reparateur'::text) AND ((application_telephone_cd)::text <> 'CGM_RetourEmailing_SCR'::text) AND ((application_telephone_cd)::text <> 'CGM_SIMA_SCR'::text) AND (stat_telephone_dt >= '2018-01-01 00:00:00'::timestamp without time zone) AND (sid_publie_in = 1) AND (strpos((application_telephone_cd)::text, 'DISSU'::text) <= 0) AND (strpos((application_telephone_cd)::text, 'Deleg'::text) <= 0) AND (strpos((application_telephone_cd)::text, 'TRF'::text) <= 0) AND ((strpos((application_telephone_cd)::text, 'CGM'::text) > 0) OR (strpos((application_telephone_cd)::text, 'WCB'::text) > 0) OR ((application_telephone_cd)::text = 'MOTOCISTES_scr'::text)))
  • Rows Removed by Filter: 2,335,610
Planning time : 1.554 ms
Execution time : 1,173.752 ms