explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8TEk

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.120 ↑ 1.0 1 1

Limit (cost=54.84..54.85 rows=1 width=56) (actual time=0.118..0.120 rows=1 loops=1)

  • Buffers: shared hit=113
2. 0.030 0.118 ↑ 3.0 1 1

Sort (cost=54.84..54.85 rows=3 width=56) (actual time=0.117..0.118 rows=1 loops=1)

  • Sort Key: components_componentupdate.display_time DESC
  • Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=113
3. 0.013 0.088 ↓ 10.0 30 1

Nested Loop (cost=1.15..54.83 rows=3 width=56) (actual time=0.027..0.088 rows=30 loops=1)

  • Buffers: shared hit=110
4. 0.005 0.045 ↓ 10.0 30 1

Nested Loop (cost=0.87..29.92 rows=3 width=56) (actual time=0.022..0.045 rows=30 loops=1)

  • Buffers: shared hit=20
5. 0.003 0.013 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.57..16.62 rows=1 width=4) (actual time=0.012..0.013 rows=1 loops=1)

  • Filter: ((NOT components_componentgroup.is_deleted) OR (components_componentgroup.is_deleted IS NULL))
  • Buffers: shared hit=6
6. 0.007 0.007 ↑ 1.0 1 1

Index Scan using components_component_pkey on components_component (cost=0.29..8.31 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (id = 11537)
  • Filter: (NOT is_deleted)
  • Buffers: shared hit=3
7. 0.003 0.003 ↑ 1.0 1 1

Index Scan using components_componentgroup_pkey on components_componentgroup (cost=0.29..8.30 rows=1 width=5) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (components_component.group_id = id)
  • Buffers: shared hit=3
8. 0.027 0.027 ↓ 10.0 30 1

Index Scan using components_componentupdate_component_id_2277d20e on components_componentupdate (cost=0.29..13.27 rows=3 width=56) (actual time=0.009..0.027 rows=30 loops=1)

  • Index Cond: (component_id = 11537)
  • Filter: ((NOT is_deleted) AND (new_status IS NOT NULL) AND (display_time <= '2019-12-30 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 8
  • Buffers: shared hit=14
9. 0.030 0.030 ↑ 1.0 1 30

Index Scan using accounts_account_pkey on accounts_account (cost=0.29..8.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=30)

  • Index Cond: (id = components_componentupdate.account_id)
  • Filter: (NOT is_deleted)
  • Buffers: shared hit=90
Planning time : 0.943 ms
Execution time : 0.183 ms