explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NpCA

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

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

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

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

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

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

  • Hash Cond: (sym_vm_stat_agent.equipe_amdm_cd = org_vm_equipe_amdm.equipe_amdm_cd)
4. 300.209 300.209 ↑ 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.049..300.209 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.272 ↓ 1.0 55 6 / 6

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
6. 0.196 0.251 ↓ 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.113..0.251 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.055 0.055 ↑ 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.055..0.055 rows=275 loops=6)

8. 0.225 1.009 ↑ 1.0 1,427 6 / 6

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 67kB
9. 0.672 0.784 ↑ 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.134..0.784 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.112 0.112 ↑ 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.112..0.112 rows=1,427 loops=6)

Planning time : 6.035 ms
Execution time : 1,460.482 ms