explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nUUU

Settings
# exclusive inclusive rows x rows loops node
1. 172.814 10,969.634 ↑ 24.2 6 1

Hash Semi Join (cost=2.71..1,223,797.09 rows=145 width=125) (actual time=7,575.426..10,969.634 rows=6 loops=1)

  • Hash Cond: ((cv.value)::text = (retrieve_person_linked_recipients.target_name)::text)
2. 602.270 10,779.500 ↓ 12.3 1,047,507 1

Nested Loop (cost=2.00..1,223,571.49 rows=85,054 width=125) (actual time=13.198..10,779.500 rows=1,047,507 loops=1)

3. 0.000 6,309.130 ↓ 9.9 773,620 1

Nested Loop (cost=1.43..817,616.29 rows=77,847 width=16) (actual time=13.176..6,309.130 rows=773,620 loops=1)

4. 282.011 1,699.686 ↓ 1.0 773,620 1

Merge Join (cost=0.86..140,213.50 rows=738,009 width=16) (actual time=13.129..1,699.686 rows=773,620 loops=1)

  • Merge Cond: (c.comm_ev_id = e.ev_id)
5. 462.430 462.430 ↑ 11.1 775,057 1

Index Scan using idx_comm_arc_comm_ev_id on comm_arc c (cost=0.43..337,052.19 rows=8,573,706 width=16) (actual time=12.989..462.430 rows=775,057 loops=1)

6. 955.245 955.245 ↓ 1.0 773,620 1

Index Scan using evs_arc_pk on evs_arc e (cost=0.42..97,196.12 rows=738,009 width=8) (actual time=0.130..955.245 rows=773,620 loops=1)

  • Filter: ((dmn_name IS NOT NULL) AND (company_id = 1) AND ((status)::text = ANY ('{TERMINATED_PASSFILL,TERMINATED_EXT_PASSFILL,TERMINATED_WITH_ERR,TERMINATED_EXT_FAILFILL,SUSPENDED,PURGED,ACTIVE,CREATE,TERMINATED_BY_USER,TERMINATED_FAILFILL,TERMINATED_EXTERNAL,TERMINATED,SUPPRESSED}'::text[])))
  • Rows Removed by Filter: 1436
7. 4,641.720 4,641.720 ↑ 3.0 1 773,620

Index Scan using idx_comm_fld_arc_name on comm_flds_arc cf (cost=0.57..0.89 rows=3 width=16) (actual time=0.005..0.006 rows=1 loops=773,620)

  • Index Cond: ((comm_id = c.comm_id) AND ((name)::text = 'recipients'::text))
8. 3,868.100 3,868.100 ↑ 15.0 1 773,620

Index Scan using comm_values_arc_pk on comm_values_arc cv (cost=0.57..5.06 rows=15 width=125) (actual time=0.005..0.005 rows=1 loops=773,620)

  • Index Cond: (comm_fld_id = cf.comm_fld_id)
9. 0.009 17.320 ↑ 5.0 5 1

Hash (cost=0.40..0.40 rows=25 width=32) (actual time=17.320..17.320 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 17.311 17.311 ↑ 5.0 5 1

Function Scan on retrieve_person_linked_recipients (cost=0.03..0.40 rows=25 width=32) (actual time=17.309..17.311 rows=5 loops=1)

  • Filter: (((recipient_cat)::text <> 'GROUP'::text) OR ((grp_association)::text <> 'supervisor'::text))
Planning time : 1,045.428 ms
Execution time : 10,970.419 ms