explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 74Qo

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.028 ↑ 1.0 1 1

Nested Loop (cost=1.84..10.72 rows=1 width=7) (actual time=0.025..0.028 rows=1 loops=1)

2. 0.002 0.020 ↓ 2.0 2 1

Nested Loop (cost=1.69..10.53 rows=1 width=11) (actual time=0.020..0.020 rows=2 loops=1)

3. 0.014 0.014 ↑ 1.0 1 1

Index Scan using "idx$$_006d0001" on app a (cost=0.28..2.70 rows=1 width=7) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: (lower((subdomain)::text) = 'bedazzle-kolomyjka'::text)
4. 0.001 0.004 ↑ 3.5 2 1

Bitmap Heap Scan on app_base_domain abd (cost=1.41..7.76 rows=7 width=34) (actual time=0.004..0.004 rows=2 loops=1)

  • Recheck Cond: (app_id = a.id)
  • Heap Blocks: exact=1
5. 0.003 0.003 ↑ 3.5 2 1

Bitmap Index Scan on idx_app_id (cost=0.00..1.41 rows=7 width=0) (actual time=0.003..0.003 rows=2 loops=1)

  • Index Cond: (app_id = a.id)
6. 0.008 0.008 ↓ 0.0 0 2

Index Scan using base_domain_pkey on base_domain bd (cost=0.15..0.18 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=2)

  • Index Cond: (id = abd.base_domain_id)
  • Filter: ((domain)::text = 'xna.ningops.net'::text)
  • Rows Removed by Filter: 0