explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Iegc

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=87,496.70..211,675.32 rows=222 width=99) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=87,496.14..211,488.63 rows=229 width=99) (actual rows= loops=)

  • Hash Cond: ((oppty.masteraccount_453)::text = (acc2.id)::text)
3. 0.000 0.000 ↓ 0.0

Seq Scan on data_common_opportunity_24 oppty (cost=0.00..120,039.94 rows=1,505,731 width=99) (actual rows= loops=)

  • Filter: (NOT isdeleted__s)
4. 0.000 0.000 ↓ 0.0

Hash (cost=87,415.88..87,415.88 rows=6,421 width=47) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..87,415.88 rows=6,421 width=47) (actual rows= loops=)

  • Workers Planned: 2
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on data_common_account_8 acc2 (cost=0.00..85,773.78 rows=2,675 width=47) (actual rows= loops=)

  • Filter: (lower((id)::text) = 'rpvy-hbsx-ff500ccf-424b-43a9-ba56-9e6dd3733286'::text)
7. 0.000 0.000 ↓ 0.0

Index Only Scan using ""PK_common_Account_8"" on data_common_account_8 acc1 (cost=0.55..0.81 rows=1 width=47) (actual rows= loops=)

  • Index Cond: (id = (oppty.masteraccount_453)::text)