explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sTZy

Settings
# exclusive inclusive rows x rows loops node
1. 0.178 1,513.045 ↓ 7.6 190 1

Nested Loop (cost=41,528.10..247,206.80 rows=25 width=9) (actual time=1,445.750..1,513.045 rows=190 loops=1)

  • Output: numero_de_0_.code
  • Buffers: shared hit=757 read=169951 dirtied=2
2. 1,312.531 1,512.297 ↓ 7.6 190 1

Bitmap Heap Scan on public.specif_numero_de_gravuresup_cs attributsu1_ (cost=41,528.10..246,990.57 rows=25 width=33) (actual time=1,445.693..1,512.297 rows=190 loops=1)

  • Output: attributsu1_.id_numero_de_gravuresup, attributsu1_.alpha, attributsu1_.numerique, attributsu1_.date, attributsu1_.heure, attributsu1_.clef
  • Recheck Cond: ((attributsu1_.clef)::text = 'sup_Numero_de_gravureSup_id_de_la_ligne'::text)
  • Filter: ((attributsu1_.alpha)::text = '8af48ab46e3d95e6016e4180e48650f4'::text)
  • Rows Removed by Filter: 648808
  • Buffers: shared hit=1 read=169941 dirtied=2
3. 199.766 199.766 ↑ 1.1 648,998 1

Bitmap Index Scan on numero_gravure_ligne (cost=0.00..41,528.09 rows=682,898 width=0) (actual time=199.766..199.766 rows=648,998 loops=1)

  • Index Cond: ((attributsu1_.clef)::text = 'sup_Numero_de_gravureSup_id_de_la_ligne'::text)
  • Buffers: shared read=8607
4. 0.570 0.570 ↑ 1.0 1 190

Index Scan using specif_numero_de_gravuresup_pkey on public.specif_numero_de_gravuresup numero_de_0_ (cost=0.00..8.64 rows=1 width=42) (actual time=0.003..0.003 rows=1 loops=190)

  • Output: numero_de_0_.id, numero_de_0_.datefinvalidite, numero_de_0_.code, numero_de_0_.libelle, numero_de_0_.datecreationsysteme, numero_de_0_.datemodificationsysteme, numero_de_0_.id_creeparsysteme, numero_de_0_.id_modifieparsysteme
  • Index Cond: ((numero_de_0_.id)::text = (attributsu1_.id_numero_de_gravuresup)::text)
  • Filter: ((numero_de_0_.datefinvalidite IS NULL) AND ((numero_de_0_.id)::text !~~ 'DefaultRecord_%'::text))
  • Buffers: shared hit=756 read=10
Total runtime : 1,514.507 ms