explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ulrJ : Optimization for: plan #ewwR

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=2.42..14,467.92 rows=1 width=111) (actual time=0.012..0.012 rows=0 loops=1)

2. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=1.84..14,391.53 rows=1 width=119) (actual time=0.012..0.012 rows=0 loops=1)

3. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=1.27..14,382.93 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=1)

4. 0.012 0.012 ↓ 0.0 0 1

Index Scan using ix_billing_document_attrs_name_value_int on billing_document_attrs billing_document_attrs_2 (cost=0.70..2,182.76 rows=157 width=4) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (((name)::text = 'crit_unique_company_id'::text) AND (value_int = 123))
  • Filter: ((type)::text = 'int'::text)
5. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_billing_document_attrs_owner_id on billing_document_attrs billing_document_attrs_3 (cost=0.57..77.70 rows=1 width=4) (never executed)

  • Index Cond: (owner_id = billing_document_attrs_2.owner_id)
  • Filter: (((type)::text = 'str'::text) AND ((name)::text = 'crit_unique_some_date'::text) AND ((value_str)::text = 'kek'::text))
6. 0.000 0.000 ↓ 0.0 0

Index Scan using billing_document_pkey on billing_document (cost=0.57..8.59 rows=1 width=111) (never executed)

  • Index Cond: (id = billing_document_attrs_2.owner_id)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_billing_document_attrs_owner_id on billing_document_attrs billing_document_attrs_1 (cost=0.57..76.39 rows=1 width=4) (never executed)

  • Index Cond: (owner_id = billing_document.id)
  • Filter: (((type)::text = 'str'::text) AND ((name)::text = 'crit_unique_company_name'::text) AND ((value_str)::text = 'name'::text))
Planning time : 0.955 ms
Execution time : 0.065 ms