explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QH1u

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.077 ↑ 2.0 1 1

Unique (cost=28.77..28.79 rows=2 width=97) (actual time=0.073..0.077 rows=1 loops=1)

2. 0.015 0.073 ↑ 1.0 2 1

Sort (cost=28.77..28.77 rows=2 width=97) (actual time=0.071..0.073 rows=2 loops=1)

  • Sort Key: p.name, p.display_name, pu.username
  • Sort Method: quicksort Memory: 25kB
3. 0.005 0.058 ↑ 1.0 2 1

Nested Loop (cost=4.86..28.76 rows=2 width=97) (actual time=0.044..0.058 rows=2 loops=1)

4. 0.008 0.047 ↑ 1.0 2 1

Nested Loop (cost=4.59..28.17 rows=2 width=94) (actual time=0.038..0.047 rows=2 loops=1)

5. 0.009 0.029 ↑ 1.0 2 1

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

  • Recheck Cond: ((image_alias)::text = 'img_jummox7c-31rc'::text)
  • Heap Blocks: exact=2
6. 0.020 0.020 ↑ 1.0 2 1

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

  • Index Cond: ((image_alias)::text = 'img_jummox7c-31rc'::text)
7. 0.010 0.010 ↑ 1.0 1 2

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

  • Index Cond: (id = pi.procedure_id)
8. 0.006 0.006 ↑ 1.0 1 2

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

  • Index Cond: (id = p.responsible_id)