explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1tiwE

Settings
# exclusive inclusive rows x rows loops node
1. 15.503 53.344 ↑ 1.3 2,737 1

Sort (cost=3,882.65..3,891.38 rows=3,490 width=408) (actual time=53.267..53.344 rows=2,737 loops=1)

  • Sort Key: usr.strlastname, usr.strfirstname
  • Sort Method: quicksort Memory: 738kB
  • Buffers: shared hit=1819
2. 1.392 37.841 ↑ 1.3 2,737 1

Hash Join (cost=2,047.64..3,677.29 rows=3,490 width=408) (actual time=17.019..37.841 rows=2,737 loops=1)

  • Buffers: shared hit=1819
3. 5.084 24.067 ↑ 1.3 2,737 1

Hash Join (cost=512.43..2,094.09 rows=3,490 width=257) (actual time=4.608..24.067 rows=2,737 loops=1)

  • Buffers: shared hit=1193
4. 14.465 14.465 ↑ 1.0 41,884 1

Index Only Scan using idx_dsobject_lid__bdisabled_and_bdeleted_null_or_false on dsobject obj (cost=0.41..1,471.97 rows=41,941 width=44) (actual time=0.02..14.465 rows=41,884 loops=1)

  • Heap Fetches: 68
  • Buffers: shared hit=772
5. 1.435 4.518 ↑ 1.0 3,639 1

Hash (cost=466.51..466.51 rows=3,640 width=217) (actual time=4.518..4.518 rows=3,639 loops=1)

  • Buffers: shared hit=421
6. 3.083 3.083 ↑ 1.0 3,639 1

Seq Scan on dsuser usr (cost=0..466.51 rows=3,640 width=217) (actual time=0.02..3.083 rows=3,639 loops=1)

  • Filter: (usr.lid > 2)
  • Buffers: shared hit=421
7. 0.611 12.382 ↑ 1.0 3,641 1

Hash (cost=1,489.7..1,489.7 rows=3,641 width=151) (actual time=12.382..12.382 rows=3,641 loops=1)

  • Buffers: shared hit=626
8. 4.548 11.771 ↑ 1.0 3,641 1

Hash Join (cost=503.21..1,489.7 rows=3,641 width=151) (actual time=2.541..11.771 rows=3,641 loops=1)

  • Buffers: shared hit=626
9. 4.740 4.740 ↑ 1.0 43,743 1

Index Only Scan using idx_dsobject_lclassid_lid on dsobject obj_1 (cost=0.29..871.94 rows=43,743 width=4) (actual time=0.033..4.74 rows=43,743 loops=1)

  • Heap Fetches: 96
  • Buffers: shared hit=205
10. 0.623 2.483 ↑ 1.0 3,641 1

Hash (cost=457.41..457.41 rows=3,641 width=151) (actual time=2.483..2.483 rows=3,641 loops=1)

  • Buffers: shared hit=421
11. 1.860 1.860 ↑ 1.0 3,641 1

Seq Scan on dsuser usr_1 (cost=0..457.41 rows=3,641 width=151) (actual time=0.014..1.86 rows=3,641 loops=1)

  • Buffers: shared hit=421