explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WjFc

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 56,066.840 ↑ 1.0 5 1

Limit (cost=1.13..779.99 rows=5 width=421) (actual time=56,066.769..56,066.840 rows=5 loops=1)

2. 0.026 56,066.835 ↑ 8,831.6 5 1

Nested Loop (cost=1.13..6,878,540.14 rows=44,158 width=421) (actual time=56,066.768..56,066.835 rows=5 loops=1)

3. 56,066.709 56,066.709 ↑ 8,831.6 5 1

Index Scan using list_domains_with_timestamps_pkey on list_domains (cost=0.57..6,809,592.42 rows=44,158 width=421) (actual time=56,066.702..56,066.709 rows=5 loops=1)

  • Filter: ((NOT dynamic_hidden) AND (NOT hidden) AND (list_id = 182220))
  • Rows Removed by Filter: 91648985
4. 0.100 0.100 ↑ 1.0 1 5

Index Only Scan using domaindb_domain_aliases_tmp_given_domain_idx_old on domaindb_domain_aliases (cost=0.56..1.55 rows=1 width=18) (actual time=0.020..0.020 rows=1 loops=5)

  • Index Cond: (given_domain = list_domains.given_domain)
  • Heap Fetches: 0