explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IyqL : TEST

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 31,484.739 ↓ 0.0 0 1

Nested Loop (cost=1,013.20..230,752.90 rows=1 width=54) (actual time=31,484.739..31,484.739 rows=0 loops=1)

2. 46.619 31,522.683 ↓ 4.0 4 1

Gather (cost=1,012.77..230,751.40 rows=1 width=54) (actual time=31,482.199..31,522.683 rows=4 loops=1)

  • Workers Planned: 2
3. 416.520 31,476.064 ↓ 0.0 1 3

Workers Launched: 2 229751.30 rows=1 width=54) (cost=0..0 rows=0 width=0) (actual time=30,227.006..31,476.064 rows=1 loops=3)

4. 739.009 31,053.655 ↓ 3.0 72 3

Hash Join (cost=12.34..229,739.25 rows=24 width=25) (actual time=271.417..31,053.655 rows=72 loops=3)

  • Hash Cond: ((vrs.id_sous_compte)::text = (ctr.num_interne_contrat)::text)
5. 30,309.234 30,309.234 ↑ 1.2 1,749,202 3

Parallel Seq Scan on satin_vrs_svc vrs (cost=0.00..223,443.12 rows=2,185,612 width=19) (actual time=3.321..30,309.234 rows=1,749,202 loops=3)

6. 0.007 5.412 ↑ 2.0 1 3

Hash (cost=12.31..12.31 rows=2 width=16) (actual time=5.411..5.412 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.023 5.405 ↑ 2.0 1 3

Bitmap Heap Scan on sig_contrat ctr (cost=4.44..12.31 rows=2 width=16) (actual time=5.405..5.405 rows=1 loops=3)

  • Recheck Cond: ((num_compte)::text = '7575000'::text)
  • Heap Blocks: exact=1
8. 5.382 5.382 ↑ 2.0 1 3

Bitmap Index Scan on sig_contrat_num_compte_idx (cost=0.00..4.43 rows=2 width=0) (actual time=5.382..5.382 rows=1 loops=3)

  • Index Cond: ((num_compte)::text = '7575000'::text)
9. 5.889 5.889 ↓ 0.0 0 215

Index Scan using si_satin_svc_num_svc_vrs_active_idx on satin_svc s (cost=0.43..0.49 rows=1 width=36) (actual time=5.889..5.889 rows=0 loops=215)

  • Index Cond: ((num_svc_vrs_active)::text = (vrs.num_svc_vrs)::text)
  • Filter: (((code_etat)::text <> ALL ('{ANNULE,RESILIE}'::text[])) AND ((type_svc)::text = 'CORPORATE'::text))
  • Rows Removed by Filter: 0
10. 2.520 2.520 ↓ 0.0 0 4

Index Scan using satin_svc_wed_pkey on satin_svc_wed w (cost=0.43..1.50 rows=1 width=11) (actual time=0.630..0.630 rows=0 loops=4)

  • Index Cond: ((num_svc)::text = (s.num_svc)::text)
  • Filter: ((svccmd_id IS NULL) OR (svccmd_id = 0))
  • Rows Removed by Filter: 1
Planning time : 31.652 ms
Execution time : 31,525.403 ms