explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a7A

Settings
# exclusive inclusive rows x rows loops node
1. 11.860 138,787.490 ↓ 5,623.0 5,623 1

Nested Loop Left Join (cost=12.94..4,428.98 rows=1 width=109) (actual time=69,162.831..138,787.490 rows=5,623 loops=1)

  • Filter: (cd.id IS NULL)
2. 70,891.948 74,088.638 ↓ 17.6 5,623 1

Bitmap Heap Scan on alf_content_url cu (cost=12.51..1,250.44 rows=320 width=109) (actual time=69,157.386..74,088.638 rows=5,623 loops=1)

  • Recheck Cond: ((orphan_time > 0) AND (orphan_time < '1545962401713'::bigint) AND (orphan_time IS NOT NULL))
  • Heap Blocks: exact=3907
3. 3,196.690 3,196.690 ↓ 58.6 18,740 1

Bitmap Index Scan on idx_alf_conturl_ot (cost=0.00..12.43 rows=320 width=0) (actual time=3,196.690..3,196.690 rows=18,740 loops=1)

  • Index Cond: ((orphan_time > 0) AND (orphan_time < '1545962401713'::bigint) AND (orphan_time IS NOT NULL))
4. 64,686.992 64,686.992 ↓ 0.0 0 5,623

Index Scan using fk_alf_cont_url on alf_content_data cd (cost=0.43..9.91 rows=2 width=16) (actual time=11.504..11.504 rows=0 loops=5,623)

  • Index Cond: (content_url_id = cu.id)