explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UA9r

Settings
# exclusive inclusive rows x rows loops node
1. 0.047 71.078 ↑ 1.0 1 1

Sort (cost=11,646.56..11,646.56 rows=1 width=194) (actual time=71.077..71.078 rows=1 loops=1)

  • Sort Key: alertimpl2_.created_date DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.016 71.031 ↑ 1.0 1 1

Nested Loop (cost=0.98..11,646.55 rows=1 width=194) (actual time=70.755..71.031 rows=1 loops=1)

3. 0.014 70.965 ↑ 1.0 1 1

Nested Loop (cost=0.42..11,642.73 rows=1 width=200) (actual time=70.690..70.965 rows=1 loops=1)

4. 70.932 70.932 ↑ 1.0 1 1

Seq Scan on alert alertimpl2_ (cost=0.00..11,634.28 rows=1 width=14) (actual time=70.659..70.932 rows=1 loops=1)

  • Filter: (((initiator_component)::text = 'ARM'::text) AND ((initiator_reference)::text = '99951'::text) AND ((status)::text = 'A'::text))
  • Rows Removed by Filter: 278520
5. 0.019 0.019 ↑ 1.0 1 1

Index Scan using pk_alert on alert alertimpl1_ (cost=0.42..8.44 rows=1 width=186) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: (id = alertimpl2_.id)
6. 0.050 0.050 ↑ 1.0 1 1

Index Only Scan using un_alert_recipient_usrnm_alrt on alert_recipient recipienti0_ (cost=0.56..3.81 rows=1 width=6) (actual time=0.049..0.050 rows=1 loops=1)

  • Index Cond: ((username = 'ADHT'::text) AND (alert = alertimpl1_.id))
  • Heap Fetches: 1