explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 71Wwb

Settings
# exclusive inclusive rows x rows loops node
1. 0.076 0.395 ↑ 25.1 17 1

Sort (cost=112.23..113.30 rows=426 width=5,922) (actual time=0.393..0.395 rows=17 loops=1)

  • Sort Key: (idx('{24,27,28,35,37,38,39,40,41,42,43}'::integer[], "Job".id))
  • Sort Method: quicksort Memory: 82kB
2. 0.032 0.319 ↑ 25.1 17 1

Hash Right Join (cost=50.57..93.63 rows=426 width=5,922) (actual time=0.279..0.319 rows=17 loops=1)

  • Hash Cond: ("contractTypes->JobContractType"."jobId" = "Job".id)
3. 0.021 0.033 ↑ 29.8 26 1

Hash Join (cost=11.18..49.83 rows=775 width=1,068) (actual time=0.017..0.033 rows=26 loops=1)

  • Hash Cond: ("contractTypes->JobContractType"."contractTypeId" = "contractTypes".id)
4. 0.006 0.006 ↑ 86.9 26 1

Seq Scan on "JobContractType" "contractTypes->JobContractType" (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.003..0.006 rows=26 loops=1)

5. 0.003 0.006 ↑ 8.0 3 1

Hash (cost=10.88..10.88 rows=24 width=1,060) (actual time=0.006..0.006 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.003 0.003 ↑ 8.0 3 1

Seq Scan on "ContractType" "contractTypes" (cost=0.00..10.88 rows=24 width=1,060) (actual time=0.003..0.003 rows=3 loops=1)

  • Filter: (("deletionDate" > '2019-03-13 15:30:40.515+01'::timestamp with time zone) OR ("deletionDate" IS NULL))
7. 0.032 0.254 ↑ 1.0 11 1

Hash (cost=39.26..39.26 rows=11 width=4,850) (actual time=0.254..0.254 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 31kB
8. 0.021 0.222 ↑ 1.0 11 1

Hash Right Join (cost=27.51..39.26 rows=11 width=4,850) (actual time=0.177..0.222 rows=11 loops=1)

  • Hash Cond: (company.id = "Job"."companyId")
9. 0.024 0.073 ↓ 1.9 33 1

Hash Right Join (cost=10.84..22.44 rows=17 width=2,213) (actual time=0.026..0.073 rows=33 loops=1)

  • Hash Cond: ("company->companiesI18n"."companyId" = company.id)
10. 0.030 0.030 ↑ 1.2 33 1

Seq Scan on "CompanyI18n" "company->companiesI18n" (cost=0.00..11.50 rows=40 width=617) (actual time=0.003..0.030 rows=33 loops=1)

  • Filter: (("deletionDate" > '2019-03-13 15:30:40.515+01'::timestamp with time zone) OR ("deletionDate" IS NULL))
11. 0.006 0.019 ↓ 1.9 33 1

Hash (cost=10.62..10.62 rows=17 width=1,596) (actual time=0.019..0.019 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
12. 0.013 0.013 ↓ 1.9 33 1

Seq Scan on "Company" company (cost=0.00..10.62 rows=17 width=1,596) (actual time=0.004..0.013 rows=33 loops=1)

  • Filter: (("deletionDate" > '2019-03-13 15:30:40.515+01'::timestamp with time zone) OR ("deletionDate" IS NULL))
13. 0.013 0.128 ↑ 1.0 11 1

Hash (cost=16.53..16.53 rows=11 width=2,637) (actual time=0.128..0.128 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
14. 0.016 0.115 ↑ 1.0 11 1

Hash Right Join (cost=8.10..16.53 rows=11 width=2,637) (actual time=0.089..0.115 rows=11 loops=1)

  • Hash Cond: ("jobsI18n"."jobId" = "Job".id)
15. 0.016 0.016 ↑ 1.0 20 1

Seq Scan on "JobI18n" "jobsI18n" (cost=0.00..8.25 rows=20 width=885) (actual time=0.003..0.016 rows=20 loops=1)

  • Filter: (("deletionDate" > '2019-03-13 15:30:40.515+01'::timestamp with time zone) OR ("deletionDate" IS NULL))
16. 0.010 0.083 ↑ 1.0 11 1

Hash (cost=7.96..7.96 rows=11 width=1,752) (actual time=0.083..0.083 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
17. 0.022 0.073 ↑ 1.0 11 1

Hash Right Join (cost=1.66..7.96 rows=11 width=1,752) (actual time=0.054..0.073 rows=11 loops=1)

  • Hash Cond: (address.id = "Job"."addressId")
18. 0.026 0.026 ↑ 1.0 73 1

Seq Scan on "Address" address (cost=0.00..5.91 rows=73 width=99) (actual time=0.005..0.026 rows=73 loops=1)

  • Filter: (("deletionDate" > '2019-03-13 15:30:40.514+01'::timestamp with time zone) OR ("deletionDate" IS NULL))
19. 0.006 0.025 ↑ 1.0 11 1

Hash (cost=1.52..1.52 rows=11 width=1,653) (actual time=0.025..0.025 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
20. 0.019 0.019 ↑ 1.0 11 1

Seq Scan on "Job" (cost=0.00..1.52 rows=11 width=1,653) (actual time=0.010..0.019 rows=11 loops=1)

  • Filter: ((("deletionDate" > '2019-03-13 15:30:40.515+01'::timestamp with time zone) OR ("deletionDate" IS NULL)) AND (id = ANY ('{24,27,28,35,37,38,39,40,41,42,43}'::integer[])))
  • Rows Removed by Filter: 9