explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PLxJ

Settings
# exclusive inclusive rows x rows loops node
1. 276.638 1,396.455 ↓ 3.5 2,035,559 1

Gather (cost=1,639.61..199,215.61 rows=575,527 width=110) (actual time=3.397..1,396.455 rows=2,035,559 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
2. 745.331 1,119.817 ↓ 2.9 339,260 6 / 6

Hash Join (cost=639.61..140,662.91 rows=115,105 width=110) (actual time=1.614..1,119.817 rows=339,260 loops=6)

  • Hash Cond: (sym_vm_stat_agent.collaborateur_telephone_cd = org_vm_collaborateur.collaborateur_cd)
3. 73.185 373.443 ↓ 2.9 339,260 6 / 6

Hash Join (cost=125.10..125,903.50 rows=115,140 width=50) (actual time=0.498..373.443 rows=339,260 loops=6)

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

Parallel Index Scan using sym_vm_stat_agent_stat_telephone_dt_idx on sym_vm_stat_agent (cost=0.43..112,900.21 rows=586,361 width=34) (actual time=0.048..299.989 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.269 ↓ 1.0 55 6 / 6

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
6. 0.197 0.248 ↓ 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.112..0.248 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.051 0.051 ↑ 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.051..0.051 rows=275 loops=6)

8. 0.235 1.043 ↑ 1.0 1,427 6 / 6

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 67kB
9. 0.693 0.808 ↑ 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.136..0.808 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.115 0.115 ↑ 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.115..0.115 rows=1,427 loops=6)

Planning time : 7.089 ms
Execution time : 1,451.601 ms