explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WgRS

Settings
# exclusive inclusive rows x rows loops node
1. 0.124 230.724 ↑ 2.1 28 1

GroupAggregate (cost=11,155.07..11,156.25 rows=59 width=20) (actual time=230.566..230.724 rows=28 loops=1)

  • Group Key: tblapplicationrolerequirements.applicationid
2. 0.252 230.600 ↓ 9.5 560 1

Sort (cost=11,155.07..11,155.22 rows=59 width=12) (actual time=230.549..230.600 rows=560 loops=1)

  • Sort Key: tblapplicationrolerequirements.applicationid
  • Sort Method: quicksort Memory: 51kB
3. 0.859 230.348 ↓ 9.5 560 1

Hash Join (cost=23.89..11,153.34 rows=59 width=12) (actual time=0.189..230.348 rows=560 loops=1)

  • Hash Cond: (tblapplicationrolerequirements.applicationid = tblapplication.applicationid)
4. 6.829 229.419 ↑ 56.3 3,386 1

Result (cost=0.70..8,721.28 rows=190,800 width=12) (actual time=0.071..229.419 rows=3,386 loops=1)

5. 16.694 222.590 ↑ 56.3 3,386 1

ProjectSet (cost=0.70..1,089.28 rows=190,800 width=68) (actual time=0.063..222.590 rows=3,386 loops=1)

6. 31.924 205.896 ↑ 1.0 1,908 1

Merge Join (cost=0.70..97.12 rows=1,908 width=450) (actual time=0.021..205.896 rows=1,908 loops=1)

  • Merge Cond: (tblrolerequirements.rolerequirementid = tblapplicationrolerequirements.rolerequirementid)
7. 172.172 172.172 ↑ 1.0 229,383 1

Index Scan using tblrolerequirements_pkey on tblrolerequirements (cost=0.42..23,639.74 rows=229,552 width=450) (actual time=0.010..172.172 rows=229,383 loops=1)

8. 1.800 1.800 ↑ 1.0 1,908 1

Index Scan using fk_tblapplicationrolerequirements_rolerequirementid_autoidx on tblapplicationrolerequirements (cost=0.28..51.12 rows=1,908 width=8) (actual time=0.005..1.800 rows=1,908 loops=1)

9. 0.008 0.070 ↑ 1.0 28 1

Hash (cost=22.84..22.84 rows=28 width=4) (actual time=0.070..0.070 rows=28 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.062 0.062 ↑ 1.0 28 1

Index Scan using fk_tblapplication_vacancyid_autoidx on tblapplication (cost=0.29..22.84 rows=28 width=4) (actual time=0.013..0.062 rows=28 loops=1)

  • Index Cond: (vacancyid = 760874)