explain.depesz.com

PostgreSQL's explain analyze made readable

Result: puWC

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,900.926 ↓ 0.0 0 1

Hash Left Join (cost=23,863.56..2,577,533.29 rows=143,216 width=514) (actual time=1,900.926..1,900.926 rows=0 loops=1)

  • Hash Cond: (ia.edh_provider_ueid = p.ueid)
2. 0.001 1,900.924 ↓ 0.0 0 1

Hash Join (cost=23,861.86..2,575,569.53 rows=143,216 width=477) (actual time=1,900.924..1,900.924 rows=0 loops=1)

  • Hash Cond: (ia.edh_legal_entity_partner_relation_ueid = lepr.ueid)
3. 306.040 1,900.923 ↓ 0.0 0 1

Nested Loop (cost=0.42..2,532,470.87 rows=143,216 width=256) (actual time=1,900.923..1,900.923 rows=0 loops=1)

4. 130.943 130.943 ↓ 1.1 292,788 1

Seq Scan on edh_affiliation ia (cost=0.00..8,770.94 rows=267,994 width=232) (actual time=0.004..130.943 rows=292,788 loops=1)

5. 1,463.940 1,463.940 ↓ 0.0 0 292,788

Index Scan using edh_identifier_summary_affiliation_cross_affiliation_ueid on edh_identifier_summary_affiliation_cross esaf2 (cost=0.42..9.41 rows=1 width=40) (actual time=0.005..0.005 rows=0 loops=292,788)

  • Index Cond: (edh_affiliation_ueid = ia.ueid)
  • Filter: (SubPlan 1)
  • Rows Removed by Filter: 1
6.          

SubPlan (for Index Scan)

7. 0.000 0.000 ↓ 0.0 0 317,004

Result (cost=0.85..8.89 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=317,004)

  • One-Time Filter: ((esaf2.edh_identifier_summary_ueid = esaf2.edh_identifier_summary_ueid) AND (esaf2.edh_affiliation_ueid = 'a89a9ab1-6051-4421-9904-cccf3d20fee7'::uuid))
8. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..8.89 rows=1 width=0) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Only Scan using edh_identifier_summary_affiliation_cross_pkey on edh_identifier_summary_affiliation_cross esaf (cost=0.42..4.44 rows=1 width=16) (never executed)

  • Index Cond: (edh_affiliation_ueid = 'a89a9ab1-6051-4421-9904-cccf3d20fee7'::uuid)
  • Heap Fetches: 0
10. 0.000 0.000 ↓ 0.0 0

Index Only Scan using edh_identifier_summary_pkey on edh_identifier_summary eis (cost=0.42..4.44 rows=1 width=16) (never executed)

  • Index Cond: (ueid = esaf.edh_identifier_summary_ueid)
  • Heap Fetches: 0
11. 0.000 0.000 ↓ 0.0 0

Hash (cost=13,485.75..13,485.75 rows=231,975 width=237) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Seq Scan on edh_legal_entity_partner_relation lepr (cost=0.00..13,485.75 rows=231,975 width=237) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.31..1.31 rows=31 width=53) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on edh_provider p (cost=0.00..1.31 rows=31 width=53) (never executed)

Planning time : 0.940 ms
Execution time : 1,901.024 ms