explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q1bY

Settings
# exclusive inclusive rows x rows loops node
1. 1.190 62.885 ↓ 3.2 6,573 1

Nested Loop (cost=74.91..30,125.68 rows=2,055 width=178) (actual time=2.353..62.885 rows=6,573 loops=1)

2. 14.340 15.684 ↑ 1.2 6,573 1

Bitmap Heap Scan on landing_page_content lpc (cost=74.35..8,663.19 rows=7,748 width=132) (actual time=2.323..15.684 rows=6,573 loops=1)

  • Recheck Cond: ('{33698442,50473589}'::bigint[] && company_key_list)
  • Heap Blocks: exact=6501
3. 1.344 1.344 ↑ 1.2 6,573 1

Bitmap Index Scan on landing_page_content_company_key_list_idx (cost=0.00..72.41 rows=7,748 width=0) (actual time=1.343..1.344 rows=6,573 loops=1)

  • Index Cond: ('{33698442,50473589}'::bigint[] && company_key_list)
4. 46.011 46.011 ↑ 1.0 1 6,573

Index Scan using landing_page_content_key_idx on landing_page lp (cost=0.56..2.76 rows=1 width=54) (actual time=0.006..0.007 rows=1 loops=6,573)

  • Index Cond: (content_key = lpc.landing_page_content_key)
  • Filter: (page_content_type <> 'REDIRECT_PAGE'::seo_aggregates.page_content_type)
  • Rows Removed by Filter: 0
Planning time : 0.450 ms