explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XcgG

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

Bitmap Heap Scan on "DG_DEFECT" (cost=22,417.40..22,509.68 rows=23 width=6) (actual rows= loops=)

  • Recheck Cond: (("IDMotherCoil" = 231679) AND (("SystemClass")::text = 'MARQLAT'::text))
2. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=22,417.40..22,417.40 rows=23 width=0) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "IDX_DG_DEFECT_IDMOTHERCOIL" (cost=0.00..757.89 rows=25,776 width=0) (actual rows= loops=)

  • Index Cond: ("IDMotherCoil" = 231679)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "IDX_DG_DEFECT_SYSTEMCLASS" (cost=0.00..21,659.24 rows=630,222 width=0) (actual rows= loops=)

  • Index Cond: (("SystemClass")::text = 'MARQLAT'::text)