explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LOAN : TEST

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 74.209 ↑ 1.0 100 1

Limit (cost=4,745.71..4,746.96 rows=100 width=469) (actual time=74.159..74.209 rows=100 loops=1)

  • Buffers: shared hit=3179
2. 0.034 74.195 ↑ 22.1 100 1

Unique (cost=4,745.71..4,773.33 rows=2,210 width=469) (actual time=74.158..74.195 rows=100 loops=1)

  • Buffers: shared hit=3179
3. 0.390 74.161 ↑ 22.1 100 1

Sort (cost=4,745.71..4,751.23 rows=2,210 width=469) (actual time=74.155..74.161 rows=100 loops=1)

  • Sort Key: (COALESCE(s.stg_nom, p.nom_client)), p.pjtsyn_id, p.nom_projet_interne, l.libelle
  • Sort Method: quicksort Memory: 45kB
  • Buffers: shared hit=3179
4. 1.285 73.771 ↑ 9.7 228 1

Hash Join (cost=407.06..4,622.94 rows=2,210 width=469) (actual time=4.838..73.771 rows=228 loops=1)

  • Hash Cond: (p.etat = l.idobj)
  • Buffers: shared hit=3179
5. 31.058 72.429 ↑ 1.0 12,505 1

Hash Left Join (cost=399.10..4,576.16 rows=12,703 width=75) (actual time=4.673..72.429 rows=12,505 loops=1)

  • Hash Cond: (p.stg_id = s.stg_id)
  • Filter: (((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 solution'::text))
  • Rows Removed by Filter: 75994
  • Buffers: shared hit=3176
6. 36.731 36.731 ↓ 1.0 88,499 1

Seq Scan on pjtsyn p (cost=0.00..3,944.71 rows=88,468 width=86) (actual time=0.007..36.731 rows=88,499 loops=1)

  • Filter: (NOT supprime)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=3060
7. 2.260 4.640 ↓ 1.0 12,587 1

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

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

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

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

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

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

Seq Scan on def_lib_integer l (cost=0.00..7.91 rows=5 width=23) (actual time=0.016..0.052 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.642 ms
Execution time : 74.309 ms