explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gug5 : Optimization for: plan #EZug

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.008 0.020 ↓ 0.0 0 1

Hash Join (cost=5.46..10.81 rows=2 width=176) (actual time=0.020..0.020 rows=0 loops=1)

  • Hash Cond: (dbpatientc0_.doctor_user_account_uid = dbuser1_.uid)
2. 0.002 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on patient_contact_info_activity dbpatientc0_ (cost=4.16..9.50 rows=2 width=176) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: (patient_contact_info_uid = '1b951370-9f8e-458d-8fde-64d702a1fa55'::uuid)
3. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on patient_contact_info_activity_patient_contact_info_uid_idx (cost=0.00..4.16 rows=2 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (patient_contact_info_uid = '1b951370-9f8e-458d-8fde-64d702a1fa55'::uuid)
4. 0.003 0.006 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=16) (actual time=0.006..0.006 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
5. 0.003 0.003 ↑ 1.0 13 1

Seq Scan on user_account dbuser1_ (cost=0.00..1.13 rows=13 width=16) (actual time=0.002..0.003 rows=13 loops=1)