explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5wX

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

Aggregate (cost=206.5..206.51 rows=1 width=8) (never executed)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=23.53..206.5 rows=1 width=4) (never executed)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.26..184.21 rows=8 width=12) (never executed)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..179.6 rows=6 width=12) (never executed)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..170.15 rows=6 width=8) (never executed)

6. 0.000 0.000 ↓ 0.0

Seq Scan on report_feedbacks reports_report_feedbacks (cost=0..1.2 rows=20 width=4) (never executed)

  • Filter: (adv_fees_change_picklist_id IS NOT NULL)
7. 0.000 0.000 ↓ 0.0

Index Scan using reports_pkey on reports reports (cost=0.42..8.45 rows=1 width=20) (never executed)

  • Index Cond: (id = reports_report_feedbacks.report_id)
  • Filter: ((deleted_at IS NULL) AND (archived_at IS NULL) AND (latest_final_report_generation_id IS NOT NULL) AND (report_type_id = ANY ('{1,9,27}'::integer[])) AND (report_status_id = ANY ('{1,5,8,14,15,16,17}'::integer[])))
8. 0.000 0.000 ↓ 0.0

Index Scan using plans_pkey on plans reports_plans (cost=0.42..1.57 rows=1 width=8) (never executed)

  • Index Cond: (id = reports.plan_id)
  • Filter: (NOT is_prospect)
9. 0.000 0.000 ↓ 0.0

Index Scan using index_report_generations_on_report_id on report_generations reports_report_generations (cost=0.42..0.74 rows=3 width=8) (never executed)

  • Index Cond: (report_id = reports.id)
10. 0.000 0.000 ↓ 0.0

Hash (cost=19.77..19.77 rows=200 width=4) (never executed)

11. 0.000 0.000 ↓ 0.0

HashAggregate (cost=17.77..19.77 rows=200 width=4) (never executed)

  • Group Key: udf_authorized_plan_ids(2152, true)
12. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0..5.27 rows=1,000 width=4) (never executed)

13. 0.000 0.000 ↓ 0.0

Result (cost=0..0.01 rows=1 width=0) (never executed)