explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8lsY

Settings
# exclusive inclusive rows x rows loops node
1. 102.480 256.935 ↑ 1.0 8,886 1

GroupAggregate (cost=32,132.37..32,552.55 rows=9,171 width=36) (actual time=150.289..256.935 rows=8,886 loops=1)

  • Group Key: rog.rent_order_id
  • Buffers: shared hit=107,403
2. 14.708 154.455 ↑ 1.0 30,394 1

Sort (cost=32,132.37..32,208.75 rows=30,554 width=16) (actual time=150.189..154.455 rows=30,394 loops=1)

  • Sort Key: rog.rent_order_id
  • Sort Method: quicksort Memory: 3,079kB
  • Buffers: shared hit=107,395
3. 14.205 139.747 ↑ 1.0 30,394 1

Gather (cost=2,347.4..29,856.24 rows=30,554 width=16) (actual time=19.827..139.747 rows=30,394 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=107,392
4. 5.102 125.542 ↑ 1.3 10,131 3 / 3

Nested Loop (cost=1,347.4..25,800.84 rows=12,731 width=16) (actual time=19.709..125.542 rows=10,131 loops=3)

  • Buffers: shared hit=107,392
5. 4.171 100.177 ↑ 1.3 10,131 3 / 3

Hash Join (cost=1,347.12..21,428.68 rows=12,731 width=8) (actual time=19.658..100.177 rows=10,131 loops=3)

  • Buffers: shared hit=16,200
6. 23.881 88.867 ↑ 1.3 10,131 3 / 3

Hash Join (cost=884.47..20,932.6 rows=12,731 width=8) (actual time=12.118..88.867 rows=10,131 loops=3)

  • Buffers: shared hit=15,719
7. 53.060 53.060 ↑ 1.3 126,939 3 / 3

Seq Scan on rent_account_good rag (cost=0..16,795.3 rows=166,730 width=8) (actual time=0.014..53.06 rows=126,939 loops=3)

  • Buffers: shared hit=15,128
8. 5.553 11.926 ↑ 1.0 30,394 3 / 3

Hash (cost=502.54..502.54 rows=30,554 width=8) (actual time=11.926..11.926 rows=30,394 loops=3)

  • Buffers: shared hit=591
9. 6.373 6.373 ↓ 1.0 30,555 3 / 3

Seq Scan on rent_order_good_rag rograg (cost=0..502.54 rows=30,554 width=8) (actual time=0.017..6.373 rows=30,555 loops=3)

  • Buffers: shared hit=591
10. 3.210 7.139 ↓ 1.0 14,741 3 / 3

Hash (cost=278.4..278.4 rows=14,740 width=8) (actual time=7.139..7.139 rows=14,741 loops=3)

  • Buffers: shared hit=393
11. 3.929 3.929 ↓ 1.0 14,741 3 / 3

Seq Scan on rent_order_good rog (cost=0..278.4 rows=14,740 width=8) (actual time=0.032..3.929 rows=14,741 loops=3)

  • Buffers: shared hit=393
12. 20.263 20.263 ↑ 1.0 1 30,394 / 3

Index Scan using rent_account_pkey on rent_account ra_1 (cost=0.29..0.34 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=30,394)

  • Index Cond: (id = rag.account_id)
  • Buffers: shared hit=91,192
Planning time : 2.778 ms
Execution time : 258.092 ms