explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NT4R

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.015 ↑ 1.0 1 1

Aggregate (cost=31.4..31.41 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=1)

2. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=27.82..31.4 rows=1 width=0) (actual time=0.013..0.013 rows=0 loops=1)

3. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=3.92..6.37 rows=1 width=32) (actual time=0.013..0.013 rows=0 loops=1)

4. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=3.35..5.59 rows=1 width=50) (actual time=0.013..0.013 rows=0 loops=1)

5. 0.003 0.014 ↓ 0.0 0 1

Aggregate (cost=2.79..2.8 rows=1 width=14) (actual time=0.013..0.014 rows=0 loops=1)

6. 0.011 0.011 ↓ 0.0 0 1

Index Scan using index_list_domains_on_list_id_and_hidden_and_dynamic_hidden on list_domains u0 (cost=0.57..2.79 rows=1 width=14) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((list_id = 177082) AND (hidden = false) AND (dynamic_hidden = true))
  • Filter: (dynamic_hidden AND (NOT hidden))
7. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using domaindb_domain_aliases_tmp_given_domain_domaindb_domain_idx on domaindb_domain_aliases domaindb_domain_aliases (cost=0.56..2.78 rows=1 width=36) (never executed)

  • Index Cond: (given_domain = u0.given_domain)
8. 0.000 0.000 ↓ 0.0 0 0

Index Only Scan using domaindb_tmp_domain_idx on domaindb domaindb (cost=0.56..0.77 rows=1 width=18) (never executed)

  • Index Cond: (domain = (domaindb_domain_aliases.domaindb_domain)::text)
9. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on list_domains list_domains (cost=23.9..25.02 rows=1 width=14) (never executed)

10. 0.000 0.000 ↓ 0.0 0 0

BitmapAnd (cost=23.9..23.9 rows=1 width=0) (never executed)

11. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on index_list_domains_on_given_domain (cost=0..2.1 rows=88 width=0) (never executed)

  • Index Cond: (given_domain = (domaindb_domain_aliases.given_domain)::text)
12. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on index_list_domains_on_list_id_and_hidden_and_dynamic_hidden (cost=0..21.37 rows=720 width=0) (never executed)

  • Index Cond: (list_id = 177082)