explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NUcT

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.007 0.051 ↓ 0.0 0 1

Sort (cost=104.08..104.08 rows=1 width=56) (actual time=0.051..0.051 rows=0 loops=1)

  • Sort Key: components_componentupdate.display_time
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=18
2. 0.000 0.044 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.15..104.07 rows=1 width=56) (actual time=0.044..0.044 rows=0 loops=1)

  • Filter: ((NOT components_componentgroup.is_deleted) OR (components_componentgroup.is_deleted IS NULL))
  • Buffers: shared hit=18
3. 0.000 0.044 ↓ 0.0 0 1

Nested Loop (cost=0.87..95.75 rows=1 width=60) (actual time=0.044..0.044 rows=0 loops=1)

  • Buffers: shared hit=18
4. 0.001 0.044 ↓ 0.0 0 1

Nested Loop (cost=0.58..87.44 rows=1 width=56) (actual time=0.044..0.044 rows=0 loops=1)

  • Buffers: shared hit=18
5. 0.043 0.043 ↓ 0.0 0 1

Index Scan using components_componentupdate_component_id_2277d20e on components_componentupdate (cost=0.29..79.13 rows=1 width=56) (actual time=0.043..0.043 rows=0 loops=1)

  • Index Cond: (component_id = 11540)
  • Filter: ((NOT is_deleted) AND (new_status IS NOT NULL) AND (display_time >= '2020-01-13 00:00:00+00'::timestamp with time zone) AND (display_time <= '2020-01-13 23:59:59.999999+00'::timestamp with time zone))
  • Rows Removed by Filter: 52
  • Buffers: shared hit=18
6. 0.000 0.000 ↓ 0.0 0

Index Scan using accounts_account_pkey on accounts_account (cost=0.29..8.30 rows=1 width=4) (never executed)

  • Index Cond: (id = components_componentupdate.account_id)
  • Filter: (NOT is_deleted)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using components_component_pkey on components_component (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Index Cond: (id = 11540)
  • Filter: (NOT is_deleted)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using components_componentgroup_pkey on components_componentgroup (cost=0.29..8.30 rows=1 width=5) (never executed)

  • Index Cond: (components_component.group_id = id)
Planning time : 0.543 ms
Execution time : 0.127 ms