explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YlkF

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.079 ↑ 1.0 1 1

Aggregate (cost=8.36..8.37 rows=1 width=8) (actual time=0.079..0.079 rows=1 loops=1)

2. 0.001 0.076 ↓ 0.0 0 1

Nested Loop (cost=1.54..8.36 rows=1 width=0) (actual time=0.076..0.076 rows=0 loops=1)

3. 0.000 0.075 ↓ 0.0 0 1

Nested Loop (cost=1.12..6.81 rows=1 width=350) (actual time=0.075..0.075 rows=0 loops=1)

4. 0.000 0.075 ↓ 0.0 0 1

Nested Loop (cost=0.71..5.26 rows=1 width=526) (actual time=0.075..0.075 rows=0 loops=1)

5. 0.075 0.075 ↓ 0.0 0 1

Index Scan using "idx-order_number" on "order" o (cost=0.56..2.88 rows=1 width=570) (actual time=0.075..0.075 rows=0 loops=1)

  • Index Cond: ((number)::text = '1105047210'::text)
  • Filter: ((NOT deleted) AND (date_time_create >= '2019-03-05 00:00:00'::timestamp without time zone) AND (date_time_create <= '2019-03-07 23:59:59'::timestamp without time zone) AND (order_additional_status_code = 5) AND (order_status_code = 5) AND (order_type_code = 5) AND (((sender_contragent_code)::text = '56090b33d83467dd84bd15ce'::text) OR ((receiver_contragent_code)::text = '56090b33d83467dd84bd15ce'::text) OR ((payer_contragent_code)::text = '56090b33d83467dd84bd15ce'::text)) AND (((receiver)::json ->> 'name'::text) ~~ '%Васина%'::text) AND (((sender)::json ->> 'name'::text) ~~ '%company%'::text) AND (((receiver)::json #>> '{phones,0,number}'::text[]) ~~ '%9295849%'::text) AND (((sender)::json #>> '{phones,0,number}'::text[]) ~~ '%8800555%'::text) AND (((online_shop)::json ->> 'numberDeparture'::text) = 'IdentCityIMR410749210'::text) AND ((((receiver)::json #>> '{address,cityCode}'::text[]))::integer = 44) AND ((((sender)::json #>> '{address,cityCode}'::text[]))::integer = 270))
6. 0.000 0.000 ↓ 0.0 0

Index Scan using "idx-order_status-code-lang" on order_status (cost=0.14..2.37 rows=1 width=8) (never executed)

  • Index Cond: ((code = 5) AND ((lang)::text = 'rus'::text))
  • Filter: ("groupCode" = 3)
7. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "idx-city-code-lang" on city rc (cost=0.42..1.54 rows=1 width=4) (never executed)

  • Index Cond: ((code = 44) AND (lang = 'rus'::text))
  • Heap Fetches: 0
8. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "idx-city-code-lang" on city sc (cost=0.42..1.54 rows=1 width=4) (never executed)

  • Index Cond: ((code = 270) AND (lang = 'rus'::text))
  • Heap Fetches: 0
Planning time : 1.017 ms