explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 163W : TEST

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 57.514 ↓ 0.0 0 1

Limit (cost=4,659.33..4,660.58 rows=100 width=469) (actual time=57.514..57.514 rows=0 loops=1)

  • Buffers: shared hit=3179
2. 0.001 57.513 ↓ 0.0 0 1

Unique (cost=4,659.33..4,673.15 rows=1,105 width=469) (actual time=57.513..57.513 rows=0 loops=1)

  • Buffers: shared hit=3179
3. 0.011 57.512 ↓ 0.0 0 1

Sort (cost=4,659.33..4,662.10 rows=1,105 width=469) (actual time=57.512..57.512 rows=0 loops=1)

  • Sort Key: (COALESCE(s.stg_nom, p.nom_client)), p.pjtsyn_id, p.nom_projet_interne, l.libelle
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3179
4. 0.007 57.501 ↓ 0.0 0 1

Hash Join (cost=407.06..4,603.48 rows=1,105 width=469) (actual time=57.501..57.501 rows=0 loops=1)

  • Hash Cond: (p.etat = l.idobj)
  • Buffers: shared hit=3179
5. 17.661 57.436 ↓ 0.0 0 1

Hash Left Join (cost=399.10..4,576.11 rows=6,350 width=75) (actual time=57.436..57.436 rows=0 loops=1)

  • Hash Cond: (p.stg_id = s.stg_id)
  • Filter: (COALESCE(s.modele, false) AND (((s.stg_nom)::text ~~ 'VINCI CONSTRUCTION'::text) OR ((p.nom_client)::text ~~ '0022CLU4'::text) OR (p.nom_projet_interne ~~ 'ie de solution'::text) OR (p.nom_projet_client ~~ 'Vie de solutio (...)
  • Rows Removed by Filter: 88471
  • Buffers: shared hit=3176
6. 35.357 35.357 ↓ 1.0 88,471 1

Seq Scan on pjtsyn p (cost=0.00..3,944.71 rows=88,447 width=86) (actual time=0.007..35.357 rows=88,471 loops=1)

  • Filter: ((modele IS NULL) AND (NOT supprime))
  • Rows Removed by Filter: 29
  • Buffers: shared hit=3060
7. 2.030 4.418 ↓ 1.0 12,587 1

Hash (cost=241.82..241.82 rows=12,582 width=26) (actual time=4.418..4.418 rows=12,587 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 866kB
  • Buffers: shared hit=116
8. 2.388 2.388 ↓ 1.0 12,587 1

Seq Scan on stg s (cost=0.00..241.82 rows=12,582 width=26) (actual time=0.007..2.388 rows=12,587 loops=1)

  • Buffers: shared hit=116
9. 0.005 0.058 ↑ 1.0 5 1

Hash (cost=7.91..7.91 rows=5 width=23) (actual time=0.058..0.058 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=3
10. 0.053 0.053 ↑ 1.0 5 1

Seq Scan on def_lib_integer l (cost=0.00..7.91 rows=5 width=23) (actual time=0.017..0.053 rows=5 loops=1)

  • Filter: (((typobj)::text = 'PJTCPX'::text) AND ((lang)::text = 'fr'::text))
  • Rows Removed by Filter: 322
  • Buffers: shared hit=3
Planning time : 0.640 ms
Execution time : 57.609 ms