explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DLK1

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

Sort (cost=63.61..63.61 rows=1 width=48) (actual time=0.026..0.026 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.022 ↓ 0.0 0 1

GroupAggregate (cost=63.58..63.60 rows=1 width=48) (actual time=0.022..0.022 rows=0 loops=1)

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

Sort (cost=63.58..63.58 rows=1 width=21) (actual time=0.021..0.021 rows=0 loops=1)

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

Nested Loop Left Join (cost=5.03..63.57 rows=1 width=21) (actual time=0.018..0.018 rows=0 loops=1)

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

Nested Loop (cost=4.61..40.22 rows=1 width=21) (actual time=0.018..0.018 rows=0 loops=1)

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

Bitmap Heap Scan on reason_payments (cost=4.32..15.27 rows=3 width=21) (actual time=0.018..0.018 rows=0 loops=1)

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

Bitmap Index Scan on ix_test (cost=0.00..4.32 rows=3 width=0) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((property_id = '74d1ec69-29fb-4853-b241-93f6eca62286'::uuid) AND (business_date >= '2019-09-01'::date) AND (business_date <= '2019-12-02'::date))
  • 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..23.33 rows=1 width=32) (never executed)

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