explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fQsz

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

Nested Loop (cost=309.41..19,970.51 rows=257 width=1,512) (actual time=0.038..0.038 rows=0 loops=1)

  • Buffers: shared hit=2
2. 0.000 0.038 ↓ 0.0 0 1

Nested Loop (cost=308.98..2,223.00 rows=17,225 width=173) (actual time=0.038..0.038 rows=0 loops=1)

  • Buffers: shared hit=2
3. 0.001 0.038 ↓ 0.0 0 1

HashAggregate (cost=9.15..9.16 rows=1 width=8) (actual time=0.038..0.038 rows=0 loops=1)

  • Group Key: provider3_.id
  • Buffers: shared hit=2
4. 0.011 0.037 ↓ 0.0 0 1

Hash Join (cost=2.21..9.14 rows=1 width=8) (actual time=0.037..0.037 rows=0 loops=1)

  • Hash Cond: (provider3_.laboratory_id = module2_.laboratory_id)
  • Buffers: shared hit=2
5. 0.009 0.009 ↑ 67.0 1 1

Seq Scan on provider provider3_ (cost=0.00..6.67 rows=67 width=16) (actual time=0.009..0.009 rows=1 loops=1)

  • Buffers: shared hit=1
6. 0.000 0.017 ↓ 0.0 0 1

Hash (cost=2.20..2.20 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=1
7. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on module module2_ (cost=0.00..2.20 rows=1 width=8) (actual time=0.017..0.017 rows=0 loops=1)

  • Filter: (active AND ((module)::text = 'DMP'::text))
  • Rows Removed by Filter: 96
  • Buffers: shared hit=1
8. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on provider_link providerli0_ (cost=299.83..2,041.60 rows=17,225 width=165) (never executed)

  • Recheck Cond: (provider_id = provider3_.id)
  • Filter: (dmp_enabled AND ((link_state)::text = 'ACTIVE'::text) AND ((link_type)::text = 'PATIENT'::text))
9. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_provider_link_provider_id (cost=0.00..295.53 rows=20,433 width=0) (never executed)

  • Index Cond: (provider_id = provider3_.id)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using activation_code_pkey on activation_code activation1_ (cost=0.43..1.02 rows=1 width=1,347) (never executed)

  • Index Cond: (id = providerli0_.activation_code_id)
  • Filter: (providerli0_.provider_id = provider_id)
Planning time : 3.755 ms