explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0aua

Settings
# exclusive inclusive rows x rows loops node
1. 290.294 1,427.224 ↓ 3.3 2,035,559 1

Gather (cost=1,639.61..208,320.22 rows=616,979 width=110) (actual time=1.527..1,427.224 rows=2,035,559 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
2. 763.708 1,136.930 ↓ 2.7 339,260 6 / 6

Hash Join (cost=639.61..145,622.32 rows=123,396 width=110) (actual time=1.521..1,136.930 rows=339,260 loops=6)

  • Hash Cond: (sym_vm_stat_agent.collaborateur_telephone_cd = org_vm_collaborateur.collaborateur_cd)
3. 72.909 372.296 ↓ 2.7 339,260 6 / 6

Hash Join (cost=125.10..129,836.80 rows=123,436 width=50) (actual time=0.526..372.296 rows=339,260 loops=6)

  • Hash Cond: (sym_vm_stat_agent.equipe_amdm_cd = org_vm_equipe_amdm.equipe_amdm_cd)
4. 299.142 299.142 ↑ 1.2 524,525 6 / 6

Parallel Index Scan using sym_vm_stat_agent_stat_telephone_dt_idx on sym_vm_stat_agent (cost=0.43..115,905.63 rows=628,607 width=34) (actual time=0.044..299.142 rows=524,525 loops=6)

  • Index Cond: (stat_telephone_dt >= '2018-01-01 00:00:00'::timestamp without time zone)
  • Filter: ((stat_telephone_hr >= '09:00:00'::time without time zone) AND (stat_telephone_hr <= '18:00:00'::time without time zone) AND (sid_publie_in = 1))
  • Rows Removed by Filter: 1,187
5. 0.021 0.245 ↓ 1.0 55 6 / 6

Hash (cost=123.99..123.99 rows=54 width=24) (actual time=0.244..0.245 rows=55 loops=6)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
6. 0.179 0.224 ↓ 1.0 55 6 / 6

Bitmap Heap Scan on org_vm_equipe_amdm (cost=3.74..123.99 rows=54 width=24) (actual time=0.101..0.224 rows=55 loops=6)

  • Recheck Cond: ((sid_publie_in = 1) OR (sid_frachr_in = 1))
  • Filter: ((sid_publie_in = 1) AND ((bureau_plateau_in = 'B'::bpchar) OR (bureau_plateau_in = 'P'::bpchar)))
  • Rows Removed by Filter: 220
  • Heap Blocks: exact=7
7. 0.045 0.045 ↑ 1.9 275 6 / 6

Bitmap Index Scan on xpk_org_vm_equipe_amdm (cost=0.00..3.72 rows=529 width=0) (actual time=0.045..0.045 rows=275 loops=6)

8. 0.209 0.926 ↑ 1.0 1,427 6 / 6

Hash (cost=496.67..496.67 rows=1,427 width=4) (actual time=0.926..0.926 rows=1,427 loops=6)

  • Buckets: 2,048 Batches: 1 Memory Usage: 67kB
9. 0.613 0.717 ↑ 1.0 1,427 6 / 6

Bitmap Heap Scan on org_vm_collaborateur (cost=14.37..496.67 rows=1,427 width=4) (actual time=0.125..0.717 rows=1,427 loops=6)

  • Recheck Cond: ((sid_publie_in = 1) OR (sid_frachr_in = 1))
  • Filter: (sid_publie_in = 1)
  • Heap Blocks: exact=30
10. 0.104 0.104 ↑ 1.9 1,427 6 / 6

Bitmap Index Scan on xpk_org_vm_collaborateur (cost=0.00..14.01 rows=2,744 width=0) (actual time=0.104..0.104 rows=1,427 loops=6)

Planning time : 5.236 ms
Execution time : 1,481.365 ms