explain.depesz.com

PostgreSQL's explain analyze made readable

Result: moSB

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

Nested Loop (cost=4.42..20.91 rows=1 width=43) (actual time=0.047..0.047 rows=0 loops=1)

2. 0.047 0.047 ↓ 0.0 0 1

Seq Scan on module module1_ (cost=0.00..2.26 rows=1 width=8) (actual time=0.047..0.047 rows=0 loops=1)

  • Filter: (laboratory_id = 97)
  • Rows Removed by Filter: 101
3. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on module_parameter modulepara0_ (cost=4.42..18.63 rows=1 width=43) (never executed)

  • Recheck Cond: (module_id = module1_.id)
  • Filter: ((key)::text = ANY ('{PSP,CMCIC_BANQUE,CMCIC_TPE,CMCIC_CLE,CMCIC_CODE,PAYBOX_SITE,PAYBOX_RANG,PAYBOX_IDENTIFIER,PAYBOX_CLE,SYSTEMPAY_SITE,SYSTEMPAY_CLE,VIEW_UNPAID_DOSSIER,EMAIL_SYNTHESE_REGLEMENT,EMAIL_FACTURE_NOTIFICATION}'::text[]))
4. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on module_parameter_module_id (cost=0.00..4.42 rows=19 width=0) (never executed)

  • Index Cond: (module_id = module1_.id)