explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F8rN

Settings
# exclusive inclusive rows x rows loops node
1. 250.302 3,586.402 ↓ 1.2 395,951 1

Gather (cost=1,001.00..656,086.51 rows=327,314 width=36) (actual time=2.135..3,586.402 rows=395,951 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 44.560 3,336.100 ↑ 1.0 131,984 3 / 3

Nested Loop (cost=1.00..622,355.11 rows=136,381 width=36) (actual time=56.829..3,336.100 rows=131,984 loops=3)

3. 280.927 280.927 ↑ 1.1 31,691 3 / 3

Parallel Index Scan using nmsrecipient_id on nmsrecipient n1 (cost=0.43..14,476.15 rows=36,132 width=28) (actual time=13.922..280.927 rows=31,691 loops=3)

  • Index Cond: (irecipientid < 100000)
4. 3,010.613 3,010.613 ↑ 1.0 4 95,072 / 3

Index Scan using nmsbroadlogrcp_profile on nmsbroadlogrcp n2 (cost=0.56..16.78 rows=4 width=12) (actual time=0.041..0.095 rows=4 loops=95,072)

  • Index Cond: (iprofileid = n1.irecipientid)
Planning time : 79.774 ms