explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Olb0

Settings
# exclusive inclusive rows x rows loops node
1. 1.926 785.079 ↓ 1.0 1,417 1

Sort (cost=21,873.50..21,876.91 rows=1,364 width=8) (actual time=784.499..785.079 rows=1,417 loops=1)

  • Sort Key: z.group_car_cd
  • Sort Method: quicksort Memory: 171kB
2. 435.504 783.153 ↓ 1.0 1,417 1

HashAggregate (cost=21,788.84..21,802.48 rows=1,364 width=8) (actual time=782.041..783.153 rows=1,417 loops=1)

3. 46.694 347.649 ↑ 1.0 35,759 1

Hash Semi Join (cost=4,251.59..11,952.96 rows=37,470 width=8) (actual time=138.050..347.649 rows=35,759 loops=1)

  • Hash Cond: ((z.owner_cd)::text = (c.owner_cd)::text)
4. 46.119 169.236 ↑ 1.0 37,427 1

Hash Join (cost=137.27..6,995.57 rows=37,470 width=16) (actual time=6.252..169.236 rows=37,427 loops=1)

  • Hash Cond: ((z.group_car_cd = ism.group_car_cd) AND (z.n_brand_cd = ism.brand_cd))
5. 31.861 116.888 ↑ 1.0 37,469 1

Append (cost=0.00..6,463.74 rows=37,475 width=20) (actual time=0.012..116.888 rows=37,469 loops=1)

6. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on zaiko z (cost=0.00..0.00 rows=1 width=37) (actual time=0.002..0.002 rows=0 loops=1)

7. 2.667 2.667 ↑ 1.0 1,072 1

Seq Scan on zaiko_10 z (cost=0.00..206.72 rows=1,072 width=20) (actual time=0.009..2.667 rows=1,072 loops=1)

8. 5.582 5.582 ↑ 1.0 2,475 1

Seq Scan on zaiko_11 z (cost=0.00..441.75 rows=2,475 width=20) (actual time=0.009..5.582 rows=2,475 loops=1)

9. 4.879 4.879 ↑ 1.0 2,081 1

Seq Scan on zaiko_12 z (cost=0.00..394.81 rows=2,081 width=20) (actual time=0.008..4.879 rows=2,081 loops=1)

10. 27.116 27.116 ↑ 1.0 12,343 1

Seq Scan on zaiko_13 z (cost=0.00..1,991.49 rows=12,349 width=20) (actual time=0.007..27.116 rows=12,343 loops=1)

11. 2.688 2.688 ↑ 1.0 1,154 1

Seq Scan on zaiko_14 z (cost=0.00..223.54 rows=1,154 width=20) (actual time=0.007..2.688 rows=1,154 loops=1)

12. 26.606 26.606 ↓ 1.0 11,507 1

Seq Scan on zaiko_15 z (cost=0.00..1,955.06 rows=11,506 width=20) (actual time=0.008..26.606 rows=11,507 loops=1)

13. 3.324 3.324 ↑ 1.0 1,382 1

Seq Scan on zaiko_16 z (cost=0.00..268.82 rows=1,382 width=20) (actual time=0.010..3.324 rows=1,382 loops=1)

14. 2.867 2.867 ↑ 1.0 1,236 1

Seq Scan on zaiko_17 z (cost=0.00..250.36 rows=1,236 width=20) (actual time=0.009..2.867 rows=1,236 loops=1)

15. 1.432 1.432 ↑ 1.0 630 1

Seq Scan on zaiko_18 z (cost=0.00..116.30 rows=630 width=20) (actual time=0.008..1.432 rows=630 loops=1)

16. 7.864 7.864 ↑ 1.0 3,589 1

Seq Scan on zaiko_19 z (cost=0.00..614.89 rows=3,589 width=20) (actual time=0.009..7.864 rows=3,589 loops=1)

17. 1.527 6.229 ↑ 1.0 2,524 1

Hash (cost=99.41..99.41 rows=2,524 width=8) (actual time=6.229..6.229 rows=2,524 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 99kB
18. 3.299 4.702 ↑ 1.0 2,524 1

HashAggregate (cost=74.17..99.41 rows=2,524 width=8) (actual time=3.366..4.702 rows=2,524 loops=1)

19. 1.403 1.403 ↑ 1.0 2,745 1

Seq Scan on integration_seo_master ism (cost=0.00..60.45 rows=2,745 width=8) (actual time=0.005..1.403 rows=2,745 loops=1)

20. 37.668 131.719 ↑ 1.0 62,280 1

Hash (cost=3,335.80..3,335.80 rows=62,281 width=8) (actual time=131.719..131.719 rows=62,280 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 2433kB
21. 53.787 94.051 ↑ 1.0 62,280 1

Append (cost=0.00..3,335.80 rows=62,281 width=8) (actual time=0.008..94.051 rows=62,280 loops=1)

22. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on client c (cost=0.00..0.00 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=1)

23. 3.538 3.538 ↑ 1.0 5,362 1

Seq Scan on client_10 c (cost=0.00..235.62 rows=5,362 width=8) (actual time=0.006..3.538 rows=5,362 loops=1)

24. 3.187 3.187 ↑ 1.0 4,182 1

Seq Scan on client_11 c (cost=0.00..224.82 rows=4,182 width=8) (actual time=0.009..3.187 rows=4,182 loops=1)

25. 2.053 2.053 ↑ 1.0 3,236 1

Seq Scan on client_12 c (cost=0.00..178.36 rows=3,236 width=8) (actual time=0.003..2.053 rows=3,236 loops=1)

26. 9.806 9.806 ↑ 1.0 14,773 1

Seq Scan on client_13 c (cost=0.00..802.73 rows=14,773 width=8) (actual time=0.004..9.806 rows=14,773 loops=1)

27. 2.657 2.657 ↑ 1.0 4,302 1

Seq Scan on client_14 c (cost=0.00..224.02 rows=4,302 width=8) (actual time=0.004..2.657 rows=4,302 loops=1)

28. 6.548 6.548 ↑ 1.0 10,635 1

Seq Scan on client_15 c (cost=0.00..580.35 rows=10,635 width=8) (actual time=0.004..6.548 rows=10,635 loops=1)

29. 5.503 5.503 ↑ 1.0 8,820 1

Seq Scan on client_16 c (cost=0.00..480.20 rows=8,820 width=8) (actual time=0.005..5.503 rows=8,820 loops=1)

30. 1.895 1.895 ↑ 1.0 2,994 1

Seq Scan on client_17 c (cost=0.00..172.94 rows=2,994 width=8) (actual time=0.005..1.895 rows=2,994 loops=1)

31. 0.848 0.848 ↑ 1.0 1,427 1

Seq Scan on client_18 c (cost=0.00..74.27 rows=1,427 width=8) (actual time=0.004..0.848 rows=1,427 loops=1)

32. 4.228 4.228 ↑ 1.0 6,549 1

Seq Scan on client_19 c (cost=0.00..362.49 rows=6,549 width=8) (actual time=0.004..4.228 rows=6,549 loops=1)