explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oAUl

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.029 ↓ 0.0 0 1

Sort (cost=2,139.73..2,139.73 rows=1 width=64) (actual time=0.029..0.029 rows=0 loops=1)

  • Sort Key: (sum(reason_payments.total_amount)) DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2
2.          

CTE rt

3. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on reason_translations (cost=421.49..1,614.68 rows=18,735 width=32) (never executed)

  • Recheck Cond: ((locale)::text = 'tr'::text)
4. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on index_reason_translations_on_locale (cost=0.00..416.81 rows=18,735 width=0) (never executed)

  • Index Cond: ((locale)::text = 'tr'::text)
5. 0.000 0.023 ↓ 0.0 0 1

GroupAggregate (cost=525.02..525.04 rows=1 width=64) (actual time=0.023..0.023 rows=0 loops=1)

  • Group Key: rt.name
  • Buffers: shared hit=2
6. 0.005 0.023 ↓ 0.0 0 1

Sort (cost=525.02..525.02 rows=1 width=37) (actual time=0.023..0.023 rows=0 loops=1)

  • Sort Key: rt.name
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2
7. 0.009 0.018 ↓ 0.0 0 1

Hash Right Join (cost=80.04..525.01 rows=1 width=37) (actual time=0.018..0.018 rows=0 loops=1)

  • Hash Cond: (rt.reason_id = reasons.id)
  • Buffers: shared hit=2
8. 0.000 0.000 ↓ 0.0 0

CTE Scan on rt (cost=0.00..374.70 rows=18,735 width=48) (never executed)

9. 0.000 0.009 ↓ 0.0 0 1

Hash (cost=80.03..80.03 rows=1 width=21) (actual time=0.009..0.009 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=2
10. 0.001 0.009 ↓ 0.0 0 1

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

  • Buffers: shared hit=2
11. 0.001 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on reason_payments (cost=4.41..55.08 rows=3 width=21) (actual time=0.008..0.008 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
12. 0.007 0.007 ↓ 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.007..0.007 rows=0 loops=1)

  • Index Cond: (property_id = '74d1ec69-29fb-4853-b241-93f6eca62286'::uuid)
  • Buffers: shared hit=2
13. 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)