explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CrW1

Settings
# exclusive inclusive rows x rows loops node
1. 1.009 3,769.107 ↑ 7.4 30 1

Merge Left Join (cost=76,535.82..76,569.85 rows=221 width=124) (actual time=3,768.733..3,769.107 rows=30 loops=1)

  • Merge Cond: ((('now'::cstring)::date + i.i) = rapgece.tarih)
2. 0.947 2,153.380 ↑ 1.1 30 1

Merge Left Join (cost=45,019.20..45,032.77 rows=34 width=84) (actual time=2,153.135..2,153.380 rows=30 loops=1)

  • Merge Cond: ((('now'::cstring)::date + i.i) = rapgelis.tarih)
3. 0.906 1,057.453 ↓ 2.3 30 1

Merge Left Join (cost=22,525.41..22,532.10 rows=13 width=44) (actual time=1,057.330..1,057.453 rows=30 loops=1)

  • Merge Cond: (((('now'::cstring)::date + i.i)) = rapgidis.tarih)
4. 0.060 0.808 ↓ 6.0 30 1

Sort (cost=30.08..30.09 rows=5 width=4) (actual time=0.784..0.808 rows=30 loops=1)

  • Sort Key: ((('now'::cstring)::date + i.i))
  • Sort Method: quicksort Memory: 26kB
5. 0.748 0.748 ↓ 6.0 30 1

Function Scan on generate_series i (cost=0.02..30.02 rows=5 width=4) (actual time=0.139..0.748 rows=30 loops=1)

  • Filter: (((('now'::cstring)::date + i) >= '2019-04-01'::date) AND ((('now'::cstring)::date + i) <= '2019-04-30'::date))
  • Rows Removed by Filter: 701
6. 1.903 1,055.739 ↓ 2.1 1,093 1

Sort (cost=22,495.33..22,496.63 rows=520 width=48) (actual time=1,054.896..1,055.739 rows=1,093 loops=1)

  • Sort Key: rapgidis.tarih
  • Sort Method: quicksort Memory: 149kB
7. 1.883 1,053.836 ↓ 2.5 1,288 1

Subquery Scan on rapgidis (cost=22,455.35..22,471.87 rows=520 width=48) (actual time=1,046.181..1,053.836 rows=1,288 loops=1)

8. 3.943 1,051.953 ↓ 2.5 1,288 1

Finalize GroupAggregate (cost=22,455.35..22,466.67 rows=520 width=52) (actual time=1,046.178..1,051.953 rows=1,288 loops=1)

  • Group Key: gece.sirketid, gece.gun
9. 4.775 1,048.010 ↓ 8.2 2,518 1

Sort (cost=22,455.35..22,456.12 rows=306 width=52) (actual time=1,046.169..1,048.010 rows=2,518 loops=1)

  • Sort Key: gece.sirketid, gece.gun
  • Sort Method: quicksort Memory: 451kB
10. 8.962 1,043.235 ↓ 8.2 2,518 1

Gather (cost=22,402.94..22,442.72 rows=306 width=52) (actual time=957.765..1,043.235 rows=2,518 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
11. 46.076 1,034.273 ↓ 4.1 1,259 2

Partial GroupAggregate (cost=21,402.94..21,412.12 rows=306 width=52) (actual time=954.543..1,034.273 rows=1,259 loops=2)

  • Group Key: gece.sirketid, gece.gun
12. 79.038 988.197 ↓ 149.5 45,746 2

Sort (cost=21,402.94..21,403.70 rows=306 width=32) (actual time=954.508..988.197 rows=45,746 loops=2)

  • Sort Key: gece.sirketid, gece.gun
  • Sort Method: quicksort Memory: 5179kB
13. 390.118 909.159 ↓ 149.5 45,746 2

Hash Join (cost=3,973.87..21,390.31 rows=306 width=32) (actual time=195.926..909.159 rows=45,746 loops=2)

  • Hash Cond: ((gece.rezid = rez.id) AND (gece.sirketid = rez.sirketid) AND (gece.gun = rez.couttarih))
14. 323.869 323.869 ↑ 1.2 324,132 2

Parallel Seq Scan on geceleme gece (cost=0.00..13,124.14 rows=381,266 width=36) (actual time=0.012..323.869 rows=324,132 loops=2)

  • Filter: (NOT silinmis)
  • Rows Removed by Filter: 35855
15. 101.372 195.172 ↑ 1.0 102,177 2

Hash (cost=2,185.77..2,185.77 rows=102,177 width=16) (actual time=195.171..195.172 rows=102,177 loops=2)

  • Buckets: 131072 Batches: 1 Memory Usage: 5814kB
16. 93.800 93.800 ↑ 1.0 102,177 2

Seq Scan on rez (cost=0.00..2,185.77 rows=102,177 width=16) (actual time=0.016..93.800 rows=102,177 loops=2)

17. 2.805 1,094.980 ↓ 2.1 1,096 1

Sort (cost=22,493.80..22,495.08 rows=513 width=48) (actual time=1,093.388..1,094.980 rows=1,096 loops=1)

  • Sort Key: rapgelis.tarih
  • Sort Method: quicksort Memory: 149kB
18. 2.171 1,092.175 ↓ 2.5 1,284 1

Subquery Scan on rapgelis (cost=22,454.41..22,470.71 rows=513 width=48) (actual time=1,083.820..1,092.175 rows=1,284 loops=1)

19. 4.198 1,090.004 ↓ 2.5 1,284 1

Finalize GroupAggregate (cost=22,454.41..22,465.58 rows=513 width=52) (actual time=1,083.818..1,090.004 rows=1,284 loops=1)

  • Group Key: gece_1.sirketid, gece_1.gun
20. 6.723 1,085.806 ↓ 8.3 2,509 1

Sort (cost=22,454.41..22,455.16 rows=302 width=52) (actual time=1,083.786..1,085.806 rows=2,509 loops=1)

  • Sort Key: gece_1.sirketid, gece_1.gun
  • Sort Method: quicksort Memory: 449kB
21. 7.140 1,079.083 ↓ 8.3 2,509 1

Gather (cost=22,402.71..22,441.97 rows=302 width=52) (actual time=987.496..1,079.083 rows=2,509 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
22. 48.103 1,071.943 ↓ 4.2 1,254 2

Partial GroupAggregate (cost=21,402.71..21,411.77 rows=302 width=52) (actual time=983.864..1,071.943 rows=1,254 loops=2)

  • Group Key: gece_1.sirketid, gece_1.gun
23. 86.976 1,023.840 ↓ 151.5 45,746 2

Sort (cost=21,402.71..21,403.46 rows=302 width=32) (actual time=983.770..1,023.840 rows=45,746 loops=2)

  • Sort Key: gece_1.sirketid, gece_1.gun
  • Sort Method: quicksort Memory: 5248kB
24. 415.943 936.864 ↓ 151.5 45,746 2

Hash Join (cost=3,973.87..21,390.27 rows=302 width=32) (actual time=195.160..936.864 rows=45,746 loops=2)

  • Hash Cond: ((gece_1.rezid = rez_1.id) AND (gece_1.sirketid = rez_1.sirketid) AND (gece_1.gun = rez_1.cintarih))
25. 326.387 326.387 ↑ 1.2 324,132 2

Parallel Seq Scan on geceleme gece_1 (cost=0.00..13,124.14 rows=381,266 width=36) (actual time=0.015..326.387 rows=324,132 loops=2)

  • Filter: (NOT silinmis)
  • Rows Removed by Filter: 35855
26. 101.078 194.534 ↑ 1.0 102,177 2

Hash (cost=2,185.77..2,185.77 rows=102,177 width=16) (actual time=194.534..194.534 rows=102,177 loops=2)

  • Buckets: 131072 Batches: 1 Memory Usage: 5814kB
27. 93.456 93.456 ↑ 1.0 102,177 2

Seq Scan on rez rez_1 (cost=0.00..2,185.77 rows=102,177 width=16) (actual time=0.019..93.456 rows=102,177 loops=2)

28. 1.986 1,614.718 ↑ 1.2 1,096 1

Sort (cost=31,516.61..31,519.87 rows=1,301 width=48) (actual time=1,613.941..1,614.718 rows=1,096 loops=1)

  • Sort Key: rapgece.tarih
  • Sort Method: quicksort Memory: 152kB
29. 1.929 1,612.732 ↓ 1.0 1,327 1

Subquery Scan on rapgece (cost=31,397.28..31,449.32 rows=1,301 width=48) (actual time=1,605.128..1,612.732 rows=1,327 loops=1)

30. 3.741 1,610.803 ↓ 1.0 1,327 1

Finalize GroupAggregate (cost=31,397.28..31,436.31 rows=1,301 width=52) (actual time=1,605.125..1,610.803 rows=1,327 loops=1)

  • Group Key: gece_2.sirketid, gece_2.gun
31. 5.256 1,607.062 ↓ 2.0 2,566 1

Sort (cost=31,397.28..31,400.53 rows=1,301 width=52) (actual time=1,605.110..1,607.062 rows=2,566 loops=1)

  • Sort Key: gece_2.sirketid, gece_2.gun
  • Sort Method: quicksort Memory: 457kB
32. 7.863 1,601.806 ↓ 2.0 2,566 1

Gather (cost=31,186.87..31,329.98 rows=1,301 width=52) (actual time=1,596.482..1,601.806 rows=2,566 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
33. 393.574 1,593.943 ↑ 1.0 1,283 2

Partial HashAggregate (cost=30,186.87..30,199.88 rows=1,301 width=52) (actual time=1,592.590..1,593.943 rows=1,283 loops=2)

  • Group Key: gece_2.sirketid, gece_2.gun
34. 651.451 1,200.369 ↑ 1.2 324,132 2

Hash Join (cost=3,718.43..23,514.72 rows=381,266 width=32) (actual time=193.802..1,200.369 rows=324,132 loops=2)

  • Hash Cond: ((gece_2.rezid = rez_2.id) AND (gece_2.sirketid = rez_2.sirketid))
35. 355.745 355.745 ↑ 1.2 324,132 2

Parallel Seq Scan on geceleme gece_2 (cost=0.00..13,124.14 rows=381,266 width=36) (actual time=0.017..355.745 rows=324,132 loops=2)

  • Filter: (NOT silinmis)
  • Rows Removed by Filter: 35855
36. 98.733 193.173 ↑ 1.0 102,177 2

Hash (cost=2,185.77..2,185.77 rows=102,177 width=8) (actual time=193.173..193.173 rows=102,177 loops=2)

  • Buckets: 131072 Batches: 1 Memory Usage: 5016kB
37. 94.440 94.440 ↑ 1.0 102,177 2

Seq Scan on rez rez_2 (cost=0.00..2,185.77 rows=102,177 width=8) (actual time=0.021..94.440 rows=102,177 loops=2)