explain.depesz.com

PostgreSQL's explain analyze made readable

Result: luwZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 0.222 ↑ 1.0 1 1

Aggregate (cost=7,500.49..7,500.50 rows=1 width=8) (actual time=0.222..0.222 rows=1 loops=1)

2. 0.013 0.204 ↑ 1,221.5 2 1

Hash Join (cost=39.05..7,494.38 rows=2,443 width=8) (actual time=0.149..0.204 rows=2 loops=1)

  • Hash Cond: (identifica1_.identity_type_id = identityty2_.identity_type_id)
3. 0.008 0.178 ↑ 1,221.5 2 1

Nested Loop (cost=37.78..7,459.52 rows=2,443 width=12) (actual time=0.125..0.178 rows=2 loops=1)

4. 0.042 0.096 ↑ 1,221.5 2 1

Bitmap Heap Scan on mst_pm_person_identification identifica1_ (cost=37.36..3,268.06 rows=2,443 width=12) (actual time=0.072..0.096 rows=2 loops=1)

  • Recheck Cond: (upper((identity_reference)::text) = '900519025268'::text)
  • Heap Blocks: exact=2
5. 0.054 0.054 ↑ 1,221.5 2 1

Bitmap Index Scan on mst_pm_person_identification_upper_identity_reference_idx (cost=0.00..36.75 rows=2,443 width=0) (actual time=0.054..0.054 rows=2 loops=1)

  • Index Cond: (upper((identity_reference)::text) = '900519025268'::text)
6. 0.074 0.074 ↑ 1.0 1 2

Index Only Scan using mst_pm_patient_patient_id_idx on mst_pm_patient patient0_ (cost=0.42..1.71 rows=1 width=8) (actual time=0.036..0.037 rows=1 loops=2)

  • Index Cond: (patient_id = identifica1_.patient_id)
  • Heap Fetches: 0
7. 0.006 0.013 ↑ 1.0 12 1

Hash (cost=1.12..1.12 rows=12 width=4) (actual time=0.013..0.013 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
8. 0.007 0.007 ↑ 1.0 12 1

Seq Scan on ref_co_identity_type identityty2_ (cost=0.00..1.12 rows=12 width=4) (actual time=0.003..0.007 rows=12 loops=1)

Planning time : 0.459 ms
Execution time : 0.293 ms