explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CmaZO : TEST

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.023 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.00..619.35 rows=11 width=103) (actual time=0.023..0.023 rows=0 loops=1)

2. 0.001 0.023 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.58..33.79 rows=6 width=77) (actual time=0.023..0.023 rows=0 loops=1)

  • Join Filter: (stg.stg_id = syn.stg_id)
3. 0.022 0.022 ↓ 0.0 0 1

Index Scan using stg_pkey on stg (cost=0.29..8.30 rows=1 width=25) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (stg_id = 6170)
  • Filter: supprime
  • Rows Removed by Filter: 1
4. 0.000 0.000 ↓ 0.0 0

Index Scan using pjtsyn_stg_id on pjtsyn syn (cost=0.29..25.42 rows=6 width=56) (never executed)

  • Index Cond: (stg_id = 6170)
5. 0.000 0.000 ↓ 0.0 0

Index Scan using projet_pjtsyn_id on projet pjt (cost=0.42..97.30 rows=29 width=38) (never executed)

  • Index Cond: (pjtsyn_id = syn.pjtsyn_id)
Planning time : 0.613 ms
Execution time : 0.092 ms