explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3qZa

Settings
# exclusive inclusive rows x rows loops node
1. 54.666 470,567.994 ↓ 26,301.0 26,301 1

Nested Loop Left Join (cost=46.82..19,034.31 rows=1 width=109) (actual time=62,835.387..470,567.994 rows=26,301 loops=1)

  • Filter: (cd.id IS NULL)
2. 244,601.313 250,926.279 ↓ 18.7 26,301 1

Bitmap Heap Scan on alf_content_url cu (cost=46.38..5,242.11 rows=1,408 width=109) (actual time=62,829.456..250,926.279 rows=26,301 loops=1)

  • Recheck Cond: ((orphan_time > 0) AND (orphan_time < '1545876001373'::bigint) AND (orphan_time IS NOT NULL))
  • Heap Blocks: exact=11122
3. 6,324.966 6,324.966 ↓ 20.1 28,301 1

Bitmap Index Scan on idx_alf_conturl_ot (cost=0.00..46.03 rows=1,408 width=0) (actual time=6,324.966..6,324.966 rows=28,301 loops=1)

  • Index Cond: ((orphan_time > 0) AND (orphan_time < '1545876001373'::bigint) AND (orphan_time IS NOT NULL))
4. 219,587.049 219,587.049 ↓ 0.0 0 26,301

Index Scan using fk_alf_cont_url on alf_content_data cd (cost=0.43..9.78 rows=2 width=16) (actual time=8.349..8.349 rows=0 loops=26,301)

  • Index Cond: (content_url_id = cu.id)