explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3cYu

Settings
# exclusive inclusive rows x rows loops node
1. 2.738 11,898.886 ↑ 45.1 1,133 1

Nested Loop (cost=1.28..76,251.05 rows=51,075 width=157) (actual time=90.254..11,898.886 rows=1,133 loops=1)

2. 0.026 37.021 ↑ 3.6 7 1

HashAggregate (cost=0.46..0.71 rows=25 width=32) (actual time=37.005..37.021 rows=7 loops=1)

  • Group Key: lower((retrieve_person_linked_recipients.target_name)::text)
3. 36.995 36.995 ↑ 3.6 7 1

Function Scan on retrieve_person_linked_recipients (cost=0.03..0.40 rows=25 width=32) (actual time=36.988..36.995 rows=7 loops=1)

  • Filter: (((recipient_cat)::text <> 'GROUP'::text) OR ((grp_association)::text <> 'supervisor'::text))
4. 11,859.127 11,859.127 ↑ 12.6 162 7

Index Scan using idx_comm_values0 on comm_values cv (cost=0.81..3,029.58 rows=2,043 width=157) (actual time=9.720..1,694.161 rows=162 loops=7)

  • Index Cond: (lower(""left""((value)::text, 200)) = lower((retrieve_person_linked_recipients.target_name)::text))
Planning time : 2.341 ms
Execution time : 11,900.416 ms