explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yb1M

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

Nested Loop Left Join (cost=4.86..28.76 rows=2 width=97) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.59..28.17 rows=2 width=94) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on procedure_images pi (cost=4.30..11.57 rows=2 width=8) (actual rows= loops=)

  • Recheck Cond: ((image_alias)::text = 'img_jumlngkw-a5xz'::text)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on image_alias_index (cost=0.00..4.30 rows=2 width=0) (actual rows= loops=)

  • Index Cond: ((image_alias)::text = 'img_jumlngkw-a5xz'::text)
5. 0.000 0.000 ↓ 0.0

Index Scan using pk_procedures on procedures p (cost=0.28..8.30 rows=1 width=102) (actual rows= loops=)

  • Index Cond: (id = pi.procedure_id)
6. 0.000 0.000 ↓ 0.0

Index Scan using pk_procedure_users on procedure_users pu (cost=0.27..0.29 rows=1 width=19) (actual rows= loops=)

  • Index Cond: (p.responsible_id = id)