explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yJRv

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 6,715.262 ↓ 156.0 156 1

Gather Merge (cost=68,656.93..68,657.03 rows=1 width=240) (actual time=6,709.420..6,715.262 rows=156 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 1.074 13,372.852 ↓ 78.0 78 2

Sort (cost=67,656.93..67,656.93 rows=1 width=240) (actual time=6,686.419..6,686.426 rows=78 loops=2)

  • Sort Key: b.tranzact_on_zayo_network_status__c, b.default_location_for_pricing__c DESC NULLS LAST, b.floor_suite_room_cage__c
  • Sort Method: quicksort Memory: 48kB
3. 9.516 13,371.778 ↓ 78.0 78 2

Nested Loop Left Join (cost=7.49..67,656.92 rows=1 width=240) (actual time=131.250..6,685.889 rows=78 loops=2)

  • Join Filter: ((b.sfid)::text = (s.location__c)::text)
  • Rows Removed by Join Filter: 27896
4. 9,445.632 13,346.212 ↓ 75.0 75 2

Nested Loop Left Join (cost=7.49..67,630.00 rows=1 width=191) (actual time=131.057..6,673.106 rows=75 loops=2)

  • Join Filter: ((b.sfid)::text = (d.location__c)::text)
  • Rows Removed by Join Filter: 15745912
5. 0.838 530.230 ↓ 75.0 75 2

Nested Loop Left Join (cost=7.49..53,119.04 rows=1 width=171) (actual time=33.276..265.115 rows=75 loops=2)

6. 96.944 526.392 ↓ 75.0 75 2

Hash Join (cost=7.41..53,118.94 rows=1 width=169) (actual time=33.264..263.196 rows=75 loops=2)

  • Hash Cond: ((b.building__c)::text = (a.sfid)::text)
7. 429.250 429.250 ↑ 1.2 544,798 2

Parallel Seq Scan on location__c b (cost=0.00..52,775.55 rows=639,958 width=110) (actual time=0.022..214.625 rows=544,798 loops=2)

  • Filter: (NOT tranzact_freeze__c)
  • Rows Removed by Filter: 5006
8. 0.010 0.198 ↑ 1.0 2 2

Hash (cost=7.40..7.40 rows=2 width=78) (actual time=0.099..0.099 rows=2 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.188 0.188 ↑ 1.0 2 2

Index Scan using hcu_idx_building__c_sfid on building__c a (cost=0.08..7.40 rows=2 width=78) (actual time=0.068..0.094 rows=2 loops=2)

  • Index Cond: ((sfid)::text = ANY ('{a0W600000009nMLEAY,a0W600000009mrkEAA}'::text[]))
10. 3.000 3.000 ↑ 1.0 1 150

Index Scan using hcu_idx_account_sfid on account c (cost=0.08..0.10 rows=1 width=40) (actual time=0.020..0.020 rows=1 loops=150)

  • Index Cond: ((b.carrier_hotel_data_center_operator__c)::text = (sfid)::text)
11. 3,370.350 3,370.350 ↑ 1.0 209,946 150

Seq Scan on service_capability__c d (cost=0.00..13,775.98 rows=209,994 width=39) (actual time=0.002..22.469 rows=209,946 loops=150)

12. 16.050 16.050 ↑ 1.0 372 150

Seq Scan on service_provider_destination__c s (cost=0.00..25.61 rows=372 width=67) (actual time=0.004..0.107 rows=372 loops=150)

  • Filter: ((destination_type__c)::text = 'Cloud'::text)
  • Rows Removed by Filter: 374