explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k1rB

Settings
# exclusive inclusive rows x rows loops node
1. 7.063 75.476 ↓ 33.1 7,877 1

Sort (cost=6,680.79..6,681.39 rows=238 width=135) (actual time=73.668..75.476 rows=7,877 loops=1)

  • Sort Key: bp.create_time DESC
  • Sort Method: quicksort Memory: 2054kB
2. 4.900 68.413 ↓ 33.1 7,877 1

Nested Loop (cost=156.39..6,671.40 rows=238 width=135) (actual time=0.881..68.413 rows=7,877 loops=1)

3. 9.367 39.882 ↓ 33.1 7,877 1

Nested Loop (cost=155.96..6,295.19 rows=238 width=75) (actual time=0.874..39.882 rows=7,877 loops=1)

4. 4.303 14.761 ↓ 33.1 7,877 1

Hash Join (cost=155.54..5,867.76 rows=238 width=75) (actual time=0.866..14.761 rows=7,877 loops=1)

  • Hash Cond: (bp.billing_payment_state_id = bps.id)
5. 5.459 10.447 ↓ 33.1 7,877 1

Hash Join (cost=154.41..5,865.55 rows=238 width=49) (actual time=0.849..10.447 rows=7,877 loops=1)

  • Hash Cond: (bp.init_obj_id = p.obj_id)
6. 4.387 4.936 ↓ 1.0 7,877 1

Bitmap Heap Scan on billing_payment bp (cost=149.06..5,839.62 rows=7,824 width=29) (actual time=0.791..4.936 rows=7,877 loops=1)

  • Recheck Cond: (billing_payment_type_id = 6)
  • Heap Blocks: exact=2043
7. 0.549 0.549 ↓ 1.0 7,878 1

Bitmap Index Scan on billing_payment_billing_payment_type_id_idx (cost=0.00..147.10 rows=7,824 width=0) (actual time=0.549..0.549 rows=7,878 loops=1)

  • Index Cond: (billing_payment_type_id = 6)
8. 0.020 0.052 ↑ 1.0 60 1

Hash (cost=4.60..4.60 rows=60 width=28) (actual time=0.052..0.052 rows=60 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
9. 0.032 0.032 ↑ 1.0 60 1

Seq Scan on person p (cost=0.00..4.60 rows=60 width=28) (actual time=0.004..0.032 rows=60 loops=1)

10. 0.005 0.011 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=34) (actual time=0.011..0.011 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.006 0.006 ↑ 1.0 6 1

Seq Scan on billing_payment_state bps (cost=0.00..1.06 rows=6 width=34) (actual time=0.004..0.006 rows=6 loops=1)

12. 15.754 15.754 ↑ 1.0 1 7,877

Index Scan using billing_loan_pkey on billing_loan bl (cost=0.42..1.80 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=7,877)

  • Index Cond: (obj_id = bp.billing_loan_id)
13. 23.631 23.631 ↑ 1.0 1 7,877

Index Scan using application_pkey on application app (cost=0.42..1.58 rows=1 width=66) (actual time=0.003..0.003 rows=1 loops=7,877)

  • Index Cond: (obj_id = bl.application_id)