explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W4JP

Settings
# exclusive inclusive rows x rows loops node
1. 0.051 0.193 ↑ 2.0 1 1

Unique (cost=9.55..9.62 rows=2 width=321) (actual time=0.141..0.193 rows=1 loops=1)

2. 0.094 0.142 ↑ 1.0 2 1

Sort (cost=9.55..9.55 rows=2 width=321) (actual time=0.141..0.142 rows=2 loops=1)

  • Sort Key: t.date, t.point_from_ids, t.point_to_ids, t.organization_id, t.created_at, t.updated_at, t.init_point_id, t.chain_hash, (COALESCE(em.meta, '{}'::jsonb)), t.is_imported, em.parent_chain_hash, t.autorepeat_hash, t.is_fbs, (COALESCE(em.round_trip, false))
  • Sort Method: quicksort Memory: 25kB
3. 0.002 0.048 ↑ 1.0 2 1

Nested Loop Left Join (cost=1.40..9.54 rows=2 width=321) (actual time=0.044..0.048 rows=2 loops=1)

  • Join Filter: ((eo.event_uid)::text = (t.uid)::text)
4. 0.001 0.032 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.98..6.06 rows=1 width=314) (actual time=0.031..0.032 rows=1 loops=1)

  • Join Filter: ((em.event_uid)::text = (t.uid)::text)
5. 0.002 0.021 ↑ 1.0 1 1

Nested Loop (cost=0.56..3.61 rows=1 width=255) (actual time=0.020..0.021 rows=1 loops=1)

6. 0.015 0.015 ↑ 1.0 1 1

Index Scan using idx_views_events_v2_uid on events_v2 t (cost=0.42..2.44 rows=1 width=255) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: ((uid)::text = '7fc92b36a792a62bbcee83d64e4703cc'::text)
7. 0.004 0.004 ↑ 1.0 1 1

Index Only Scan using idx_organization_id_and_deleted on organization org (cost=0.14..1.17 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: ((id = t.organization_id) AND (is_deleted = false))
  • Filter: (NOT is_deleted)
  • Heap Fetches: 0
8. 0.010 0.010 ↑ 1.0 1 1

Index Scan using event_meta_event_uid_key on event_meta em (cost=0.42..2.44 rows=1 width=92) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: ((event_uid)::text = '7fc92b36a792a62bbcee83d64e4703cc'::text)
9. 0.014 0.014 ↑ 1.0 2 1

Index Only Scan using idx_event_orders_event_uid on event_orders eo (cost=0.42..3.45 rows=2 width=33) (actual time=0.012..0.014 rows=2 loops=1)

  • Index Cond: (event_uid = '7fc92b36a792a62bbcee83d64e4703cc'::text)
  • Heap Fetches: 2
Planning time : 0.412 ms
Execution time : 0.243 ms