explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ihQd : Skyline_07Oct2019

Settings
# exclusive inclusive rows x rows loops node
1. 50.043 31,936.213 ↑ 20.9 6,779 1

Sort (cost=7,861,487.83..7,861,841.59 rows=141,502 width=104) (actual time=31,933.717..31,936.213 rows=6,779 loops=1)

  • Sort Key: ((pj.name)::character varying(255)) COLLATE "en_US", ((ui.lastname)::character varying(50)) COLLATE "en_US", ((ui.firstname)::character varying(50)) COLLATE "en_US", timeexpensecostbilling2_facts5.userduplicatename5, ((login.loginname)::character varying(255)) COLLATE "en_US", timeexpensecostbilling2_facts5.entrydate1
  • Sort Method: quicksort Memory: 1166kB
  • Buffers: shared hit=7045753 read=187126 written=11309
2.          

CTE eexpensecostbilling2_facts0cte

3. 12.163 31,854.736 ↑ 20.9 6,779 1

HashAggregate (cost=7,840,579.07..7,841,994.09 rows=141,502 width=49) (actual time=31,848.390..31,854.736 rows=6,779 loops=1)

  • Group Key: at.entrydate, at.userid, (NULL::uuid), (NULL::integer), ui_1.duplicatename, at.projectid
  • Buffers: shared hit=7045334 read=187071 written=11297
4. 4.877 31,842.573 ↑ 19.8 7,135 1

Hash Left Join (cost=15,396.25..7,838,102.78 rows=141,502 width=49) (actual time=4,859.174..31,842.573 rows=7,135 loops=1)

  • Hash Cond: (at.userid = ui_1.id)
  • Buffers: shared hit=7045334 read=187071 written=11297
5. 479.683 31,836.670 ↑ 19.8 7,135 1

Hash Join (cost=15,338.39..7,836,099.27 rows=141,502 width=48) (actual time=4,858.116..31,836.670 rows=7,135 loops=1)

  • Hash Cond: (at.projectid = pj_1.id)
  • Buffers: shared hit=7045331 read=187039 written=11296
6. 705.534 31,356.862 ↑ 21.8 1,418,503 1

Append (cost=15,308.15..7,409,060.48 rows=30,952,257 width=2,788) (actual time=407.967..31,356.862 rows=1,418,503 loops=1)

  • Buffers: shared hit=7045300 read=187037 written=11296
7. 5,401.963 19,516.808 ↑ 27.6 1,119,432 1

Nested Loop (cost=15,308.15..6,639,610.54 rows=30,842,837 width=2,797) (actual time=407.966..19,516.808 rows=1,119,432 loops=1)

  • Buffers: shared hit=5884606 read=28542 written=717
8.          

Initplan (forNested Loop)

9. 0.020 0.020 ↑ 1.0 1 1

Seq Scan on projectsysteminformation projectsysteminformation_2 (cost=0.00..1.01 rows=1 width=16) (actual time=0.019..0.020 rows=1 loops=1)

  • Buffers: shared read=1
10. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on projectsysteminformation projectsysteminformation_3 (cost=0.00..1.01 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1)

  • Buffers: shared hit=1
11. 783.786 6,278.673 ↓ 1.1 1,119,450 1

Hash Left Join (cost=15,305.71..189,651.01 rows=1,059,514 width=2,777) (actual time=407.852..6,278.673 rows=1,119,450 loops=1)

  • Hash Cond: (at.taskid = tk.id)
  • Buffers: shared hit=566319 read=26679 written=703
12. 712.944 5,467.885 ↓ 1.1 1,119,450 1

Hash Left Join (cost=14,494.10..178,444.46 rows=1,059,514 width=2,777) (actual time=380.666..5,467.885 rows=1,119,450 loops=1)

  • Hash Cond: (at.billingrateid = br.id)
  • Buffers: shared hit=566102 read=26490 written=700
13. 934.081 4,754.813 ↓ 1.1 1,119,450 1

Hash Left Join (cost=14,489.45..171,778.03 rows=1,059,514 width=2,753) (actual time=380.518..4,754.813 rows=1,119,450 loops=1)

  • Hash Cond: (pbr.id = pbrh.projectbillingrateid)
  • Join Filter: ((at.entrydate >= pbrh.effectivedate) AND (at.entrydate <= pbrh.enddate))
  • Rows Removed by Join Filter: 1037839
  • Buffers: shared hit=566100 read=26490 written=700
14. 792.751 3,676.837 ↓ 1.1 1,119,450 1

Hash Join (cost=10,833.94..132,066.19 rows=1,059,514 width=2,756) (actual time=236.431..3,676.837 rows=1,119,450 loops=1)

  • Hash Cond: (at.projectid = pj_2.id)
  • Buffers: shared hit=566098 read=25349 written=662
15. 930.697 2,874.914 ↓ 1.0 1,119,450 1

Merge Left Join (cost=10,284.06..116,724.40 rows=1,119,136 width=2,740) (actual time=227.198..2,874.914 rows=1,119,450 loops=1)

  • Merge Cond: ((at.billingrateid = pbr.billingrateid) AND (at.projectid = pbr.projectid))
  • Join Filter: (((pbr.billingrateid = $5) AND (at.userid = pbr.userid)) OR ((pbr.billingrateid <> $6) AND (pbr.userid IS NULL)))
  • Rows Removed by Join Filter: 29459
  • Buffers: shared hit=565681 read=25349 written=662
16. 1,563.022 1,563.022 ↓ 1.0 1,119,450 1

Index Scan using ixpta4billingrateid on dm_projecttimeallocation_facts at (cost=0.43..96,356.22 rows=1,119,136 width=2,724) (actual time=0.006..1,563.022 rows=1,119,450 loops=1)

  • Index Cond: ((projectid IS NOT NULL) AND (entrydate IS NOT NULL))
  • Buffers: shared hit=565676 read=24507 written=662
17. 327.180 381.195 ↓ 4.2 429,506 1

Sort (cost=10,282.73..10,536.04 rows=101,325 width=40) (actual time=227.066..381.195 rows=429,506 loops=1)

  • Sort Key: pbr.billingrateid, pbr.projectid
  • Sort Method: quicksort Memory: 10989kB
  • Buffers: shared hit=4 read=841
18. 54.015 54.015 ↑ 1.0 101,325 1

Seq Scan on projectbillingrate pbr (cost=0.00..1,858.25 rows=101,325 width=40) (actual time=0.004..54.015 rows=101,325 loops=1)

  • Buffers: shared hit=4 read=841
19. 3.256 9.172 ↑ 1.0 5,906 1

Hash (cost=476.06..476.06 rows=5,906 width=16) (actual time=9.172..9.172 rows=5,906 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 318kB
  • Buffers: shared hit=417
20. 5.916 5.916 ↑ 1.0 5,906 1

Seq Scan on project pj_2 (cost=0.00..476.06 rows=5,906 width=16) (actual time=0.005..5.916 rows=5,906 loops=1)

  • Buffers: shared hit=417
21. 75.312 143.895 ↑ 1.0 111,667 1

Hash (cost=2,259.67..2,259.67 rows=111,667 width=33) (actual time=143.895..143.895 rows=111,667 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 8389kB
  • Buffers: shared hit=2 read=1141 written=38
22. 68.583 68.583 ↑ 1.0 111,667 1

Seq Scan on projectbillingratehistory pbrh (cost=0.00..2,259.67 rows=111,667 width=33) (actual time=0.015..68.583 rows=111,667 loops=1)

  • Buffers: shared hit=2 read=1141 written=38
23. 0.071 0.128 ↑ 1.0 118 1

Hash (cost=3.18..3.18 rows=118 width=24) (actual time=0.128..0.128 rows=118 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=2
24. 0.057 0.057 ↑ 1.0 118 1

Seq Scan on billingrate br (cost=0.00..3.18 rows=118 width=24) (actual time=0.006..0.057 rows=118 loops=1)

  • Buffers: shared hit=2
25. 9.796 27.002 ↓ 1.0 18,029 1

Hash (cost=586.27..586.27 rows=18,027 width=8) (actual time=27.002..27.002 rows=18,029 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 891kB
  • Buffers: shared hit=217 read=189 written=3
26. 17.206 17.206 ↓ 1.0 18,029 1

Seq Scan on task tk (cost=0.00..586.27 rows=18,027 width=8) (actual time=0.007..17.206 rows=18,029 loops=1)

  • Buffers: shared hit=217 read=189 written=3
27. 7,836.150 7,836.150 ↑ 14.0 1 1,119,450

Index Scan using ixtsuseridstartdateenddate on timesheet dmvts (cost=0.42..1.07 rows=14 width=32) (actual time=0.007..0.007 rows=1 loops=1,119,450)

  • Index Cond: ((userid = at.userid) AND (at.entrydate >= startdate) AND (at.entrydate <= enddate))
  • Buffers: shared hit=5318287 read=1863 written=14
28. 19.558 166.413 ↓ 20.4 22,641 1

Subquery Scan on *SELECT* 2 (cost=1,148.29..2,612.95 rows=1,112 width=2,639) (actual time=30.462..166.413 rows=22,641 loops=1)

  • Buffers: shared hit=14002 read=1152 written=18
29. 74.750 146.855 ↓ 20.4 22,641 1

Hash Join (cost=1,148.29..2,601.83 rows=1,112 width=2,639) (actual time=30.457..146.855 rows=22,641 loops=1)

  • Hash Cond: (ee.expenseid = ex.id)
  • Buffers: shared hit=14002 read=1152 written=18
30.          

Initplan (forHash Join)

31. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on systeminformation (cost=0.00..1.01 rows=1 width=4) (actual time=0.010..0.010 rows=1 loops=1)

  • Buffers: shared read=1
32. 15.949 41.757 ↓ 2.2 22,641 1

Merge Join (cost=1.13..1,202.85 rows=10,070 width=2,620) (actual time=0.050..41.757 rows=22,641 loops=1)

  • Merge Cond: (pj_3.id = ee.projectid)
  • Buffers: shared hit=13999 read=839 written=18
33. 6.004 6.004 ↑ 1.0 5,879 1

Index Scan using project_pkey on project pj_3 (cost=0.28..538.87 rows=5,906 width=12) (actual time=0.010..6.004 rows=5,879 loops=1)

  • Buffers: shared hit=5382
34. 19.804 19.804 ↑ 1.0 22,641 1

Index Scan using ixeeprojectid on expenseentry ee (cost=0.29..1,176.71 rows=22,649 width=2,608) (actual time=0.023..19.804 rows=22,641 loops=1)

  • Index Cond: (projectid IS NOT NULL)
  • Buffers: shared hit=8617 read=839 written=18
35. 6.991 30.338 ↓ 9.0 20,766 1

Hash (cost=1,117.46..1,117.46 rows=2,295 width=23) (actual time=30.338..30.338 rows=20,766 loops=1)

  • Buckets: 32768 (originally 4096) Batches: 1 (originally 1) Memory Usage: 1412kB
  • Buffers: shared hit=3 read=313
36. 13.377 23.347 ↓ 9.0 20,766 1

Hash Join (cost=1.70..1,117.46 rows=2,295 width=23) (actual time=0.052..23.347 rows=20,766 loops=1)

  • Hash Cond: (ex.reimbursementcurrencyid = exchangerate.fixedcurrencyid)
  • Join Filter: ((ex.expensedate >= exchangerate.effectivedate) AND (ex.expensedate <= exchangerate.enddate))
  • Buffers: shared hit=3 read=313
37. 9.939 9.939 ↓ 1.0 20,766 1

Seq Scan on expense ex (cost=0.00..573.51 rows=20,657 width=20) (actual time=0.008..9.939 rows=20,766 loops=1)

  • Filter: ((expensedate)::date IS NOT NULL)
  • Buffers: shared hit=2 read=312
38. 0.006 0.031 ↑ 1.0 7 1

Hash (cost=1.61..1.61 rows=7 width=19) (actual time=0.031..0.031 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1 read=1
39. 0.025 0.025 ↑ 1.0 7 1

Seq Scan on exchangerate (cost=0.00..1.61 rows=7 width=19) (actual time=0.017..0.025 rows=7 loops=1)

  • Filter: (variablecurrencyid = $4)
  • Rows Removed by Filter: 42
  • Buffers: shared hit=1 read=1
40. 0.001 0.003 ↓ 0.0 0 1

Subquery Scan on *SELECT* 3 (cost=0.57..1,158.52 rows=739 width=76) (actual time=0.003..0.003 rows=0 loops=1)

41. 0.001 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.57..1,151.13 rows=739 width=76) (actual time=0.002..0.002 rows=0 loops=1)

42. 0.000 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.29..723.92 rows=739 width=64) (actual time=0.001..0.001 rows=0 loops=1)

43. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on projectteammemberallocation ptma (cost=0.00..20.20 rows=1,015 width=52) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (date IS NOT NULL)
44. 0.000 0.000 ↓ 0.0 0

Index Scan using projectteammember_pkey on projectteammember ptm (cost=0.29..0.68 rows=1 width=44) (never executed)

  • Index Cond: (id = ptma.projectteammemberid)
  • Filter: ((userid IS NOT NULL) OR (placeholderprojectroleid IS NOT NULL))
45. 0.000 0.000 ↓ 0.0 0

Index Scan using project_pkey on project pj_4 (cost=0.28..0.32 rows=1 width=12) (never executed)

  • Index Cond: (id = ptm.projectid)
46. 254.152 10,968.104 ↓ 2.6 276,430 1

Subquery Scan on *SELECT* 4 (cost=430,470.84..457,250.09 rows=107,569 width=143) (actual time=9,475.592..10,968.104 rows=276,430 loops=1)

  • Buffers: shared hit=1146692 read=157343 written=10561
47. 1,046.906 10,713.952 ↓ 2.6 276,430 1

Hash Left Join (cost=430,470.84..456,174.40 rows=107,569 width=143) (actual time=9,475.587..10,713.952 rows=276,430 loops=1)

  • Hash Cond: (bi.id = iibi.billingitemid)
  • Buffers: shared hit=1146692 read=157343 written=10561
48.          

Initplan (forHash Left Join)

49. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on projectsysteminformation (cost=0.00..1.01 rows=1 width=16) (actual time=0.005..0.006 rows=1 loops=1)

  • Buffers: shared hit=1
50. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on projectsysteminformation projectsysteminformation_1 (cost=0.00..1.01 rows=1 width=16) (actual time=0.001..0.002 rows=1 loops=1)

  • Buffers: shared hit=1
51. 272.315 9,667.036 ↓ 2.6 276,430 1

Hash Right Join (cost=430,434.75..436,909.42 rows=107,569 width=143) (actual time=9,475.512..9,667.036 rows=276,430 loops=1)

  • Hash Cond: (aggm.billingitemid = bi.id)
  • Filter: (aggm.uri IS NULL)
  • Rows Removed by Filter: 29952
  • Buffers: shared hit=1146692 read=157343 written=10561
52. 154.871 154.871 ↓ 1.0 103,061 1

Index Scan using ixbiminvoicinghint on billingitem2metadata aggm (cost=0.42..5,869.10 rows=100,134 width=64) (actual time=0.044..154.871 rows=103,061 loops=1)

  • Buffers: shared hit=77642 read=2780 written=29
53. 311.577 9,239.850 ↓ 1.1 306,382 1

Hash (cost=426,884.97..426,884.97 rows=283,949 width=143) (actual time=9,239.850..9,239.850 rows=306,382 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 61772kB
  • Buffers: shared hit=1069050 read=154563 written=10532
54. 356.969 8,928.273 ↓ 1.1 306,382 1

Hash Left Join (cost=130,881.61..426,884.97 rows=283,949 width=143) (actual time=3,250.287..8,928.273 rows=306,382 loops=1)

  • Hash Cond: (bidm.timesheetid = t.id)
  • Buffers: shared hit=1069050 read=154563 written=10532
55. 234.717 8,496.942 ↓ 1.1 306,382 1

Hash Left Join (cost=126,813.43..419,122.47 rows=283,949 width=155) (actual time=3,175.449..8,496.942 rows=306,382 loops=1)

  • Hash Cond: (bidm.billingrateid = br_1.id)
  • Buffers: shared hit=1067756 read=154563 written=10532
56. 981.277 8,262.147 ↓ 1.1 306,382 1

Hash Right Join (cost=126,808.78..417,360.06 rows=283,949 width=147) (actual time=3,175.356..8,262.147 rows=306,382 loops=1)

  • Hash Cond: (bi2m.billingitemid = bi.id)
  • Buffers: shared hit=1067754 read=154563 written=10532
57. 4,107.378 4,107.378 ↑ 1.0 1,182,130 1

Index Scan using ixbimbillingitemidkey on billingitem2metadata bi2m (cost=0.43..283,372.14 rows=1,186,353 width=32) (actual time=0.031..4,107.378 rows=1,182,130 loops=1)

  • Buffers: shared hit=1037964 read=150267 written=10523
58. 182.617 3,173.492 ↓ 1.1 306,382 1

Hash (cost=123,258.99..123,258.99 rows=283,949 width=131) (actual time=3,173.492..3,173.492 rows=306,382 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 55368kB
  • Buffers: shared hit=29790 read=4296 written=9
59. 386.625 2,990.875 ↓ 1.1 306,382 1

Hash Right Join (cost=115,607.43..123,258.99 rows=283,949 width=131) (actual time=2,576.124..2,990.875 rows=306,382 loops=1)

  • Hash Cond: (pbrh_1.projectbillingrateid = pbr_1.id)
  • Join Filter: ((bi.entrydate >= pbrh_1.effectivedate) AND (bi.entrydate <= pbrh_1.enddate))
  • Rows Removed by Join Filter: 1037839
  • Buffers: shared hit=29790 read=4296 written=9
60. 29.990 29.990 ↑ 1.0 111,667 1

Seq Scan on projectbillingratehistory pbrh_1 (cost=0.00..2,259.67 rows=111,667 width=24) (actual time=0.018..29.990 rows=111,667 loops=1)

  • Buffers: shared hit=2 read=1141 written=9
61. 157.675 2,574.260 ↓ 1.1 306,382 1

Hash (cost=112,058.07..112,058.07 rows=283,949 width=143) (actual time=2,574.260..2,574.260 rows=306,382 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 58900kB
  • Buffers: shared hit=29788 read=3155
62. 311.840 2,416.585 ↓ 1.1 306,382 1

Merge Left Join (cost=108,422.85..112,058.07 rows=283,949 width=143) (actual time=1,882.629..2,416.585 rows=306,382 loops=1)

  • Merge Cond: ((bidm.billingrateid = pbr_1.billingrateid) AND (bidm.projectid = pbr_1.projectid))
  • Join Filter: (((pbr_1.billingrateid = $0) AND (bidm.userid = pbr_1.userid)) OR ((pbr_1.billingrateid <> $1) AND (pbr_1.userid IS NULL)))
  • Rows Removed by Join Filter: 29459
  • Buffers: shared hit=29788 read=3155
63. 541.033 1,884.345 ↓ 1.1 306,382 1

Sort (cost=98,139.53..98,849.40 rows=283,949 width=127) (actual time=1,756.615..1,884.345 rows=306,382 loops=1)

  • Sort Key: bidm.billingrateid, bidm.projectid
  • Sort Method: quicksort Memory: 93047kB
  • Buffers: shared hit=29782 read=2314
64. 169.303 1,343.312 ↓ 1.1 306,382 1

Hash Join (cost=25,923.69..72,420.46 rows=283,949 width=127) (actual time=296.920..1,343.312 rows=306,382 loops=1)

  • Hash Cond: (bidm.projectid = pj_5.id)
  • Buffers: shared hit=29782 read=2314
65. 519.273 1,169.115 ↑ 1.0 306,382 1

Hash Join (cost=25,373.80..67,880.51 rows=306,821 width=115) (actual time=291.984..1,169.115 rows=306,382 loops=1)

  • Hash Cond: (bidm.billingitemid = bi.id)
  • Buffers: shared hit=29365 read=2314
66. 359.699 359.699 ↑ 1.0 1,233,025 1

Seq Scan on billingitem2denormalizedmetadata bidm (cost=0.00..34,814.31 rows=1,233,117 width=104) (actual time=0.005..359.699 rows=1,233,025 loops=1)

  • Filter: (userid IS NOT NULL)
  • Rows Removed by Filter: 513
  • Buffers: shared hit=21503 read=975
67. 117.214 290.143 ↑ 1.0 306,895 1

Hash (cost=21,536.94..21,536.94 rows=306,949 width=27) (actual time=290.143..290.143 rows=306,895 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 22254kB
  • Buffers: shared hit=7862 read=1339
68. 172.929 172.929 ↑ 1.0 306,895 1

Seq Scan on billingitem2 bi (cost=0.00..21,536.94 rows=306,949 width=27) (actual time=0.007..172.929 rows=306,895 loops=1)

  • Filter: (isbillable AND (entrydate IS NOT NULL))
  • Rows Removed by Filter: 926643
  • Buffers: shared hit=7862 read=1339
69. 1.794 4.894 ↑ 1.0 5,906 1

Hash (cost=476.06..476.06 rows=5,906 width=12) (actual time=4.894..4.894 rows=5,906 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 318kB
  • Buffers: shared hit=417
70. 3.100 3.100 ↑ 1.0 5,906 1

Seq Scan on project pj_5 (cost=0.00..476.06 rows=5,906 width=12) (actual time=0.004..3.100 rows=5,906 loops=1)

  • Buffers: shared hit=417
71. 189.962 220.400 ↓ 4.2 429,506 1

Sort (cost=10,282.73..10,536.04 rows=101,325 width=40) (actual time=125.928..220.400 rows=429,506 loops=1)

  • Sort Key: pbr_1.billingrateid, pbr_1.projectid
  • Sort Method: quicksort Memory: 10989kB
  • Buffers: shared hit=4 read=841
72. 30.438 30.438 ↑ 1.0 101,325 1

Seq Scan on projectbillingrate pbr_1 (cost=0.00..1,858.25 rows=101,325 width=40) (actual time=0.008..30.438 rows=101,325 loops=1)

  • Buffers: shared hit=4 read=841
73. 0.050 0.078 ↑ 1.0 118 1

Hash (cost=3.18..3.18 rows=118 width=24) (actual time=0.078..0.078 rows=118 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=2
74. 0.028 0.028 ↑ 1.0 118 1

Seq Scan on billingrate br_1 (cost=0.00..3.18 rows=118 width=24) (actual time=0.005..0.028 rows=118 loops=1)

  • Buffers: shared hit=2
75. 39.293 74.362 ↓ 1.0 123,299 1

Hash (cost=2,526.97..2,526.97 rows=123,297 width=20) (actual time=74.362..74.362 rows=123,299 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 7286kB
  • Buffers: shared hit=1294
76. 35.069 35.069 ↓ 1.0 123,299 1

Seq Scan on timesheet t (cost=0.00..2,526.97 rows=123,297 width=20) (actual time=0.005..35.069 rows=123,299 loops=1)

  • Buffers: shared hit=1294
77. 0.001 0.002 ↓ 0.0 0 1

Hash (cost=20.70..20.70 rows=1,070 width=32) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 16kB
78. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on invoiceitembillingitems iibi (cost=0.00..20.70 rows=1,070 width=32) (actual time=0.001..0.001 rows=0 loops=1)

79. 0.033 0.125 ↓ 1.0 28 1

Hash (cost=29.90..29.90 rows=27 width=4) (actual time=0.125..0.125 rows=28 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=31 read=2
80. 0.092 0.092 ↓ 1.0 28 1

Index Scan using ixprjclientid on project pj_1 (cost=0.28..29.90 rows=27 width=4) (actual time=0.037..0.092 rows=28 loops=1)

  • Index Cond: (clientid = ANY ('{806,914,992}'::integer[]))
  • Buffers: shared hit=31 read=2
81. 0.277 1.026 ↑ 1.0 1,016 1

Hash (cost=45.16..45.16 rows=1,016 width=5) (actual time=1.026..1.026 rows=1,016 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 48kB
  • Buffers: shared hit=3 read=32 written=1
82. 0.749 0.749 ↑ 1.0 1,016 1

Seq Scan on userinfo ui_1 (cost=0.00..45.16 rows=1,016 width=5) (actual time=0.006..0.749 rows=1,016 loops=1)

  • Buffers: shared hit=3 read=32 written=1
83. 6.567 31,886.170 ↑ 20.9 6,779 1

Hash Left Join (cost=666.58..7,387.92 rows=141,502 width=104) (actual time=31,859.532..31,886.170 rows=6,779 loops=1)

  • Hash Cond: (timeexpensecostbilling2_facts5.projectid6 = pj.id)
  • Buffers: shared hit=7045753 read=187126 written=11309
84. 6.845 31,872.219 ↑ 20.9 6,779 1

Hash Left Join (cost=116.69..4,892.38 rows=141,502 width=71) (actual time=31,852.093..31,872.219 rows=6,779 loops=1)

  • Hash Cond: (timeexpensecostbilling2_facts5.userid2 = ui.id)
  • Buffers: shared hit=7045336 read=187126 written=11309
85. 31,861.702 31,861.702 ↑ 20.9 6,779 1

CTE Scan on eexpensecostbilling2_facts0cte timeexpensecostbilling2_facts5 (cost=0.00..2,830.04 rows=141,502 width=49) (actual time=31,848.394..31,861.702 rows=6,779 loops=1)

  • Buffers: shared hit=7045334 read=187071 written=11297
86. 0.651 3.672 ↑ 1.0 1,016 1

Hash (cost=103.99..103.99 rows=1,016 width=26) (actual time=3.672..3.672 rows=1,016 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
  • Buffers: shared hit=2 read=55 written=12
87. 0.994 3.021 ↑ 1.0 1,016 1

Hash Left Join (cost=44.86..103.99 rows=1,016 width=26) (actual time=1.291..3.021 rows=1,016 loops=1)

  • Hash Cond: (ui.id = login.userid)
  • Buffers: shared hit=2 read=55 written=12
88. 0.783 0.783 ↑ 1.0 1,016 1

Seq Scan on userinfo ui (cost=0.00..45.16 rows=1,016 width=18) (actual time=0.026..0.783 rows=1,016 loops=1)

  • Buffers: shared hit=2 read=33 written=7
89. 0.519 1.244 ↑ 1.0 1,016 1

Hash (cost=32.16..32.16 rows=1,016 width=12) (actual time=1.244..1.244 rows=1,016 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 54kB
  • Buffers: shared read=22 written=5
90. 0.725 0.725 ↑ 1.0 1,016 1

Seq Scan on login (cost=0.00..32.16 rows=1,016 width=12) (actual time=0.017..0.725 rows=1,016 loops=1)

  • Buffers: shared read=22 written=5
91. 3.345 7.384 ↑ 1.0 5,906 1

Hash (cost=476.06..476.06 rows=5,906 width=41) (actual time=7.384..7.384 rows=5,906 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 495kB
  • Buffers: shared hit=417
92. 4.039 4.039 ↑ 1.0 5,906 1

Seq Scan on project pj (cost=0.00..476.06 rows=5,906 width=41) (actual time=0.006..4.039 rows=5,906 loops=1)

  • Buffers: shared hit=417
Planning time : 28.996 ms
Execution time : 31,995.021 ms