explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DG6H

Settings
# exclusive inclusive rows x rows loops node
1. 10.301 33,899.673 ↑ 42.1 1,213 1

Nested Loop (cost=2.15..123,632.70 rows=51,075 width=256) (actual time=183.203..33,899.673 rows=1,213 loops=1)

2. 12.564 27,592.689 ↑ 42.1 1,213 1

Nested Loop (cost=1.72..100,619.60 rows=51,075 width=196) (actual time=169.843..27,592.689 rows=1,213 loops=1)

3. 3.491 12,003.992 ↑ 42.1 1,213 1

Nested Loop (cost=1.28..76,251.12 rows=51,075 width=157) (actual time=88.939..12,003.992 rows=1,213 loops=1)

4. 0.049 48.671 ↑ 2.5 10 1

HashAggregate (cost=0.46..0.71 rows=25 width=32) (actual time=48.633..48.671 rows=10 loops=1)

  • Group Key: lower(""left""((retrieve_person_linked_recipients.target_name)::text, 200))
5. 48.622 48.622 ↑ 2.5 10 1

Function Scan on retrieve_person_linked_recipients (cost=0.03..0.40 rows=25 width=32) (actual time=48.611..48.622 rows=10 loops=1)

  • Filter: (((recipient_cat)::text <> 'GROUP'::text) OR ((grp_association)::text <> 'supervisor'::text))
6. 11,951.830 11,951.830 ↑ 16.9 121 10

Index Scan using idx_comm_values0 on comm_values cv (cost=0.82..3,029.59 rows=2,043 width=157) (actual time=11.047..1,195.183 rows=121 loops=10)

  • Index Cond: (lower(""left""((value)::text, 200)) = lower(""left""((retrieve_person_linked_recipients.target_name)::text, 200)))
7. 15,576.133 15,576.133 ↑ 1.0 1 1,213

Index Scan using comm_flds_pk on comm_flds cf (cost=0.44..0.48 rows=1 width=39) (actual time=12.841..12.841 rows=1 loops=1,213)

  • Index Cond: (comm_fld_id = cv.comm_fld_id)
8. 6,296.683 6,296.683 ↑ 1.0 1 1,213

Index Scan using comm_pk on comm c (cost=0.43..0.45 rows=1 width=60) (actual time=5.191..5.191 rows=1 loops=1,213)

  • Index Cond: (comm_id = cf.comm_id)
Planning time : 7.147 ms
Execution time : 33,902.076 ms