explain.depesz.com

A tool for finding a real cause for slow queries.

Result: I68

options
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0
→

Aggregate (cost=25509.94..25509.95 rows=1 width=0) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=901.67..25503.21 rows=2691 width=0) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0
→

HashAggregate (cost=1.01..1.02 rows=1 width=4) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0
→

Seq Scan on django_site u0 (cost=0.00..1.01 rows=1 width=4) (actual time=.. rows= loops=)

  • Filter: ((name)::text <> 'example.com'::text)
5. 0.000 0.000 ↓ 0.0
→

Bitmap Heap Scan on document_document (cost=900.66..25266.72 rows=18837 width=4) (actual time=.. rows= loops=)

  • Recheck Cond: (document_document.site_id = u0.id)
  • Filter: ((document_document.date_delete IS NULL) AND document_document.is_visible AND (NOT document_document.is_original) AND (document_document.origin = 2) AND (document_document.format = 1))
6. 0.000 0.000 ↓ 0.0
→

Bitmap Index Scan on document_document_site_id (cost=0.00..899.99 rows=41026 width=0) (actual time=.. rows= loops=)

  • Index Cond: (document_document.site_id = u0.id)