explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ymJp

Settings
# exclusive inclusive rows x rows loops node
1. 0.151 2,323.694 ↓ 8.3 190 1

Nested Loop (cost=0.00..366,622.48 rows=23 width=147) (actual time=1,621.854..2,323.694 rows=190 loops=1)

2. 2,322.403 2,322.403 ↓ 8.3 190 1

Seq Scan on specif_numero_de_gravuresup_cs attributsu1_ (cost=0.00..366,424.20 rows=23 width=33) (actual time=1,621.251..2,322.403 rows=190 loops=1)

  • Filter: (((clef)::text = 'sup_Numero_de_gravureSup_id_de_la_ligne'::text) AND ((alpha)::text = '8af48ab46d936d18016d95a59d6f0fec'::text))
  • Rows Removed by Filter: 12492331
3. 1.140 1.140 ↑ 1.0 1 190

Index Scan using specif_numero_de_gravuresup_pkey on specif_numero_de_gravuresup numero_de_0_ (cost=0.00..8.61 rows=1 width=147) (actual time=0.006..0.006 rows=1 loops=190)

  • Index Cond: ((id)::text = (attributsu1_.id_numero_de_gravuresup)::text)
  • Filter: ((datefinvalidite IS NULL) AND ((id)::text !~~ 'DefaultRecord_%'::text))