explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6N2J

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

Update on eligible_customer ecupdate (cost=0.71..194.78 rows=152 width=109) (actual time=0.013..0.013 rows=0 loops=1)

  • Update on eligible_customer_partition_99799 ecupdate_1
2. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.71..194.78 rows=152 width=109) (actual time=0.013..0.013 rows=0 loops=1)

3. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=0.56..167.18 rows=152 width=111) (actual time=0.012..0.012 rows=0 loops=1)

4. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=0.28..97.77 rows=152 width=28) (actual time=0.012..0.012 rows=0 loops=1)

5. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on teamdata td (cost=0.00..31.25 rows=8 width=18) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (team_internal_id = 99,799)
6. 0.000 0.000 ↓ 0.0 0

Append (cost=0.28..8.30 rows=1 width=26) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Index Scan using eligible_customer_partition_99799_customer_internal_id_idx on eligible_customer_partition_99799 ec (cost=0.28..8.30 rows=1 width=26) (never executed)

  • Index Cond: (customer_internal_id = td.customer_internal_id)
  • Filter: (team_internal_id = 99,799)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using eligible_customer_partition_99799_pkey on eligible_customer_partition_99799 ecupdate_1 (cost=0.28..0.46 rows=1 width=83) (never executed)

  • Index Cond: ((eligibility_id = ec.eligibility_id) AND (team_internal_id = 99,799))
9. 0.000 0.000 ↓ 0.0 0

Index Scan using entity_details_pkey on entity_details ed (cost=0.15..0.18 rows=1 width=14) (never executed)

  • Index Cond: (new_eligibility_id = ec.eligibility_id)