explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1q7R

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

Nested Loop Left Join (cost=1.36..246.80 rows=900 width=10,552) (actual time=0.004..0.004 rows=0 loops=1)

2. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.21..63.12 rows=1 width=11,173) (actual time=0.004..0.004 rows=0 loops=1)

3. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.06..60.70 rows=1 width=10,657) (actual time=0.004..0.004 rows=0 loops=1)

4. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.79..50.09 rows=1 width=8,577) (actual time=0.004..0.004 rows=0 loops=1)

5. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.65..41.54 rows=1 width=8,065) (actual time=0.004..0.004 rows=0 loops=1)

  • Join Filter: (rs.org_id = organisations.id)
6. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.51..33.37 rows=1 width=7,453) (actual time=0.004..0.004 rows=0 loops=1)

7. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.38..24.45 rows=1 width=6,321) (actual time=0.003..0.004 rows=0 loops=1)

  • Join Filter: (rs.patient_id = patients.id)
8. 0.000 0.003 ↓ 0.0 0 1

Nested Loop (cost=0.25..16.30 rows=1 width=5,261) (actual time=0.003..0.003 rows=0 loops=1)

  • Join Filter: (appointments.id = rs.appt_id)
9. 0.003 0.003 ↓ 0.0 0 1

Index Scan using appt_id_and_id_ride_details_idx on ride_details rs (cost=0.12..8.14 rows=1 width=4,669) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((NOT is_pr_ride) AND (org_id = 1,153) AND ((ride_category)::text = 'completed'::text))
10. 0.000 0.000 ↓ 0.0 0

Index Scan using appt_id_idx on appointments (cost=0.12..8.14 rows=1 width=600) (never executed)

  • Filter: (invoice_generated AND (invoice_generation_time >= 1,546,300,800) AND (invoice_generation_time <= 1,567,727,999))
11. 0.000 0.000 ↓ 0.0 0

Index Scan using patients_pkey on patients (cost=0.12..8.14 rows=1 width=1,068) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using unique_receipts_id on receipts (cost=0.14..8.15 rows=1 width=1,136) (never executed)

  • Index Cond: (ride_detail_id = rs.id)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using organisations_pkey on organisations (cost=0.14..8.15 rows=1 width=620) (never executed)

  • Index Cond: (id = 1,153)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using market_segments_pkey on market_segments (cost=0.14..8.16 rows=1 width=520) (never executed)

  • Index Cond: (id = organisations.market_segment_id)
15. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.28..10.60 rows=1 width=2,088) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Index Scan using dynamite_claims_pkey on dynamite_claims (cost=0.14..8.15 rows=1 width=544) (never executed)

  • Index Cond: (appointments.dynamite_claims_id = id)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using dynamite_claims_adjuster_pkey on dynamite_claims_adjuster (cost=0.14..2.36 rows=1 width=1,552) (never executed)

  • Index Cond: (dynamite_claims.claims_adjuster_id = id)
18. 0.000 0.000 ↓ 0.0 0

Index Scan using org_payers_pkey on org_payers (cost=0.14..2.36 rows=1 width=524) (never executed)

  • Index Cond: (dynamite_claims.payer_id = id)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_invoice_aptid on invoices (cost=0.15..8.17 rows=1 width=20) (never executed)

  • Index Cond: (appt_id = appointments.id)
Planning time : 1.714 ms
Execution time : 0.260 ms