explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k4Ts

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.011 ↓ 0.0 0 1

Sort (cost=99.84..99.84 rows=1 width=48) (actual time=0.011..0.011 rows=0 loops=1)

  • Sort Key: (sum(reason_payments.total_amount)) DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2
2. 0.001 0.008 ↓ 0.0 0 1

GroupAggregate (cost=99.80..99.83 rows=1 width=48) (actual time=0.008..0.008 rows=0 loops=1)

  • Group Key: rt.name
  • Buffers: shared hit=2
3. 0.001 0.007 ↓ 0.0 0 1

Sort (cost=99.80..99.81 rows=1 width=21) (actual time=0.007..0.007 rows=0 loops=1)

  • Sort Key: rt.name
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2
4. 0.001 0.006 ↓ 0.0 0 1

Nested Loop Left Join (cost=5.11..99.79 rows=1 width=21) (actual time=0.006..0.006 rows=0 loops=1)

  • Buffers: shared hit=2
5. 0.000 0.005 ↓ 0.0 0 1

Nested Loop (cost=4.69..80.03 rows=1 width=21) (actual time=0.005..0.005 rows=0 loops=1)

  • Buffers: shared hit=2
6. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on reason_payments (cost=4.41..55.08 rows=3 width=21) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (property_id = '74d1ec69-29fb-4853-b241-93f6eca62286'::uuid)
  • Filter: ((business_date >= '2019-09-01'::date) AND (business_date <= '2019-12-02'::date))
  • Buffers: shared hit=2
7. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on index_reason_payments_on_property_id (cost=0.00..4.41 rows=16 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (property_id = '74d1ec69-29fb-4853-b241-93f6eca62286'::uuid)
  • Buffers: shared hit=2
8. 0.000 0.000 ↓ 0.0 0

Index Scan using reasons_pkey on reasons (cost=0.29..8.31 rows=1 width=16) (never executed)

  • Index Cond: (id = reason_payments.reason_id)
  • Filter: (kind = 3)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using index_reason_translations_on_reason_id on reason_translations rt (cost=0.42..19.76 rows=1 width=32) (never executed)

  • Index Cond: (reasons.id = reason_id)
  • Filter: ((locale)::text = 'tr'::text)